Another Update on SQLSaturday
I’ve fallen behind a little on sharing SQLSaturday news, so I’ll try to catch up on the latest. First, we’re...
2009-12-02
490 reads
Under Repair
I’m glad I called Toshiba last night. When my laptop died on Sunday, and never came back Monday, I wasn’t...
2009-12-02
342 reads
Explain it to yourself
I found a nice post from a friend, Roy Ernest, on an effective way to learn. He notes that one...
2009-12-02
673 reads
Fundamentals of Storage Systems – Testing IO Systems
12/03/2009 - UPDATE! There were a couple of bugs in the SQLIOCommandGenerator new SQLIOTools.zip has been updated.
------------------------------------
I often tell people one...
2009-12-02
1,577 reads
PowerShell V2 Remoting
To use remoting you'll need to install Powershell V2, unless you're running Windows 2008 R2 or Windows 7, you'll need...
2009-12-02
1,201 reads
Upgrading to Windows 7
I’ve been using Win 7 on my dev machine for a few months now, and finally decided over the Thanksgiving...
2009-12-01
504 reads
Google Dashboard
Recently announced, Google Dashboard shows some but not quite all of the data that Google has accrued about you – a...
2009-12-01
1,124 reads
Using Resource Monitor In Windows Server 2008 to Look at I/O Performance for SQL Server 2008
One quick and dirty tool that I like to use to monitor I/O performance at the file level is Resource...
2009-12-01
2,305 reads
Congratulations to Christopher Graham for Taking Companies to Task About Protecting Data Privacy
The New Information Commissioner for the United Kingdom is Mr. Christopher Graham, he's working from Wilmslow, near Manchester, with a...
2009-12-01
1,352 reads
MDX Utility Belt of Calculations Part 2
This post is a part of a series of blog posts I am writing to give you a Batman-like Utility...
2009-12-01
1,771 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