SSIS Alpha Splits using the CODEPOINT() Function
A relatively common requirement in ETL processing is to break records into disparate outputs based on an alphabetical split on...
2010-02-04
4,408 reads
PASS Update #23
January has been a slow month for me as far as PASS involvement, I show about 10 hours logged for...
2010-02-04
453 reads
Searching for Objects or Text Strings Using SQL Search
As a DBA, at one time or another, you will need to quickly find an object within a database, such...
2010-02-04
4,335 reads
The Events that Brought Me Here
1st event: I am here because my father wanted to be reunited with his family. He also hoped that his...
2010-02-04
680 reads
Questions About SQL Server Backups
SQL Server backups are a “funny” topic to talk about. If you are talking with experienced DBAs, the topic of...
2010-02-03
801 reads
Am I working too much?
The other night I was tired, a few long days, early mornings with the kids, and slightly wired, but needing...
2010-02-03
289 reads
SQLSaturday & PASS – More Details
Yesterday I posted the news that SQLSaturday is now owned by PASS, today I’d like to share a bit of...
2010-02-03
1,096 reads
What Would I Do With a Week?
After my editorial this week on Coding By the Sea, my boss actually pinged me to say that I could...
2010-02-03
388 reads
Knowing how to use ATTRIB
ATTRIB is one of those commands back from the days of DOS which most folks don't even realize it's there....
2010-02-03
2,230 reads
DBCC CHECKDB() on ResourceDB?
A few days ago I was answering a forum post about CHECKDB() and as part of the research I checked...
2010-02-03
1,488 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