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

t-sql

Enrich your Data Warehouse dimensions

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

SQL Server trace flags

Normally I’m not a big fan of using trace flags, my advice is only to use these when it is...

Backup On-Premises SQL Server Databases to Azure Storage

With the release of SQL Server 2012 SP1 CU2, an enhancement to the BACKUP command has been added....

Filegroup confusion

Where did I put my Sales table?

Using table variables in a SSIS data source

Every now and then standard queries just aren’t sufficient as data sources and therefore it might...

Output row values effected by an update

Have you ever thought about logging the before and after value for an update or delete? It’s...

Updateable views

By default view are updateable. It means you can write a TSQL update statement against a view just...

Avoid schema changes corrupting your views

Maybe you are using views as a layer between your tables and your users. If you have a lot of views...

dbcc checkdb

Almost every one of my customers is running a backup of their databases (you would be surprised if...

New string conversion functions

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