SQL Saturday 108 (Redmond, WA) Session Files
SQL Saturday 108 (Redmond, WA) Session Files
SQL Saturday 108 Replication Magic
Session files are now available for download. The zip file...
2012-02-26
919 reads
Robert Davis
- Interests: Poker, computers, reading/writing horror fiction
[Shameless Plug] Can We Have Your Vote?
[Shameless Plug] Can We Have Your Vote?
SQL PASS SQLRally
Argenis Fernandez (|@DBArgenis) and yours truly have submitted a Pre-Conference for SQL...
2012-02-08
1,067 reads
Breaking Down TempDB Contention (part 2)
Breaking Down TempDB Contention (part 2)
Tempdb Contention via Idera Diagnostic Manager
I wrote a somewhat popular script and blog post a...
2012-01-30
3,011 reads
The Kind of DBA I Want to Be
The Kind of DBA I Want to Be
Rokusaburo Michiba (Iron Chef Japanese)
I was a big fan of the original Iron...
2012-01-27 (first published: 2012-01-22)
2,797 reads
Including Missing Values in Data Ranges Without a Lookup Table
Including Missing Values in Data Ranges Without a Lookup Table
Including Missing Data
One of the ways that I learn new things...
2012-01-14
1,722 reads
Webcast: Putting a Better SQL Server in Production
Webcast: Putting a Better SQL Server in Production
Production Line
Webcast:Putting a Better SQL Server in Production
Date: Wednesday, January 18, 2012 3:00...
2011-12-26
1,240 reads
Using Dynamic Values in XMLA
Using Dynamic Values in XMLA
XMLA
A question was raised on Twitter today via the #sqlhelp hash tag about passing parameter values...
2011-12-18
1,930 reads
Undocumented Gotchas of Transactional Replication
Undocumented Gotchas of Transactional Replication
Gotcha - Norelco commercial (1977)
This discussion started on Twitter via the #sqlhelp hash tag. The question that...
2011-12-17
1,390 reads
PASS Data Arch. Virtual Chapter: Row Versioned Data Warehouses
PASS Data Arch. Virtual Chapter: Row Versioned Data Warehouses
Subject:Row Versioned Data WarehousesStart Time:Thursday, December 15, 2011 6:00 PM US Pacific...
2011-12-14
806 reads
PASS Data Arch. Virtual Chapter: On beyond Zebra AdventureWorks OR where did I go wrong?
PASS Data Arch. Virtual Chapter: On beyond Zebra AdventureWorks OR where did I go wrong?
Subject:On beyond Zebra AdventureWorks or where...
2011-11-15
1,059 reads
Blogs
Advice I Like: Respect
By Steve Jones
“Don’t aim to have others like you; aim to have them respect you.” –...
Blue Sky Programming – The Optimism Trap
Many years ago, before I joined Oracle, I was working on a major modernisation...
Setting Up a Mac for Data Engineering and AI Work
If you work with data pipelines, SQL, notebooks, or machine learning models, a Mac...
Forums
SQL Art, Part 4: Happy 4th of July — A British DBA's Guide to Celebrating a War We Don't Talk About
Comments posted to this topic are about the item SQL Art, Part 4: Happy...
Alamat Kantor BCA KCU KUDUS Telp:0817839777
WhatsApp: 0817839777 Jl. Jend. Ahmad Yani No.91, Magersari, Panjunan, Kec. Kota Kudus, Kabupaten Kudus,...
Alamat Kantor BCA KCU SEMARANG Telp:0817839777
WhatsApp: 0817839777 Jl. Pemuda No.90-92, Kembangsari, Kec. Semarang Tengah, Kota Semarang, Jawa Tengah 50133
Question of the Day
BIT_COUNT I
In SQL Server 2025, I have a table (dbo.UserPermission) that contains this data:
UserID UserPermissions 15 23 37What is returned when I run this code:
select bit_count(UserPermissions) as PermissionCount from dbo.UserPermission where UserID = 3;See possible answers