Bliv klogere med Inspari

På denne blog beriger vi ikke data, vi beriger mennesker. Få indsigt i samt tips og tricks om bi - business intelligence, big data, datawarehouse, datamining mm.

Posts om

sql

SQL 2008 R2 ryger ud af support

Efter september 2019 stopper Microsoft supporten af SQL Server 2008 og 2008 R2. Hvad betyder det...

TRUNCATE TABLE with partitions

With SQL Server 2016 we’ll see an enhancement to the TRUNCATE TABLE statement. The TRUNCATE...

Endelig kom opdateringen af MS reporting services - læs dommen her!

Microsoft SQL Server Reporting Services har fået en overhaling. Spørgsmålet er, om vi kunne have...

SQL server file initialization

Data and log files are initialized to overwrite any existing data left on the disk from...

How much space are you wasting?

A few weeks back I was visiting a client who asked me to write a script that could tell him the...

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

Filegroup confusion

Where did I put my Sales table?