SQLServerPedia Awards
Right, I said I wouldn’t compete, but I can’t help pointing out that I’m pretty proud of this particular blog...
2010-11-01
642 reads
Blog Posts
Vote for Our SQL Rally PreCon
VOTE VOTE VOTE VOTE VOTE VOTE VOTE!!!!!!!!!!
Vote here: http://www.zoomerang.com/Survey/WEB22BD59JCQBT
Honestly, I want each of reading my blog to vote for our...
2010-11-01
488 reads
Database Security Best Practices for the Vigilant Database Administrator and Developer (Unabridged Edit)
Below is a longer version of the equivalent Technet Article under Security TechCenter > Learn > Security Columns > MVP Articles > Database Security Best PracticesThe security of...
2010-10-31
5,322 reads
Get Out The Vote
It’s actually kind of cool that SQL Rally voting for the pre-conference seminars and voting in the real(ish) world in...
2010-10-31
1,668 reads
I’m starting my own SQL Server Consulting business!
Beginning with tomorrow I’m no longer working for HP Austria, because I’m starting
my own SQL Server Consulting business. I’ve been...
2010-10-31
1,536 reads
Speaking at SQL Server Connections in Las Vegas Next Week
I will be giving two presentations next week at the SQL Server Connections conference in Las Vegas. There is a...
2010-10-31
1,579 reads
Why do you use Sparse Columns ? (by Abi Chapagai)
What uses have you found for sparse columns in your databases?
SPARSE columns is a new feature in SQL Server...
2010-10-31
2,598 reads
Free SQL Server Training for the Week of November 1, 2010
Tuesday
PASS Performance Virtual Chapter - Five Fast Fixes for Fatal Flaws - Brent Ozar
Wednesday
SQL Lunch - Data Mining in SQL Server and Power...
2010-10-29
1,813 reads
Live, Loud, and In Stereo
If you followed the PASS Summit activities last year, you’ll probably remember the “blogger table”. This was an area designated...
2010-10-29
1,524 reads
My Bucket List
I actually built on in 1999 and called it a Life List. Over the years I’ve tried to work on...
2010-10-29
1,526 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