Debuting: Beginning SQL Server 2008 Administration
The new book is up on Amazon. I only worked on three chapters of Rob Walter’s new book and that...
2009-09-04
630 reads
Survival: How a Culture of Preparedness Can You and Your Family From Disasters
Picked up Survival: How a Culture of Preparedness from the local library on a whim without looking at anything except...
2009-09-03
591 reads
Thoughts on the 24 hours of PASS
From all indications, the first 24 hours of PASS was a resounding success. Hundreds of attendees for each session, minimal...
2009-09-03
363 reads
Disaster Recovery for SQL Server Databases
Well, it finally happened, the complete disaster recovery article was reviewed, reviewed again, rewritten, revisited…you get the picture…and published. As described...
2009-09-03
2,193 reads
SQL Bits Conference to Run Three Days
The next SQL Bits conference, the largest SQL Server conference in Europe, will be held at the Celtic Manor Resort...
2009-09-03
428 reads
24 Hours of PASS - Recap
At times it felt like a party, it had enough content to be a mini-conference, and we learned that some...
2009-09-03
878 reads
How Log reader works- replication
Just saw the the answer by michael Hotek for how log reader works on replication: looks very great:http://social.msdn.microsoft.com/Forums/en-US/sqlreplication/thread/d2d2e1c6-01ee-439b-93e8-e31c77c0cd28/Thanks Michael Hotek...
2009-09-03
827 reads
Replication
Hi,Just want to share info about replication script which i generally use. this is good for sql server 2000 Transaction...
2009-09-03
761 reads
Use the Best Tool for the Task - Part 2
Yesterday I posted about how Transact-SQL was better suited than SMO for gathering details about database files for a database...
2009-09-03
402 reads
Help Design a New SQL Server Monitoring Tool
In an experiment in SQL Server community involvement, the members of Red Gate Software’s software development usability team have created...
2009-09-03
405 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