Archive for

T-SQL Random Date from Date Range

Here’s a quick bit of code that I find useful for generating test data for dates within a given date range. It uses a combination of the rand, newid, checksum, datediif and dateadd functions. First we calculate the checksum on a newid(). This generates a random integer value. Next we apply the rand function to … Continue reading

Tabular SSAS Memory Settings

Memory settings in Analysis Services might be an important tuning of a correct setup, both for production and developer machines. Analysis Services 2012 can be installed in different ways and the new Tabular instance has new memory settings that are important to know. I expect that many servers (and developer’s workstations) will have at least … Continue reading