Baseline SQL Server with SQL Sentry Performance Advisor
Baselines can be any set of metrics that have been recorded to give you an understanding of what is the...
2013-06-24
2,866 reads
SQL Server 365
Dedicated Administrator Connection (DAC)
We all dread the scenario whereby SQL Server is under so much load and has a complete lack of resources...
2013-05-29 (first published: 2013-05-23)
3,447 reads
Object Qualification
I came across an interesting issue recently with NHibernate, now it is widely known I despise ORM’s, in my experience...
2013-05-22 (first published: 2013-05-15)
2,749 reads
DTA and Hypothetical Indexes
For those of you that don’t know DTA stands for Database Engine Tuning Adviser and is available from the Tools...
2013-05-15 (first published: 2013-05-09)
11,339 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
902 reads
Index Tuning
This week I've been carrying out some performance tuning of some of the more intensive procedures in one of our environments. Using...
2013-03-21 (first published: 2013-03-14)
3,611 reads
Cost Threshold for Parallelism
Parallelism, where to start? Well let’s start right at the beginning shall we with the question, what is parallelism? Simply...
2013-02-26
3,456 reads
Fun with dates
Every year me and a group of friends attend the Royal International Air Tattoo (RIAT) at RAF Fairford, for us it...
2013-02-17
784 reads
T-SQL Gotcha
I came across an interesting issue a few days ago that I thought I would blog about. The issue is...
2013-02-15
1,586 reads
Script Replication with PowerShell
I promised you some PowerShell scripts this year and this post is the first one. I can see the value...
2013-02-14
6,664 reads
Blogs
Copilot Outside of SSMS Seems to Work
By Steve Jones
I read Brent’s first look at SSMS and Copilot in there. He didn’t have...
A New Word: Falesia
By Steve Jones
falesia– n. the disquieting awareness that someone’s importance to you and your importance to...
SQL Server Logins vs. Users: Why You Really Need to Know the Difference
By Kevin3NF
The Two-Layer Model Explained “We added them to the database, but they still can’t...
Forums
average duration increasing inline with exec counts
As the title says , I've got a handful of stored procs where the...
A Basic Data API Builder ADD
Comments posted to this topic are about the item A Basic Data API Builder...
Sentiment Analysis & Key Phrase Detection
Comments posted to this topic are about the item Sentiment Analysis & Key Phrase...
Question of the Day
A Basic Data API Builder ADD
What parameters are required for the dab add command in the Data API Builder?
See possible answers