Meet Thomas Kejser in Aarhus
This is normally not a place where we advertise for events held by our friends, but today I’ll make an...
2012-09-06
749 reads
SQL Rally 2012 Nordic
The Nordic SQL Server event of the year is getting closer and closer. YES it is SQL Rally Nordic that...
2012-06-26
866 reads
DBCC CHECKDB
Quite often when I see a new SQL Server setup, a CHECKDB has never been run on the databases. It’s...
2012-05-31 (first published: 2012-05-29)
118,641 reads
Backup compression using IBM TDP for SQL Server
If you are using SQL Server 2008 enterprise/datacenter edition, or SQL Server 2008 R2 standard or above, you are in...
2012-05-15
1,895 reads
Troubleshooting Database mail
Last week we blogged about “How to configure Database mail” – this week we’ll have a closer look at what to...
2012-05-08
9,694 reads
Automatic page repair with SQL Server Mirroring
Now and then my colleagues and I find our selves in the middle of a discussion about SQL Server Mirroring...
2012-05-01 (first published: 2012-04-24)
3,170 reads
How to Configure Database mail
In my daily job as a SQL Server consultant I go to a lot of places, many days on the...
2012-05-01
7,830 reads
Visualize Wait stats with Microsoft Excel
In our blog post last week: Instance Wide Wait Stats we promised to show You how to visualize the collected...
2012-04-18
1,146 reads
Instance Wide Wait Stats
Over the last many weeks we have written quite a few blog post about query debugging, using Extended Events, Blocking...
2012-04-11 (first published: 2012-04-09)
2,460 reads
Nifty queries using a Numbers helper table
(The complete usable code is in the very bottom of this blog post)
Some of you may have seen this “numbers...
2012-04-09 (first published: 2012-04-04)
4,590 reads
Blogs
Giving a Security Webinar this Wednesday
By Brian Kelley
If you haven’t already signed up, on November 29, 2023, at 11 AM Eastern...
Write to backup block blob device failed. Device has reached its limit of allowed blocks.
Picture this, you’re happily backing up your database to a Azure blob storage until...
Comparing Two Scripts with kdiff3
By Steve Jones
I had a customer recently ask if SQL Compare could show them the differences...
Forums
activity monitor is showing two diffrent spid for one big stored procedure.
hi xyz.bat this is called from microsoft sheduler. the contenct of .bat is followng....
Commit transaction inside loops
Hello, our users are complaining about blocking during a delete loop so I'm thinking...
The subscription contains parameter values that are not valid
Hi, I've got an issue on SSRS where I have a daily subscription that...
Ask SSC