DBA 101: Why Don’t People Run Backups
It happened multiple times this week. It happens multiple times every week. Some poor soul is posting on a message...
2011-02-13
721 reads
The Scary DBA
TSQL Tuesday #15–Automation in SQL Server
Automation is the separation point for the professional DBA from the amateur. That makes this a very important topic. Thanks...
2011-02-08
901 reads
SQL Saturday #60: The Saga
First, let me thank Erin Stellato (blog|twitter) and all the volunteers for running such a great event. Nicely done.
This event...
2011-02-07
755 reads
PASS Summit Location
Andy Warren has posted another one of his excellent summaries of what’s going on at the PASS Board. Andy, thanks...
2011-02-02
1,916 reads
Powershell to Automate SQL Compare
A question came up on the SQL Server Central Forums, how could you use Red Gate SQL Compare to automate...
2011-01-31
4,285 reads
SQL Saturday #71: Call For Speakers
The SQL Saturday #71/New England Data Camp #3 call for speakers has been open for quite a while. But, we...
2011-01-26
1,030 reads
A Friend of Red Gate No More
Don’t get me wrong. It’s been great. The beta tests. The advanced notices. The opportunity for feedback. It’s been a...
2011-01-21
781 reads
Deprecation, Trace and Execution Plans
As I’m sure you know, Microsoft occasionally changes it’s mind. Or, it makes bad decisions and then rectifies them. Or,...
2011-01-21
889 reads
DBA 101: Why is my log file full?
This question comes up constantly in different venues. I see it sometimes 2-3 times a day on SQL Server Central....
2011-01-18
2,674 reads
Failed Blog Posts
Over the last week I’ve started and trashed two blog posts. Let me tell you, that’s painful. You get some...
2011-01-14
730 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 BCA KCU TEBING TINGGI TLP/WA 08217555651
Hub Cs: 08217555651 Jl. Jend. Sudirman No. 225-227-229-231, Badak Bejuang, Kec. Tebing Tinggi Kota,...
ALAMAT KANTOR BCA KCU KISARAN TLP/WA 08217555651
Hub Cs: 08217555651 Jl. Cokro Aminoto No.28, Kisaran Kota, Kec. Kota Kisaran Barat, Kabupaten...
ALAMAT BCA KCU PEMATANG SIANTAR TLP/WA 08217555651
TLP/CS 08217555651 Jl. Merdeka No.39, Proklamasi, Kec. Siantar Bar., Kota Pematang Siantar, Sumatera Utara...
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