PASSITON discount code for PASS Summit 2018
This week only PASS has a new discount code of PASSITON for an additional $200 off 3-day registration. This is in addition to registration going up next by $200...
2018-09-19
26 reads
Powershell Error – Import-Module AzureRm
I was playing with SQL Azure on my brand new Surface pro device. I open the Windows Powershell ISE as administrator to...
2018-09-19
1,149 reads
ExpressRoute and VPNs in Azure
In this edition of Azure Every Day, I’d like to discuss networking and interacting between your data center and Azure....
2018-09-18
249 reads
Don’t Just Rely on Query Execution Stats for T-SQL Execution
I recently had an incident where I was looking into the cause of a long running process for a client....
2018-09-28 (first published: 2018-09-18)
2,097 reads
PASSITON discount code for PASS Summit 2018
This week only PASS has a new discount code of PASSITON for an additional $200 off 3-day registration. This is...
2018-09-18
327 reads
The Trigger Roundup–T-SQL Tuesday #106
This month was my turn to host T-SQL Tuesday. I chose Trigger Headaches or Happiness as the topic, and I...
2018-09-18
894 reads
New Whitepaper: Architecting Microsoft SQL Server on VMware vSphere
(Be sure to checkout the FREE SQLpassion Performance Tuning Training Plan - you get a weekly email packed with all the...
2018-09-18
383 reads
Announcing the 5th Edition of SQL Server 2017 Query Performance Tuning
I am quite excited to announce that the latest, most up to date, and by far the largest, copy of...
2018-09-18
336 reads
sp_translate, A Universal Translator in SQL Server. Just One Example Of How Powerful the Python/SQL Partnership Can Be.
In my recent post, Installing External Modules into SQL Server’s Python I had a look at just how simple it is to...
2018-09-18
600 reads
Check if any database has auditing configured
Here is a DMV script to check whether a or any database has the auditing configured and running, along with...
2018-09-18
768 reads
Blogs
Flyway Tips: Object History
By Steve Jones
It’s a small change, but a handy one. Flyway Desktop (FWD) now includes the...
Car Update September 2026
By Steve Jones
Software is hard. While I love our Lucid Gravity, I realize that they are...
Microsoft Tools for Making Data AI-Ready
By James Serra
Making Data AI-Ready, Part 2 (This is the second article in a three-part series...
Forums
Looking for old SQL Server 1.x - 4.21 disks, manuals, boxes, etc.
Hi everyone, I'm hoping some of the longtime SQL Server professionals here might be...
Checking the Error Log II
Comments posted to this topic are about the item Checking the Error Log II
Parameter Sniffing on SQL Server 2025: A Walkthrough with Real Numbers
Comments posted to this topic are about the item Parameter Sniffing on SQL Server...
Question of the Day
Checking the Error Log II
What is the reason I should change my old code that uses xp_readerrorlog?
See possible answers