Free Data Models
I saw this on a Channel 9 forum thread:
Library of Free Data Models
There are quite a few starter data models...
2006-07-19
1,918 reads
Blog Posts
Get a Better Understanding of How Queries Execute
I was catching up on my blog reading (unfortunately, in some cases I'm
a month behind) and came across a link...
2006-07-14
1,456 reads
New KB Article on SQL Server 2005 File Growth Bug
There is are two new KB articles on how the file growth value can become abnormally large. You can find...
2006-07-13
1,620 reads
A Chronology of Data Breaches Reported Since the ChoicePoint Incident
Found this link on one of the security mailing lists I peruse. You can find an archive of the original...
2006-07-11
1,399 reads
New KB Article on Remote Mirroring Support Requirements
Microsoft has published a new Knowledge Base article on the
requirements to receive support for what is known as remote mirroring.
Requirements...
2006-07-07
1,718 reads
Passed Again
I took the 70-441 exam last week and passed, which is good since I'm
working on part of the exam prep...
2006-07-07
1,476 reads
New Article on SQL Server 2005 Logins
I wrote a new article for SQL Server Central on SQL Server 2005 Logins. It covers the basics. This is...
2006-07-05
1,400 reads
Microsoft Office 2007 Delayed
It looks like Microsoft Office 2007 will be delayed due to performance
issues. It was supposed to release in conjunction with...
2006-06-29
1,359 reads
Idera SQL Check updated for SQL Server 2005
Idera's SQL Check
has been updated to support SQL Server 2005. SQL Check is a free
performance monitoring tool, not anywhere near...
2006-06-28
1,547 reads
WinFS rolled into next version of SQL Server
A blog posting from the WinFS team
caught me a bit by surprise today. Apparently I wasn't the only one,
judging by...
2006-06-27
1,547 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