SQLTreeo is suspended
Last few month I was really busy and had completely no time for SQLTreeo. This add-in was started being used by...
2012-07-12
828 reads
I’m Speaking: PASS Summit 2012 and more…
Tuesday, July 10th started a string of speaking engagements I have been blessed (or cursed) with in the months of...
2012-07-12
737 reads
Performing Fast Searches of Query Plans
Performing Fast Searches of Query Plans
XML: Fast as a Turtle
I've made blog posts in the past on using the exist()...
2012-07-12
1,334 reads
Stress Testing Stored Procedures with Free Tools
I currently have a presentation named Performance Tuning for Pirates. This presentation goes over using several free tools to help...
2012-07-12
1,533 reads
Understanding the CDC State Value
If you are using Change Data Capture (CDC) it can be very useful to look at the CDC State table...
2012-07-12
2,227 reads
Link List for July 12, 2012
Here are a few things I’ve found/had sent to me recently you may find interesting:
Most Common GRE Words. 400 words...
2012-07-12
686 reads
Denali – Memory: “any size” page allocations
I blog introduction to Memory here. Considering you already know memory concept, till sql server 2008 R2, memory management is divided...
2012-07-12
909 reads
SQL Server DBA Tool Kit
Right next to my batarang and bat-zip-line-hook-shooter-gun on my utility belt is my SQL Server DBA Tool Kit, full of...
2012-07-12
1,080 reads
SQLSaturday #158 Event Update & Hotels - Where are you staying?
Well, we're just a few weeks away from the return of SQLSaturday to NYC as SQLSaturday#158, and it is sure...
2012-07-12
1,688 reads
SQL SERVER : SQL Server Scheduler
While troubleshooting the performance issues of SQL server, you might have seen the sessions are in different state like SUSPENDED,RUNNING,RUNNABLE etc....
2012-07-12
8,743 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