Using the OUTPUT clause to retrieve new identity values from SQL Server 2008
Microsoft has a new KB article outlining issues with using SCOPE_IDENTITY and @@IDENTITY to retrieve values inserted into an identity...
2010-03-03
2,738 reads
SQLSaturday #44!
Andrew Karcher and Marlon Ribunal are heading up SQLSaturday #44 scheduled for April 24, 2010 at Golden West College in...
2010-03-03
337 reads
Bookstores and Databases
My wife is a Board member for Project LEARN in Medina County, Ohio (just southeast of Cleveland). Last night at...
2010-03-03
338 reads
Baby Steps to Learning Something New
I had a really bad habit of trying to jump into the middle of something I didn't know very well,...
2010-03-03
4,810 reads
Notes from the 2010 South Florida Code Camp
Drove down with the family Friday afternoon, not much traffic and a smooth trip. Checked into the Residence Inn just...
2010-03-03
456 reads
Recovering Data and Transactions
Recently I wrote about the disaster recovery issue recently at SQLServerCentral. Someone sent me a note asking why I didn’t...
2010-03-03
390 reads
Mitigating Consulting Risks
In my last post on consulting, Isn’t Consulting Risky?, I contended that in many respects, when done with sufficient forethought...
2010-03-02
1,207 reads
Using Excel 2007 in SSIS 2005
Many companies are not in a rush to upgrade their SQL Servers because of the enormous cost to upgrade. This...
2010-03-02
1,042 reads
SQL Server - MVP Deep Dives
I got my copy of MVP deep dives earlier this month and have been making good progress in reading some...
2010-03-02
869 reads
Personal "Failure" Is Just a Result
I'm reading a book by two teens called Do Hard Things. It's a book which represents a rejection of the...
2010-03-02
981 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