July 2013 – Monthly SQL Server Checklist
First Monday of the month and time to update the monthly SQL Server checklist. Monthly SQL Server checklist, you ask?...
2013-07-01
917 reads
Blog Posts
Last Weeks Top “Reading” Links #39
For those that follow me on twitter (@StrateSQL), you’ll know that throughout the day I tweet out some links of...
2013-07-01
485 reads
Monitoring Memory Usage of Memory Optimized Objects – SQL Server 2014
Starting SQL 2014 monitoring memory usage of the memory optimized objects is super important to ensure that your instance don’t...
2013-07-01
1,498 reads
SQL Server Events in the UK July 2013
Last month saw SQL Relay, Tech Ed, SQL Saturday Dublin, oh and the small matter of a CTP for SQL...
2013-07-01
678 reads
SQL Server: Part 3 : All About SQL Server Statistics :Who Create and Manage the Statistics ? Role of Statistics in Performance Tuning
In the last posts, we have discussed about the histogram ,density vector and how SQL server use the statistics information...
2013-07-01
1,528 reads
The Secret to Keeping Your Cool Like an Experienced Production DBA
Your actions as a Database Administrator can make the difference between a disaster being a minor nuisance or a major...
2013-07-01 (first published: 2013-06-25)
2,879 reads
Writing Dynamic SQL (A how to)
A little while back I wrote Best practice recommendations for writing Dynamic SQL where I made a number of suggestions...
2013-07-01
2,742 reads
My Thoughts about SQL Server 2014
SQL Server 2014 is coming. Go ahead and download the public CTP.
I’ve just started getting my hands dirty with the...
2013-06-28 (first published: 2013-06-25)
2,870 reads
Natural Born Killers (The series) – Day 6 Sargability
To those that don’t know me “Natural Born Killers (The Series)” sounds like a very strange choice for a SQL...
2013-06-28 (first published: 2013-06-25)
2,791 reads
Reblog: June 21 to June 27
Welcome to this Friday’s reblog summary post. The aim of these posts is to bring some old posts that newer...
2013-06-28
1,175 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
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....
Hyperscale Replicas I
Comments posted to this topic are about the item Hyperscale Replicas I
Question of the Day
Hyperscale Replicas I
What types of secondary replicas are available for the Azure SQL Database Hyperscale edition?
See possible answers