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
862 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,634 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,883 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,608 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,167 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,812 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,575 reads
Blogs
Flyway Desktop Projects for My PoC
By Steve Jones
In a previous post, I set up the basic databases for the PoC project...
Daily Coping 30 Jan 2023
By Steve Jones
Today’s coping tip is to plan something fun and invite others to join you....
Migrating or Recovering a TDE Protected Database
When encrypting a database with Transparent Data Encryption (TDE), a vital consideration is to...
Forums
Database copies (cross environment) and sizing strategies for 2019
I'm sure this has been asked many, many, many times and hoping several optimal...
TSQL to determine status of subscription reinitialization
How do I determine the initialization status of a subscription with T-SQL -- i.e,...
migration
Has anyone migrated databases from on premise SQL Server to Azure Managed instance? If...
Ask SSC