Service Broker Adventures: Stucked Queue Monitors
This week I'm in London helping a client with its large scale Service Broker deployment,
mainly troubleshooting some strange problems with...
2012-07-10 (first published: 2012-07-03)
4,305 reads
Useful new DMV’s in SQL Server 2008 R2 SP1 and SQL Server 2012
Introduction
Microsoft SQL Server 2008 R2 and SP1 and SQL Server 2012 has a new set of DMVs that includes sys.dm_server_memory_dumps,...
2012-07-03
5,414 reads
Decryption and CASTing
In my last encryption post I showed how to encrypt and decrypt data with a symmetric key. However there was...
2012-07-11 (first published: 2012-07-03)
3,416 reads
SSIS SCD vs MERGE Statement – Performance Comparison
I wouldn’t class myself as an expert in SSIS but I certainly know my way around but came across something...
2012-07-03
8,699 reads
SQL Server 2008 Diagnostic Information Queries (July 2012)
Here is the latest version of my SQL Server 2008 Diagnostic Information Queries, with some minor tweaks and improvements to...
2012-07-03
1,363 reads
Speaker Selection for SQLSaturday Orlando-Group #4
Ten speakers selected, and as we go into the July 4th holiday we’re going to add two more to that...
2012-07-03
319 reads
SQL Server Auditing – Getting started
In my organization, one of my jobs is auditing our database environment. I’ve been tasked with this responsibility for several...
2012-07-03
1,863 reads
July 2012 – Monthly SQL Server Checklist
The year is half over and for many of us, specifically those in the United States, it’s a tricky week...
2012-07-03
894 reads
Lunch is for Wimps
A real life DBA tale from the trenches with some awesome advice. That’s what one reader chose to share with...
2012-07-03
1,268 reads
SQL Server Get Identity after Insert using SP
I thought I will share my experience how you can get identity value after insert using SQL Server. I have...
2012-07-03
631 reads
Blogs
10 Things I Hate About Fabric Deployment Pipelines— And Some Alternatives
Fabric deployment pipelines look like they solve CI/CD for Fabric content, especially for people...
The Book of Redgate: Evidence
By Steve Jones
We aren’t the only company that does this, but Redgate Software does try to...
When Your Microsoft Fabric Capacity Runs Out: Optimize, Scale Up, Scale Out, or Isolate?
By James Serra
Microsoft Fabric makes it wonderfully easy to put many analytics workloads on one platform....
Forums
The New World Of AI Robots
Comments posted to this topic are about the item The New World Of AI...
Logic question in a WHERE clause using IIF?
Thanks in advance, I'm trying to avoid using IIF for performance reasons, but the...
Execute as failure
Security has long been a problem for me. Every time I think I understand...
Question of the Day
BIT_COUNT() V
What does this return on SQL Server 2025?
select bit_count(null)See possible answers