Dr. DMV Queries From Fall 2010 SQLConnections Conference
This is the SQL Server 2008/2008 R2 version of the DMV Diagnostic Information Queries that I did for my Dr....
2010-11-04
876 reads
Blog Posts
Expression Based Interactive Sorting using Reporting Services 2008 – Part 2 Dynamic Sort By
In a previous blog written back in June, I showed you how to use the interactive sort option on a...
2010-11-04
1,851 reads
MDX - Color Formatting on All Measures at Once
In a post a while back I wrote about how you can create conditional color formatting on the Analysis Services...
2010-11-04
2,957 reads
Powershell and Performance Monitoring
When I was doing performance monitoring of servers, I typically struggled with a good way to get the data. In...
2010-11-04
795 reads
Return of the Index Analysis Report
Let’s Anaylze An Index! Finally up to the last post of this series resurgence. Time to update the Index Analysis...
2010-11-04
1,156 reads
S3OLV Nov Reminder
This is a last minute reminder about the monthly S3OLV User Group meeting. It is being held on Nov. 4th,...
2010-11-04
513 reads
S3OLV Nov Reminder
This is a last minute reminder about the monthly S3OLV User Group meeting. It is being held on Nov. 4th, the first Thursday of the month rather than the...
2010-11-04
6 reads
Slides and Example Code for SQL Lunch #42 - Auditing Database Permission in SQL Server
As promised, here are the slides and sample code from my SQL Lunch presentation today. Thanks for all who came...
2010-11-04
686 reads
SQL ServerPedia – Blog Awards
I have been catching up on some blog posts and I read a few posts by well known bloggers like...
2010-11-04
597 reads
SQLSaturday #59 Speaker Interview Series #17 with Bill Pearson
SQLSaturday #59: Speaker Interview Series #17 with Bill Pearson
Today, we pick up the series, with another worldly well-rounded individual, by...
2010-11-04
783 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 Kantor Bank BCA KCP Lomanis Telp:08218154393
WA:08218154393 Jl. Gatot Subroto No.080A, RT.001, Cigobang, Gunungsimping, Kec. Cilacap Tengah, Kabupaten Cilacap, Jawa...
Alamat Kantor Bank BCA KCU CILACAP Telp:08218154393
WA:08218154393 Jl. Jend. Ahmad Yani No.118, Sidakaya Dua, Sidakaya, Kec. Cilacap Sel., Kabupaten Cilacap,...
SSRS Reminded Me of the Time Microsoft Retired TMG
Comments posted to this topic are about the item SSRS Reminded Me of the...
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