Enrich your Data Warehouse dimensions
As a Data Warehouse Consultant, I´m often asked the following by customers: “Is it possible to...
Posts om
sql server 2012
Are you wasting storage space?
Do you see tables taking up much more space than expected? And when looking at the table design and...
Special characters in SSAS Name properties
Have you ever got the request to use special characters, like ( ) / & %, in the names of your...
Throw your server off balance
…Balanced Power Plan that is
Caring about nature is most certainly a likable trait. But did you...
dbcc checkdb
Almost every one of my customers is running a backup of their databases (you would be surprised if...
FileTables in SQL Server 2012
SQL Server 2008 gave us filestreams. Filestream saves files on the disk instead of using BLOB’s....
Change data capture in SSIS SQL Server 2012
SQL Server 2012 gives us some new SSIS components that make reading from the CDC tables created by...
New string conversion functions
SQL Server 2012 contains two new string conversion functions. PARSE and TRY_PARSE. These two...