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,777 reads
The DBA Who Came In From The Cold
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,511 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,466 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
583 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,007 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
541 reads
Happy New Year!
Happy New Year!
Hope you all had a good Xmas, ate too much, drank too much and are still telling yourselves...
2014-01-02
323 reads
Disaster Recovery Planning
As a SQL Server DBA it is absolutely vital you regularly take backups of the databases you look after. If...
2013-11-26
434 reads
My favourite online references
There is a wealth of information about SQL Server online. Absolutely hundreds of blogs, white papers, editorials, the list goes...
2013-11-19
412 reads
My 5 pieces of advice for new DBAs
As my first post, I thought I’d list a few points that I would say to any new DBA. I’ll...
2013-11-07
794 reads
Blogs
Capturing errors and auditing in Azure SQL DB
Logging is a necessity in the database world, well, the entire tech world. You...
Stepping into Event Streaming with Microsoft Fabric
By Rayis Imayev
(2025-July-06) Very often, real-time, high-speed streams of events come from IoT devices, social media...
Sabbatical le Troisième: A Recharge Week
By Steve Jones
It’s been a week since I flew home from London and Redgate to begin...
Forums
Unmasking CXPACKET and CXCONSUMER in SQL Server: What Your Execution Plan Isn’t Telling You
Comments posted to this topic are about the item Unmasking CXPACKET and CXCONSUMER in...
how to move all SP from one db to another db?
Hi everyone I have two db - one is test and other is archive. ...
The Long Weekend
Comments posted to this topic are about the item The Long Weekend
Question of the Day
Independence Day
The film independence day was released in 1996. Which of these queries returns that year is run today?
See possible answers