Monday Morning Mistakes: Connecting to Wrong Environments
Today’s Monday Morning Mistake issue is another painfully common one that we all run into at some point. You’ve got...
2012-06-18
2,325 reads
sqlchicken
BIxPress 3.5–Now With More Awesome!
Pragmatic Works has now released version 3.5 of the award-winning BIxPress software! For those not familiar with BIxPress it’s a...
2012-05-21
1,190 reads
SQL Server 2012: Biggest Little Core-house
You sure do got a 'purty motherboard...
Now that SQL Server 2012 is generally available to the public, many companies are...
2012-04-30
2,979 reads
Pragmatic Works Software for MVPs
This is just a quick post to remind folks who are current Microsoft MVPs that Pragmatic Works offers NFR licenses...
2012-04-23
1,095 reads
STOP! Consolidate and Listen
I just wrapped up my 24 Hours of PASS session on consolidation. A big THANK YOU again to everyone in attendance,...
2012-03-21
912 reads
Monday Morning Mistakes: Not Setting Memory Limits
Welcome back to another addition of Monday Morning Mistakes series. Today’s issue is one I tend to run into quite...
2012-03-12 (first published: 2012-02-28)
42,461 reads
Monday Morning Mistakes: SSIS Expressions Not Evaluating Correctly
SSIS Expressions
Expressions in SSIS are great. They allow you to create dynamic values for all sorts of stuff like variables,...
2012-02-16 (first published: 2012-02-13)
4,242 reads
Monday Morning Mistakes: Remote Connectivity to SQL Server
Inspired by common emails and questions I see, I figured I’d do a series of blog posts on common mistakes...
2012-01-23
993 reads
Estimated Completion Time for Backups and Restores
I’m in the middle of a database migration and thought I’d quickly share a script I threw together to show...
2012-01-03 (first published: 2011-12-30)
81,461 reads
SQL University: Virtualization Basics
This week we’re going to talk about a topic that has been gaining steam in the last few years and...
2011-11-17
1,166 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