Partitioning Basics – Part 3 – Switching Data
This post follows on from Partitioning Basics – Part 2
In this final part, I want to go through how partitions can...
2014-06-24 (first published: 2014-06-20)
3,247 reads
The DBA Who Came In From The Cold
Partitioning Basics – Part 2 – Splitting/Merging Partitions
This post follows on from the previous post Partitioning Basics – Part 1
Let’s have a look at the partitions setup in...
2014-06-12
1,067 reads
Partitioning Basics – Part 1 – Creating Partitions
Partitioned tables can be a quick and efficient way to (amongst other things) archive data. In the next couple of...
2014-06-09 (first published: 2014-06-04)
5,097 reads
Error Log Management
Thought I’d write a quick post about managing error logs within SQL Server. Good error log management is essential for...
2014-05-09
2,435 reads
Database Design Guidelines For Developers
One of the developers that I work with asked me to write a “brief” (really brief) guide on database design....
2014-04-07 (first published: 2014-04-03)
25,884 reads
SQL Server 2014 RTM
The new version of SQL Server will be here on Tuesday.
(Someone at Microsoft has a sense of humour in releasing...
2014-03-30
1,518 reads
Index Fragmentation
So you’ve setup a bunch of indexes in your database to tune the queries coming in. They’re all running much...
2014-03-13
2,493 reads
Who are your victims?
Or….deadlock notifications.
In my previous post I talked about having your own database(s) and what information you could be collecting. One...
2014-02-11
601 reads
Your own personal space
Somewhere to relax, get away from it all (by all I mean pesky Developers wanting code deployed on a bleeding...
2014-01-30
1,031 reads
Shutting down multiple servers with Powershell
I’ve recently helped a company move their infrastructure to a new data centre. Part of this involved shutting down a...
2014-01-09
561 reads
Blogs
Fighting Procrastination?
By Brian Kelley
Here is another short video (~ 15 minutes). This is by the author of...
A Fun Prize at the PASS Data Community Summit
By Steve Jones
I had a briefing for the 2026 PASS Data Community Summit, which is just...
How to Measure AI Value: A 6-Branch AI Maturity Model for Use Cases and Agents
Your AI is busy. But do you know what it's worth? Most companies can...
Forums
SQL Server 2025 Server-level Roles
Comments posted to this topic are about the item SQL Server 2025 Server-level Roles
Stairway to DAX and Power BI - Level 29: The DAX Combine & Aggregate Functions
Comments posted to this topic are about the item Stairway to DAX and Power...
AI Is Improving Security
Comments posted to this topic are about the item AI Is Improving Security
Question of the Day
SQL Server 2025 Server-level Roles
In SQL Server 2022+, what does the ##MS_DatabaseConnector## role allow?
See possible answers