ShowPlan XML
I just ran into something that I hadn’t noticed in SQL Server. It struck me as somewhat interesting but is really not too big of a deal. While demonstrating...
2011-03-28
14 reads
Blog Posts
SQL in the City – The Red Gate Tour
Red Gate Software is announcing SQL in the City today, a series of events that will bring a free day...
2011-03-28
1,457 reads
SQL Math: Whole Numbers, Real Numbers
It’s been a long time since grade school math, and for some the details have become kinda fuzzy. I’m no...
2011-03-28
1,876 reads
SQL Saturday #67 Wrap-up
Just… Wow. What an event. What a great group of people. I’m just so lucky to be involved with fantastic...
2011-03-28
916 reads
Think Like a Customer
This is the most important and essential first step for a DBA on the journey to providing outstanding customer service....
2011-03-28
851 reads
Tip on Speaking (and Writing) Well – The Key Idea
Cross-posted from the Goal Keeping DBA blog:
In the September 2010 issue of Toastmaster magazine there’s a great article by Chris...
2011-03-28
1,276 reads
Torn page detection vs Page Checksum
TornPage Detection: Up to sql server 2000, for data corruption process is called torn page detection, this option is default on. The...
2011-03-28
907 reads
5 Days to Outstanding DBA Customer Service
Outstanding Customer Service in 5 days
Your success as a Data Professional is directly dependant to the quality of service you...
2011-03-27
660 reads
Cluster failover – what’s the best way to get notified?
G’day,
I look after several clustered instances of SQL SERVER. One of the tasks that I do every morning is to check...
2011-03-27
2,831 reads
Designing Reports with Custom MDX Queries – part 1
This article is the first in a three-part series
On the Microsoft Developer Network (MSDN) forum for Reporting Services and other...
2011-03-27
1,372 reads
Blogs
Rolling Back a Broken Release
By Steve Jones
We had an interesting discussion about deployments in databases and how you go forward...
A bespoke reporting solution doesn’t have to cost the earth
By ChrisJenkins
You could be tolerating limited reporting because there isn’t an off the shelf solution...
Presenting with Visual Studio Code
A while back I wrote a quick post on setting up key mappings in...
Forums
Lots of FKs
Comments posted to this topic are about the item Lots of FKs
Real-time On-prem SQL Server Data in Excel – Over the Internet
Comments posted to this topic are about the item Real-time On-prem SQL Server Data...
Can You Let Go of Determinism
Comments posted to this topic are about the item Can You Let Go of...
Question of the Day
Lots of FKs
In SQL Server 2025, what are the most outgoing and incoming FK references a table can have?
See possible answers