I'm Giving a SQL Server Security Webinar on May 9, 2013
On May 9, 2013, at 3 PM EDT I will be presenting on 5 Steps Every DBA Should Take to...
2013-05-07
1,202 reads
Blog Posts
Installing SSMS 2012 all by it’s lonesome
SQL Server Management Studio (SSMS) is not offered as a standalone download on MSDN.
Installation requires the user to download the...
2013-05-07 (first published: 2013-04-30)
26,614 reads
Presentation Materials “Discovering the Plan Cache” #SQLSat175
I’m a little late getting the information from my Fargo SQL Saturday session posted, titled ”Discovering the Plan Cache“. But it’s...
2013-05-07
528 reads
SQL Saturday Jacksonville 2013 Wrap-up
It was another great year at SQL Saturday Jacksonville. For the last several years I have been lucky enough to...
2013-05-07
480 reads
SQL Server – Finding TCP Port Number SQL Instance is Listening on
By default SQL Server listens on TCP port number 1433, and for named instances TCP port is dynamically configured. There...
2013-05-07 (first published: 2013-05-01)
4,838 reads
SQL Server 2008 R2 Diagnostic Information Queries (May 2013)
Here is the May 2013 version of my SQL Server 2008 R2 Diagnostic Information Queries, with some minor tweaks and...
2013-05-07
752 reads
SQL Server 2012 Diagnostic Information Queries (May 2013)
Here is the May 2013 version of my SQL Server 2012 Diagnostic Information Queries, with some minor tweaks and improvements...
2013-05-07
762 reads
SQL Server Hardware and Acronyms
Over the weekend I finished reading yet another Red Gate book, this one was SQL Server Hardware by Glenn Berry...
2013-05-07
927 reads
SQL Server Travels–May 2013
At the end of this month of May, I will be teaching Learning Tree’s 3 day SQL Server Virtualization course...
2013-05-07
781 reads
Tips for Minimizing Deadlocks
Deadlocks are caused by poor database design, inappropriate isolation level, inefficient code etc.
Checkout my article (Tips for Minimizing Deadlocks) on...
2013-05-07
911 reads
Blogs
Measuring RAG Solutions: Are We Retrieving the Right Information?
A RAG pipeline that answers questions in the demo is not the same thing...
Advice I Like: Lots of Ideas
By Steve Jones
“A multitude of bad ideas is necessary for one good idea” – from Excellent...
Building a DBA Agent for Your SQL Server Estate with MCP
Yesterday I gave a talk for MSSQLTips called “Building a DBA Agent for Your...
Forums
Looking for New Blood
Comments posted to this topic are about the item Looking for New Blood
Server-Level Row Counts for Tables and Views
Comments posted to this topic are about the item Server-Level Row Counts for Tables...
Parameter Sensitive Plan Optimization vs. Parameter Sniffing: What SQL Server Fixes and What It Doesn't
Comments posted to this topic are about the item Parameter Sensitive Plan Optimization vs....
Question of the Day
Hyperscale Replicas I
What types of secondary replicas are available for the Azure SQL Database Hyperscale edition?
See possible answers