Presenting Azure Vs. Working With Azure
I have a real infatuation with Azure. I’m especially interested in the Platform as a Service (PaaS) offerings in and...
2017-11-15
300 reads
The Scary DBA
All Day Query Tuning Class at SQLSaturday Virginia
March 23rd, 2018, I’ll be teaching an all day class on Query Tuning Tools in Richmond Virginia. I hope to...
2017-11-14
364 reads
The GDPR and You
Ever heard of the General Data Protection Regulation? If not, go and read the Wiki. I’ll wait.
I can already hear...
2017-11-13
305 reads
Extended Events and Profiler: XE Profiler
There’s a war on in the SQL Server world. On the one side is Profiler (although, really, everyone uses Trace...
2017-11-07
431 reads
Inside My PASS Summit
As you read this, I’m in Seattle for the PASS Summit 2017. I have four roles that I satisfy at...
2017-10-30
564 reads
PASS Summit and Redgate Software
Next week is the PASS Summit. I’m so excited about it I could pop. Part of why I’m excited is...
2017-10-25
322 reads
Database Fundamentals #14: Modifying Data Through SSMS
I’ve said it before, but I feel I should repeat myself. Using the SSMS GUI for data entry and data...
2017-10-16
522 reads
Database Fundamentals #13: Data Entry Through T-SQL
T-SQL provides lots of functions that help to make data entry through T-SQL much more powerful. Over time you won’t...
2017-10-23 (first published: 2017-10-11)
1,873 reads
Database Fundamentals #12: Adding Data with SSMS GUI
In the previous Database Fundamentals, I argued that you should be learning T-SQL, yet the very next post I’m showing...
2017-09-25
484 reads
Azure, PowerShell, Databases and the PASS Summit
I am quite honored to say that I am speaking at the single largest and most important Microsoft Data Platform...
2017-09-19
430 reads
Blogs
The Book of Redgate: Do the Right Things
By Steve Jones
I do believe that Redgate has been very customer focused since it’s inception. I’ve...
How to Connect to SQL Server When Nothing Else Works – DAC
By gbargsley
It's 2 AM. Your phone is going off. Users can't connect to the application,...
Get a Range of Sequence Values: #SQLNewBlogger
By Steve Jones
I discovered a procedure recently that I wasn’t aware of: sp_sequence_get_range. This post looks...
Forums
that one limitation in replication
Hi as shown below a replication target requires a primary key. if we want...
Local Agents
Comments posted to this topic are about the item Local Agents
Detecting Deadlocks
Comments posted to this topic are about the item Detecting Deadlocks
Question of the Day
Detecting Deadlocks
By default, how often is the SQL Server Database Engine checking for deadlocks?
See possible answers