<img src="https://track.adform.net/Serving/TrackPoint/?pm=268420" width="1" height="1" alt="">
af Martin Kolding Pedersen | 9. december 2015

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 forventet mere, eller om SSRS bare er blevet endnu bedre og vildere?

[læs mere]

SQL Microsoft data datazen ssrs

af Martin Schmidt | 17. februar 2014

SQL server file initialization

Data and log files are initialized to overwrite any existing data left on the disk from previously deleted files. Data and log files are first initialized by filling the files with zeros when you perform one of the following operations:

  • Create a database
  • Add files, log or data, to an existing database
  • Increase the size of an existing file (including autogrow operations)
  • Restore a database or filegroup
[læs mere]

SQL Trace Flags Performance tuning SQL Server

af Martin Schmidt | 15. januar 2014

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 space used by write only indexes. The usage stats from the indexes is pretty easy to get from ‘sys.dm_db_index_usage_stats’ and if you join the DMV ‘sys.dm_db_partition_stats’ onto that, you can from the column ‘used_page_count’ calculate the number of bytes that the particular indexes is wasting.

[læs mere]

SQL SQL Server

af Martin Schmidt | 10. november 2013

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 absolutely necessary otherwise don’t. Here is a list of the documented trace flags that you can use with SQL Server. That is the documented once, besides that there is a list of undocumented trace flags – and it is as you might already have guessed one of these I’ll be blogging about today.

[læs mere]

SQL Trace Flags T-SQL SQL Server

af Martin Schmidt | 4. november 2013

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. Now the BACKUP command support “TO URL” when you specify a backup device. This gives you the option to use an Azure Storage account as destinations for your backups.

[læs mere]

SQL Azure T-SQL SQL Server Cloud

af Martin Schmidt | 1. november 2013

Filegroup confusion

Where did I put my Sales table?

[læs mere]

SQL Data Management T-SQL SQL Server