I don’t care and why that is good for my blog
I expressed in my About page that this blog is never meant to be a technical blog. But the pressure...
2012-06-22
806 reads
I expressed in my About page that this blog is never meant to be a technical blog. But the pressure...
2012-06-22
806 reads
This month’s T-SQL Tuesday is hosted by Aaron Nelson (@SQLvariant | Blog). The topic is about logging. Many will talk about...
2012-06-12
1,050 reads
I have been invited to a private beta of SQLDirector by ScaleGrid. “SQLDirector is a MS SQL as a Service...
2012-06-06
1,534 reads
Disclaimer: I wrote this review as a participant to O’Reilly Blogger Review Program.
If you’ve never seen a programming code in...
2012-06-05
1,079 reads
I have talked about wanting a change. I thought I am prepared to embrace that change when it finally comes.
I...
2012-06-01
892 reads
It’s one thing to be able to backup a database, it’s another thing to be able to restore it into...
2012-05-09
4,507 reads
The story of why I came up with this blog is no secret to the few readers I have here. In...
2012-05-03
1,369 reads
Here’s a quick query that you can run to find out the users with sysadmin fixed server role. Sysadmins have a...
2012-04-24 (first published: 2012-04-23)
33,095 reads
There are few memes going around in the SQL world. Probably the most popular of them is TSQL Tuesday (#tsql2sday)....
2012-04-16
1,761 reads
There are situations where you need to grant SELECT permission to a particular user and limit that access to a...
2012-04-11
2,509 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