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
865 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,640 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,890 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,678 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,826 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,585 reads
Blogs
SQL Saturday Denver 2023–VCS Primer for the Database slides
By Steve Jones
My slides are here: VCS Primer Denver 2023 This was an overview of what...
Future Data Driven 2023 is This Week
By Steve Jones
The Future Data Driven 2023 virtual conference is coming on Wednesday, September 27. Register...
Opening the SQL Prompt Command Palette
By Steve Jones
A few years ago SQL Prompt added a command palette to let you search...
Forums
Convert columns result into rows with comma and single quotes
Hi All, Hi All, I want to convert columns result into rows with comma....
Does multi-subnet with standardeditionofsqlserver supports DB Mirror Or AG group
Does multi subnet failover with standard edition of sqlserver supports DB Mirror or AG...
post steps for Table PARTIONING
Any one did Table partitioning in Prod, please list steps here. we have a...
Ask SSC