Slides & Samples for my SQLPASS sessions
As announced in both of my session you can find my slides & samples here for download:
Building FILESTREAM
solutions with SQL Server...
2010-11-15
667 reads
Blog Posts
SQL Server 2005 Diagnostic Information Queries (November 2010)
Here is the November 2010 version of my diagnostic information queries for SQL Server 2005. Many of these queries are...
2010-11-15
2,667 reads
SQLSaturday #59 - Speaker Interview Series #18 with Matt Van Horn
SQLSaturday #59 – Speaker Interview Series #18 – with Matt Van Horn
Notes from the SQLSat#59 Team: SQLSaturday#59 is just 5 days away...
2010-11-15
914 reads
SQLServerPedia Awards Winner
Thanks to all those that voted for my Index Black Ops blog series for the SQLServerPedia blog awards. I am...
2010-11-15
558 reads
SSIS Denali Resolve References
One of the new features in SSIS Denali that I’m really excited about (Other than the ability to Undo ctrl-z)...
2010-11-15
1,411 reads
Switching Off Parameter Sniffing
Or, another way to put it, in most cases, shooting yourself in the foot.
I was not aware that the cumulative...
2010-11-15
2,892 reads
The PowerShell CookBook
“A script club.” That’s what a friend of mine said when he was telling me how he’d learned the basics...
2010-11-15
450 reads
Join the SQL Lunch on Tuesday
What a long week at PASS (stay tuned for more details about my trip). Now that it's over back to...
2010-11-14
672 reads
Self-service Reporting in SQL Server “Denali”
Project “Crescent” is the name currently used to describe the new self-service reporting
capability to be released in the next version...
2010-11-14
614 reads
XBox 360 250GB and Kinect Bundle
I took the plunge and bought one of the new 250GB XBox 360 and Kinect bundles for $399 at Best...
2010-11-14
812 reads
Blogs
Learn about Modern Microsoft Apps in San Diego
By Steve Jones
I wrote about learning today for the editorial: I Can’t Make You Learn. I...
How To Deploy Fabric SQL and Azure SQL Databases with Azure DevOps
By ReviewMyDB
Fabric has CI/CD built in, but if you've tried to use it for database...
A New Word: Attriage
By Steve Jones
attriage – n. the state of having lost all control over how you feel...
Forums
SSRS Reminded Me of the Time Microsoft Retired TMG
Comments posted to this topic are about the item SSRS Reminded Me of the...
Getting results from a Procedure to join to a query
I have a need to execute a stored procedure and return the results to...
Upgrade 2016 Standard to 2022 Express
Title pretty much says it all - can this be done? I've tried several...
Question of the Day
BIT_COUNT II
In SQL Server 2025, I have a table (dbo.UserPermission) that contains this data:
UserID UserPermissions 15 23 37 4 NULLWhat is returned when I run this code:
select bit_count(UserPermissions) as PermissionCount from dbo.UserPermission where UserID = 4;See possible answers