Session: Introduction to Powershell Cmdlets for DBAs
I’ve given my new Powershell Cmdlets for DBAs session a handful of times now, and just realized I haven’t blogged...
2014-10-28
880 reads
Jen McCown
Minion Reindex is here
We released Minion Reindex by MidnightDBA unto the world, accompanied by a press release on SQLServerCentral.com, and people have responded so incredibly positively. We’re quite...
2014-10-27
708 reads
Minion Reindex arrives this Friday!
Edit: Minion Reindex has arrived, and it’s getting fantastic notes! The MidnightDBA team is announcing the release of a new,...
2014-10-20
1,133 reads
PASS Summit 2014: Recommendations and Invitations (#sqlpass #Summit14)
The first week of November, we’ll be at the PASS Summit inSeattle, WA. This is the highlight of most SQL Server speakers’...
2014-10-10
654 reads
Tip: Concatenate rows with XML, or COALESCE
Edit: I went and changed the first query without paying close enough attention. I’ve fixed the explanation and the query....
2014-10-08
838 reads
Wendy Pastrick and Grant Fritchey: Optimists in Action #passvotes
If I had a favorite kind of politician, it would be the kind that, when asked a question, sighs tiredly,...
2014-09-19
562 reads
Tip: RECOVERY_PENDING is not the same as RECOVERING
I’ve seen this mistake more than once, from DBAs with a middling to fair amount of experience. So it bears repeating....
2014-09-08
921 reads
This Week in Awesome – Running at PASS, Cookie Jail, SQL Sats, Breakfast
If you’re in Seattle the week of November 2 – say, for example, you’re attending the PASS Summit that week – consider...
2014-07-30
1,034 reads
The Week in Awesome – Plugins, Cars, Food, and France
This week in awesome: Denny Cherry – our own @mrdenny – has created a Password Vault WordPress plugin. That looks seriously cool....
2014-05-30
1,093 reads
Applied SQL: Orphan a user, fix orphaned users (sp_FixOrphanedUsers)
Ever heard of orphaned users? It’s a database user account, disconnected from its associated login. You typically get this when...
2014-05-05
931 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