Tools of the Trade
I needed to upgrade my tools. It was not a matter of “want” but of “need”. It’s no longer enough to have just the bare...
2012-11-19
961 reads
What if your database server was hacked and all your data was deleted?
Recently in the news an article circulated about a coordinated attack by a team of hackers known as Anonymous. Information...
2012-11-19
503 reads
Surface: Standard Onscreen Keyboard
If you feel that the default on-screen keyboard on the Surface RT isn't sufficient, you can enable what I would...
2012-11-19
1,261 reads
Bob Duffy
ok, everyone has their favorite SQL guru and favorite SQL tips. There are some people whose names you associate with...
2012-11-19
922 reads
Time Pass With Transaction Log - Part 3 fn_dblog
As part of this Transaction Log Internals series, In this article we are going to observe the use of fn_dblog and some of its important...
2012-11-19
18,020 reads
SQL Server 2012 Diagnostic Information Queries (Nov 2012)
Here is the November 2012 version of my SQL Server 2012 Diagnostic Information Queries, with some minor tweaks and improvements...
2012-11-16
951 reads
Rules of Holes #4: Do You Have the BIG Picture?
Some folks decry the concept of being in a 'Hole'. For them, there is no such thing as 'Technical Debt', no such thing as maintaining weak and wobbly legacy...
2012-11-16
11 reads
Rules of Holes #4: Do You Have the BIG Picture?
Some folks decry the concept of being in a 'Hole'. For them, there is no such thing as 'Technical Debt', no such thing as maintaining weak and wobbly legacy...
2012-11-16
6 reads
Speaking at SQL Saturday #173 in Washington DC
I will be speaking at SQL Saturday #173 in Washington DC at the Microsoft MTC in Chevy Chase, MD, to speak on...
2012-11-16
818 reads
Lost in Translation – Deprecated System Tables – sysmembers
This post is part of a blog series which focuses on translating compatibility views in SQL Server to their respective...
2012-11-16
744 reads
Blogs
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...
10 Things I Hate About Fabric Deployment Pipelines— And Some Alternatives
Fabric deployment pipelines look like they solve CI/CD for Fabric content, especially for people...
The Book of Redgate: Evidence
By Steve Jones
We aren’t the only company that does this, but Redgate Software does try to...
Forums
Massive Table Growth Issue – How to Set Up Filegroup Usage Alerts?
Hello We recently encountered an issue where a SQL table unexpectedly grew in size...
The New World Of AI Robots
Comments posted to this topic are about the item The New World Of AI...
Logic question in a WHERE clause using IIF?
Thanks in advance, I'm trying to avoid using IIF for performance reasons, but the...
Question of the Day
BIT_COUNT() V
What does this return on SQL Server 2025?
select bit_count(null)See possible answers