T-SQL Tuesday #025 – Holiday Gifts
Tis the Season It is the season for TSQL Tuesday. More importantly it is the season for giving and reflection. And whether you celebrate Christmas or Chanukkah or Kawanzaa...
2011-12-13
8 reads
Blog Posts
T-SQL Tuesday #025 – How to view the size of all your databases – #TSQL2sDay
It’s that time of the month again, no not time, T-SQL time! If you have not heard of T-SQL Tuesday...
2011-12-13
870 reads
T-SQL Tuesday #025 – Share Your Tricks #TSQL2sDay
Another month and it’s another T-SQL Tuesday. This month we are being hosted by Allen White (Blog | @SQLRunr) and the...
2011-12-13
624 reads
T-SQL Tuesday #025 – Tips and Tricks
And the trick i share for this month’s T-SQL Tuesday is… Distraction free management studio.
If you’re an avid writer, you might...
2011-12-13
735 reads
Changes to SQL Server 2012 Execution Plans
I’ve been working with execution plans quite a lot in SQL Server 2012. There are a number of changes, most...
2011-12-12
10,177 reads
CPU-Z 1.59 Released
One of my favorite free tools for getting some processor and memory specific information from a Windows computer (whether is...
2011-12-12
1,241 reads
More Culture-The Failure Wall
Ran across this during my daily reading, a post by Jeff Stibel on Why I Hire People That Fail. The...
2011-12-12
780 reads
Presenting at IT Pro Camp in January 2012
My first outing of the new year will be at the IT Pro Camp here in Orlando, working on some...
2011-12-12
646 reads
Replication Bookmarks
I started a list of the resources I frequent the most in the MSDN Library SQL Server Books Online - Replication,...
2011-12-12
1,112 reads
SQL Traces and c2 auditing are different
Sometimes end users interchange the terms : C2 auditing and Traces.
They server different purposes.
c2 auditing records all attempts (successfull and...
2011-12-12
844 reads
Blogs
Methodology for dealing with bad data in production
By Brian Kelley
Pinal Dave wrote up his methodology for what to do when you discover bad...
How to Provision an Azure SQL Database
Aside from spinning up a SQL Server instance container, the free Azure SQL Database...
Claude finds two cryptographic weaknesses (but the sky isn’t falling)
By Brian Kelley
If you haven't seen the announcement, Anthropic was able to utilize Claude (Mythos Preview)...
Forums
Why SQL Server Database Attach fails and how to repair it
Comments posted to this topic are about the item Why SQL Server Database Attach...
Fixing P1 Queries
Comments posted to this topic are about the item Fixing P1 Queries
BIT_COUNT() IV
Comments posted to this topic are about the item BIT_COUNT() IV
Question of the Day
BIT_COUNT() IV
In SQL Server 2025, I run this code:
select bit_count('A')
What is returned? See possible answers