The Basics of TRY CATCH Blocks–#SQLNewBlogger
I was working with a customer and discussing how to do error handling. This is a short post that looks at how you can start adding TRY.. CATCH blocks...
2024-04-22 (first published: 2024-03-27)
641 reads
Blog Posts
A New Word: Apolytus
apolytus– n. the moment you realize you are changing as a person, finally outgrowing your old problems like a reptile shedding its skin, already able to twist back around...
2024-04-19
84 reads
Book Review: 100 SQL Server Mistakes
I was approached by Manning Publications and asked to review 100 SQL Server Mistakes and How to Avoid Them. They gave me a free copy of the book (and...
2024-04-19 (first published: 2024-03-25)
531 reads
First Time Speaking with a Mask at an Event
Over the past couple of months, I have started losing my ability to talk without a mask. One of the effects of a disease, ALS, is that I am...
2024-04-19
32 reads
Learning SQL Book Review – Best Free Book for Learning SQL for Beginners
Data is everywhere, and if you want to make sense of it, SQL (Structured Query Language) is your secret weapon. Whether it’s managing customer data or analyzing trends, SQL...
2024-04-19 (first published: 2024-04-06)
473 reads
RTO and RPO are myths unless you’ve tested recovery
I’ve watched teams spend a lot of time on backup strategy. They plan out the full, differential, and log backups to ensure they can successfully meet the recovery point...
2024-04-17 (first published: 2024-04-05)
339 reads
SQL Quickstart Guide by Walter Shields – Book Review & Summary
In today’s world, data is everywhere. Companies collect it, governments analyze it, and it influences everything from what products we buy to how we vote. But all that data...
2024-04-17 (first published: 2024-04-05)
205 reads
Derby City Data Days
It was awesome to see the Kentucky data community come out for the first Derby City Data Days in Louisville, KY! Bringing together communities from Ohio, Tennessee, and Kentucky,...
2024-04-16
29 reads
Familiar Sights
Yesterday was a long day in London. I arrived late in the am, and as I was walking from the plane to the border check, I went down the...
2024-04-16
34 reads
How Do You Decide What to Learn?
There are so many choices and so little time. How do you go about deciding what to learn? I have to delicately balance everything I think I want to...
2024-04-15 (first published: 2024-04-02)
429 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
Alamat Kantor BCA KCU Cibubur Telp:082144477715
WA:0821-4447-7715 Jl. Alternatif Cibubur RT.005/09. Kel. Harjamukti, Cibubur, Kec. Cimanggis, Kota Depok, Jawa Barat...
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...
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