SQL Server 2008 Service Pack 3 Cumulative Update 9
Microsoft has released SQL Server 2008 Service Pack 3 Cumulative Update 9, which is build 10.00.5829. As you might expect...
2013-01-25
1,577 reads
Type 2 SCD with SQL Merge
I was going through some notes I had from previous projects and came across a sample script for created a...
2013-01-25
10,581 reads
Reblog: January 18 to January 24
Welcome to this Friday’s reblog summary post. The aim of these posts is to bring some old posts that newer...
2013-01-25
1,056 reads
New Years Aspirations – Kevin Kline – Presenting
I’ve been very privileged to be able to work alongside Kevin on a few projects during our time together at...
2013-01-25
887 reads
Replication Latency
I've used Replication a lot over the years and contrary to the opinions of most DBA’s I know, I think it...
2013-01-25
2,093 reads
SQL Server Non Clustered Index Tutorial for Beginners
In the past I have come across comments like SQL Server is slow (small tables) or interviews where someone had...
2013-01-25
2,410 reads
Backup SQL database directly to Azure Storage
There is a new CU update for SQL 2012 SP1 and I noticed a very interesting new feature described in...
2013-01-25
1,521 reads
Day 20 of 31 Days of Disaster Recovery: The Case of the Backups That Wouldn’t Restore
I have decided to spend day 20 of my 31 Days of Disaster Recovery series by relating a true tale...
2013-01-25
1,140 reads
I'm an Administrator Why Can't I Copy Files
Hello Dear Reader! I've been working on setting up a virtual environment for quite some time. When last I wrote...
2013-01-31 (first published: 2013-01-24)
2,799 reads
Audit Configuration Changes
Do you know the last time a Server Property was changed on your instances of SQL Server? Are you wondering when the setting for max degree of parallelism was...
2013-01-24
11 reads
Blogs
T-SQL Tuesday #201 Round-Up: Temp Tables, Friend or Foe?
By ReviewMyDB
The T-SQL Tuesday #201 round-up: nine bloggers on whether temp tables are a friend...
Monday Monitor Tips: Configuring Access to the MCP Server
By Steve Jones
I have been experimenting with MCP servers in a few ways, including the Redgate...
The GO Barrier: Why SSMS Multi-Server Query Waits for the Slowest Connection
By Zikato
I deployed a schema change to 30 servers using multi-server query and deploy-at-low-priority. Small...
Forums
Admin Rights for Everyone
Comments posted to this topic are about the item Admin Rights for Everyone
Kerberos Authentication for Aurora PostgreSQL: Mapping AD Groups to Database Roles
Comments posted to this topic are about the item Kerberos Authentication for Aurora PostgreSQL:...
RegEx Functions I
Comments posted to this topic are about the item RegEx Functions I
Question of the Day
RegEx Functions I
Which of these RegEx functions need compatibility level 170 in SQL Server 2025?
See possible answers