Finding single use plans in the plan cache
A single use plan is an entry in the SQL Server plan cache that was only used once. When a...
2019-03-07 (first published: 2019-02-19)
3,908 reads
Blog Posts
Writing my presentation part 1: The brainstorm/dump
For this session, I’m relying on a mixture of previous blog posts and new material/demos that I’ll have to write....
2019-03-07
397 reads
#DataInDevon – Getting up to speed with PowerShell or spend a day with one of four other MVPs :-)
Saturday 27th April is Global Azure Bootcamp day
What’s Global Azure Bootcamp?
The website says it best
…. communities will come together once...
2019-03-06
301 reads
Canadian SQL Saturday speaking events
I am pleased to announce that I will be speaking at two separate SQL Saturdays in March and April of...
2019-03-06
279 reads
How to get Live Execution Plan using Extended Events
Introduction
Have you ever found yourself in a situation where you were supposed to troubleshoot a long running expensive query that...
2019-03-06 (first published: 2019-02-19)
6,843 reads
How Your Hypervisor Can Impact Your CPU
Recently I had a client complain of chronic high CPU utilization. The performance of their SQL Server had degraded, and...
2019-03-06
580 reads
Midlands #PASS April Meeting with Matt Gordon (@SQLatSpeed)
Midlands PASS in Columbia, SC, will be hosting Matt Gordon (website | twitter) for our next meeting, which is scheduled for...
2019-03-06
268 reads
Pushing SQL Change Automation Code to Azure DevOps
Making changes on your own system for a SQL Change Automation project is great, but if you’re the only one...
2019-03-06
825 reads
SQL server reports GUI Schema change history and CPU RAM IO
SQL server reports GUI Schema change history and...
[[ This is a content summary only. Visit my website for full links, other content, and more! ]]
2019-03-06
16 reads
SQL server reports GUI Schema change history and CPU RAM IO
SQL server reports GUI Schema change history and...
[[ This is a content summary only. Visit my website for full links,...
2019-03-06
420 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 Kontak Bank BCA KCP Ciawi Telp:08218154393
WA:08218154393 Jl. Raya Ciawi No.151, Pakemitan, Kec. Ciawi, Kabupaten Tasikmalaya, Jawa Barat 46156
Alamat Kontak Bank BCA KCP Pati Telp:08218154393
WA:08218154393 Jl. Jenderal Sudirman No.74, Pati Kidul, Kec. Pati, Kabupaten Pati, Jawa Tengah 59114
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