In addition to being an amazing opportunity for both technical and professional development, PASS Summit is a #sqlfamily reunion and a huge networking event. Catching up with old friends,...
2018-10-29
14 reads
Introduction
In my last post. Step-by-Step: How to Trigger an Email Alert from a Windows Event that Includes the Event Details using...
2018-10-29
2,477 reads
I am proud and honored to be hosting T-SQL Tuesday again. This monthly blog party started by SQL Guru Adam...
2018-10-29
322 reads
Welcome to the new home of my blog! I’ve had this domain for over a year but with PASS Summit 2018 coming up soon I decided it was time...
2018-10-28
11 reads
Introduction
Setting up an email alert is as simple as creating a Windows Task that is triggered by an Event. You...
2018-10-28
1,551 reads
At Microsoft Ignite, one of the announcements was for Azure SQL Database Hyperscale, which was made available in public preview October 1st,...
2018-10-26 (first published: 2018-10-16)
2,281 reads
This article on the SQL Insert statement is part of a series on string manipulation functions, operators and techniques. The...
2018-10-26
375 reads
I was recently asked if we could tell why a plan was removed from cache. If you read this blog,...
2018-10-26 (first published: 2018-10-22)
1,903 reads
Table variables, they’re nasty, dirty little things that perform about as well as a Robin Reliant in a crosswind, right? ...
2018-10-25 (first published: 2018-10-16)
2,079 reads
(Be sure to checkout the FREE SQLpassion Performance Tuning Training Plan - you get a weekly email packed with all the...
2018-10-25
403 reads
By Steve Jones
I wrote about learning today for the editorial: I Can’t Make You Learn. I...
By ReviewMyDB
Fabric has CI/CD built in, but if you've tried to use it for database...
By Steve Jones
attriage – n. the state of having lost all control over how you feel...
Comments posted to this topic are about the item SSRS Reminded Me of the...
I have a need to execute a stored procedure and return the results to...
Title pretty much says it all - can this be done? I've tried several...
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