Bliv klogere med Inspari

På bloggen finder du inspiration og gode råd til at gøre data til et aktiv i din organisation.

Posts om

sql server 2012

Enrich your Data Warehouse dimensions

As a Data Warehouse Consultant, I´m often asked the following by customers: “Is it possible to...

Are you wasting storage space?

Do you see tables taking up much more space than expected? And when looking at the table design...

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...

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...

New string conversion functions

SQL Server 2012 contains two new string conversion functions. PARSE and TRY_PARSE. These two...