Quick MCM Prep Help
Before I went on vacation, I mentioned I was downloading some of the MCM videos from Technet.I had grabbed 4...
2010-12-31
1,622 reads
Blog Posts
The Year of Change: 2010 In Review
Like clockwork, another year has come and (almost) gone. It’s been a wild year on many fronts: major happenings included...
2010-12-31
1,593 reads
Windows Cluster Scripting with WMI and PowerShell
Windows 2008 R2 includes a failoverclusters PowerShell module, but you’ll probably find normal usage limiting for several reasons:
Only works on...
2010-12-31
3,685 reads
XQuery for the Non-Expert – Substring() Function
Follow the rest of this series at the XQuery for the Non-Expert – X-Query Resources introduction post.
Talk to the Experts
Within the...
2010-12-31
1,775 reads
2010 PASS Summit Interviews
It’s entirely fair to say that the highlight of my professional year is the PASS Summit in Seattle, and the...
2010-12-30
1,796 reads
Can You Dig It? – StmtSimple Element
She can dig it!
D Sharon PruittWe’re up to the seventh post on the in the plan cache series. This time...
2010-12-30
1,979 reads
Looking Back at 2010
I’m writing this the day before Xmas, trying to finish up a bunch of odd tasks before the holiday weekend...
2010-12-30
1,448 reads
MCM Prep - VLF Allocations
I had heard that you could have too many VLFs in your transaction log, and it could cause performance issues....
2010-12-30
1,937 reads
Reviewing My 2010 Goals
You can go over my goals here. I’ve really hesitated to do this post because, in my opinion, I did so poorly. Here’s what I did: Community ...
2010-12-30
6 reads
Reviewing My 2010 Goals
You can go over my goals here. I’ve really hesitated to do this post because, in my opinion, I did...
2010-12-30
1,426 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
SSRS Reminded Me of the Time Microsoft Retired TMG
Comments posted to this topic are about the item SSRS Reminded Me of the...
ALAMAT BANK BCA KCU PEMATANG SIANTAR TLP/WA 08218200233
Telp Cs: 08218200233 Jl. Merdeka No.39, Proklamasi, Kec. Siantar Bar., Kota Pematang Siantar, Sumatera...
ALAMAT KANTOR BCA KCU ASIA TLP/WA 08218200233
Telp Cs: 08218200233 Jl. Asia, Simpang, Jl. Bakaran Batu No.1 C, Sei Rengas II,...
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