What if you could assess the performance level of your team by asking one simple question? In his recent webinar with Redgate, Gene Kim (@realgenekim) suggests that you can....
2018-11-02
19 reads
One of the features Microsoft wants us to use for Azure SQL Database is Automatic Tuning. Automatic Tuning is a...
2018-11-01
291 reads
Statistics are the magic ingredient that helps the query optimizer create its best guess for generating an execution plan. Keeping...
2018-11-01 (first published: 2018-10-24)
3,186 reads
If you are anything like me, you might have a few different Google accounts that you work with on a...
2018-11-01
41 reads
AdvertisementsPlan Explorer
I recently started using this. Since it was licensed earlier, now it’s free. This is an awesome tool for...
2018-11-01
2,709 reads
How often have you felt like you need an extra pair of hands? When you’re planning a party? Maybe. When...
2018-11-01 (first published: 2018-10-24)
2,489 reads
Quick and easy post today. Hopefully you’ve opened the error log on a SQL instance. However, what happens if you...
2018-10-31 (first published: 2018-10-22)
2,633 reads
In this post I will explain what the DACPAC is and how to create it. In previous post in DevOps...
2018-10-31
2,582 reads
Azure Data Studio is the newest tool from Microsoft for working on the data platform. Last year we saw the...
2018-10-31 (first published: 2018-10-19)
4,493 reads
Next week is the week when I used to dread looking at Twitter and especially the #PASSsummit hashtag, watching all of...
2018-10-31
263 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...
WA:08218154393 Jl. Jend. Ahmad Yani No.118, Sidakaya Dua, Sidakaya, Kec. Cilacap Sel., Kabupaten Cilacap,...
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...
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