Generate test data using DBGen
Over the last couple of months I have on several occasions found myself in need of test data for demos,...
2012-01-24
14,393 reads
Blog Posts
PASS Performance VC Reboot
The PASS Performance Virtual chapter is getting a reboot. We all know that responsibilities and schedules change, and that meant...
2012-01-24
743 reads
Read contents of a file to variable – SSIS
Sometimes you will find the need to import a file to a variable using SSIS. In this post, I’ll use Script...
2012-01-24
1,849 reads
RECONFIGURE can flush the procedure cache
I ran across this KB article the other day, which lists a few ways in which performance is affected by...
2012-01-24 (first published: 2012-01-19)
2,195 reads
Sitting Between Two Stools: Analysis Services 2012, Windows 8 and Market Niche Confusion at Microsoft
In my last post, I wrote that the game plan was to post by Dec. 10 on changes in data...
2012-01-24
1,969 reads
Slammer, Alive…Barely
By now you must have heard of the SQL Slammer worm. It was quite an infectious little nuisance. The harm it caused came largely due to unpatched, unprotected SQL...
2012-01-24
10 reads
Insert multiple rows from one INSERT statement
One of the things that has been annoying for a long time in SQL Server is adding lots of data...
2012-01-23
29,041 reads
January 2012 SQL Server 2008/2008 R2 Diagnostic Information Queries
Since Microsoft recently released a couple of new Cumulative Updates for SQL Server 2008, I thought it was finally time...
2012-01-23
1,179 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
New Article: How to audit sysadmin members on multiple servers using PowerShell
My first article of 2012 has published over at MSSQLTips.com. This one covers the basic technique for using PowerShell to audit...
2012-01-23
1,943 reads
Blogs
Programmatic Tool Calling with the Claude SDK
Programmatic Tool Calling with the Claude SDK Every morning somebody on the team runs the...
A New Word: Mauerbauertraurigkeit
By Steve Jones
mauerbauertraurigkeit – n. inexplicable urge to push people away, even close friends whose company...
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...
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