<img src="https://track.adform.net/Serving/TrackPoint/?pm=268420" width="1" height="1" alt="">
11. oktober 2018 Skrevet af: Martin Schmidt Del med en ven     

Efter september 2019 stopper Microsoft supporten af SQL Server 2008 og 2008 R2. Hvad betyder det så for dig? Det betyder, at der ikke længere vil være hjælp at hente i forhold support, rettelser og sikkerhed, hvilket kan koste dig dyrt. Hvad gør du så, hvis du har en SQL 2008 R2 server? Læs med, når to af vores specialister giver deres bud på, hvordan du på bedste vis opgraderer din SQL server - og hvorfor du skal opgradere, selvom det virker!

[læs mere]
  
9. december 2015 Skrevet af: Martin Kolding Pedersen Del med en ven     

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]
  
17. februar 2014 Skrevet af: Martin Schmidt Del med en ven     

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]
  
15. januar 2014 Skrevet af: Martin Schmidt Del med en ven     

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]
  
10. november 2013 Skrevet af: Martin Schmidt Del med en ven     

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]
  
4. november 2013 Skrevet af: Martin Schmidt Del med en ven     

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]
  
1. november 2013 Skrevet af: Martin Schmidt Del med en ven     

Where did I put my Sales table?

[læs mere]