Updated Overlapping Statistics Scripts
Last year I published a script for identifying automatically generated column statistics that overlapped index statistics. I've updated the script...
2011-04-05
1,712 reads
A SQL Server Hardware Nugget A Day – Day 5
For Day 5, I will be covering a few tools that can be used for hardware identification. Since quite a...
2011-04-05
630 reads
To TOP or not to TOP an EXISTS
Earlier this year I had a look at a query pattern that I often see on forums and in production...
2011-04-05
5,926 reads
How to Deal with Quebec’s Extremists – Report their Threats to the Police (Investigation Under Way)
I’m part of a Committee that is dedicated to eliminating discriminatory legislation in Quebec, here’s a statement we released last...
2011-04-05
2,432 reads
Canada Begins Return to Democracy as the ‘Harper Government’ Found in Contempt of Parliament, a First Throughout the Commonwealth – And No Confidence Vote Triggers the Election Race
For over a week now, Canada has begun its return to appearing to be a democracy thanks to a Liberal...
2011-04-05
1,221 reads
Am I a sysadmin? (or other SQL Server role)
How do you check if you are a sysadmin? It’s fairly easy to do in Management Studio. You can go...
2011-04-05
24,328 reads
SQL Rally Schedule
Thursday, May 12
BI
DBA
DEV
PD / WILD
CARD
8:30 - 9:30
SQL Server Parallel Data Warehouse - Under the Hood
Brian Mitchell
The Dirty Dozen: PowerShell Scripts for the...
2011-04-05
1,130 reads
SQL Validation Functions - 4 Cool UDF's to have handy
Everyone knows that in SQL 2000, yes 2000, Microsoft jumped aboard the bandwagon of other platforms, and gave the developers...
2011-04-05
40,792 reads
Should a DBA be involved in the physical set up of a Database server? Part1
There is always some disconnect between the network admins and the DBA’s regarding hardware set up of a SQL Server....
2011-04-05
1,651 reads
Powershell Day 5
Day 5 Programming in Powershell Part 3 Now as you know all information, in this blog we will look for...
2011-04-05
353 reads
Blogs
The Book of Redgate: Fun with Images
By Steve Jones
We’ve celebrated our birthday many times at Redgate. In the Book of Redgate –...
Why companies use Palantir and how we help implement it in the Czech Republic
Discover how Palantir connects enterprise data, supports AI-driven decision-making and helps companies turn insights...
Why companies use Palantir and how we help implement it in the Czech Republic
Palantir is an American software platform that brings together business data from different sources...
Forums
Pay for Performance
Comments posted to this topic are about the item Pay for Performance, which is...
My PASS Summit West 2026
Comments posted to this topic are about the item My PASS Summit West 2026
Packing and Decoding Device Status Codes with LEFT_SHIFT() and RIGHT_SHIFT() in SQL Server
Comments posted to this topic are about the item Packing and Decoding Device Status...
Question of the Day
SQL Server Audit Failures
If I have a SQL Server Server Audit setup, what are my options for configuring the instance in the event it can't write to the audit log?
See possible answers