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,885 reads
Chris McGowan
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,624 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,755 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,416 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
905 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,620 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,498 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
788 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,592 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,751 reads
Blogs
T-SQL Tuesday #192: SQL Server 2025 Backup Changes
By Steve Jones
I hosted this month, but I decided to put my own entry in as...
Why Databases Still Fascinate Me
By Chris Yates
I get asked a lot about why or how I began working with databases...
Monday Monitor Tips: ServiceNow Integration
By Steve Jones
Earlier this year I visited a customer that was using the Redgate Monitor webhook...
Forums
Implementing PostgreSQL with Python for Real-Time Logging and Monitoring
Comments posted to this topic are about the item Implementing PostgreSQL with Python for...
Identify a Slipstream Installation
Comments posted to this topic are about the item Identify a Slipstream Installation
Internal Staff Growth
Comments posted to this topic are about the item Internal Staff Growth, which is...
Question of the Day
Identify a Slipstream Installation
I get a new SQL Server instance from my build team. How can I tell if the instance was installed using a slipstream installation later?
See possible answers