First steps with Extreme Transaction Processing – Hekaton
(Be sure to checkout the SQLpassion Online Academy, where you get High-Quality SQL Server Trainings with Instant Access!)
A few hours...
2013-07-02 (first published: 2013-06-25)
3,849 reads
Klaus Aschenbrenner
My upcoming SQL Server Trainings
(Be sure to checkout the SQLpassion Online Academy, where you get High-Quality SQL Server Trainings with Instant Access!)
The 1st half...
2013-06-24
1,279 reads
SQL Server Tipping Games – Why Non-Clustered Indexes are just ignored!
Almost everytime when I’m doing SQL Server consulting engagements, DBAs are showing me queries and their Execution Plans, where SQL...
2013-06-12
1,610 reads
My 2 cents on SQL Server 2014
Yesterday during the opening keynote of TechEd North America Microsoft released the first official details about the next version of...
2013-06-04
2,791 reads
Windows, RIP (1992 – 2013)
Today is a very sad day for me. My love, my dear Windows has passed away. We were together for...
2013-05-17
1,076 reads
The dangerous beauty of Bookmark Lookups
Every one of us knows Bookmark Lookups in SQL Server. They are great, because you don’t need to care about...
2013-04-15
752 reads
Become an expert in SQL Server Performance Tuning & Troubleshooting!
Since September 2012 I'm a Microsoft Certified Master SQL Server 2008,
which is the highest technical certification for SQL Server that...
2013-02-13
1,044 reads
Become an expert in SQL Server Performance Tuning & Troubleshooting!
Since September 2012 I’m a Microsoft Certified Master SQL Server 2008, which is the highest technical certification for SQL Server...
2013-02-13
813 reads
SQL Server Quickie #5 – Bookmark Lookup Deadlocks
Today I have uploaded the 5th SQL Server Quickie to YouTube. This time Santa Claus
talks about Bookmark Lookup Deadlocks in...
2012-12-16
1,512 reads
SQL Server Quickie #5 – Bookmark Lookup Deadlocks
Today I have uploaded the 5th SQL Server Quickie to YouTube. This time Santa Claus talks about Bookmark Lookup Deadlocks...
2012-12-16
838 reads
Blogs
“We love to debate minutiae”
By Brian Kelley
I am guilty as charged. The quote was in reference to how people argue...
Advice I Like: Knots
By Steve Jones
Learn how to tie a bowline knot. Practice in the dark. With one hand....
Shifting Mindsets: Why FinOps is Essential for Cloud Efficiency
By HeyMo0sh
As a DevOps practitioner, I’ve always focused on performance, scalability, and automation. But as...
Forums
Windows logins for users migrated from DomainA to DomainB
Hi, I have a SQL Server instance where users connect to via Windows Authentication,...
Multiple Deployment Processes
Comments posted to this topic are about the item Multiple Deployment Processes
How to Use sqlpackage to Detect Schema Drift Between Azure SQL Databases
Comments posted to this topic are about the item How to Use sqlpackage to...
Question of the Day
Upgrading Admin Queries
I have a query from a former DBA that we run on SQL Server 2025 to check on database metadata. This query references sys.sysaltfiles. I want to refactor this code to be more modern. Which DMV should I reference instead?
See possible answers