Using SQL Server in the Enterprise
“This is amazing information. I'm not trying to be dramatic with my adjectives...
I've spent the last three weeks digging through 1,300 page books and every imaginable Internet forum.
This is the most useful collection of SQL tips that I've found.”
- Reid Wakefield
- Head of Development
- Century InterActive
It takes a surpising amount of time to write and publish a monthly newsletter but feedback like this is what keeps us going.
We would enjoy hearing your feedback as well.
You can find links to all our back issues as well as our current issue below.
You can also sign up below for a free subscription to be emailed to you monthly.
Sign Up Here for Your Free SQL Server Newsletter
The Tipping Point - January 2018
Why does the query optimizer in SQL Server prefer to scan an entire table instead of using a non clustered index that seems to fit the query perfectly?
The Many Perils of Using NOLOCK - August 2015
You probably know that NOLOCK can cause dirty reads that often cause inaccurate results,
But do you know about the other ways NOLOCK can return inaccurate results with duplicate data, missing rows, phantom reads, etc.
Tuning Your Tempdb - August 2013
Poor Tempdb performance will affect the overall performance of yyour SQL Server. This newsletter will help you tune your tempdb for optimun performance
Big Data, Small Budget - March 2013
Big Data used to be a problem only for big business with the big IT budgets necessary to manage it.
But more and more it is becoming a problem for smaller companies with small budgets. Here are some tips for managing big data on a tight budget.
SQL Injection Damage Control - February 2013
The subject of preventing penetration of your site through SQL Injection is complex.
However, the subject of preventing damage from the successful penetration can be pretty simple.
SQL Performance Monitoring Tools - July 2012
Third-party performance monitoring tools for SQL Server can sometimes cause the problems they are intended to prevent.
We discuss real-world performance problems that can be caused by these tools. We also discuss the FREE option that is built into SQL Server.
Before you Purchase SQL Enterprise Edition
On-line indexing and table partitioning are powerful tools for maintaining and optimizing performance on 24/7 databases.
But there are limitations to these two features that might make it impossible for you to achieve the benefits you expected.
Read this article before you upgrade. It might save you a lot of money.
Choosing the Right Clustered Index Key - October 2011
The fifth in our series, A Methodology for Query Optimization. You may want to start with the June 2011 article before reading this if you are new to SQL Server optimization.
In this issue we discuss a critical performance issue, selecting the best key columns for your clustered indexes.
SQL Server Search Arguments - September 2011
The fourth in our series, A Methodology for Query Optimization. You may want to start with the June 2011 article before reading this if you are new to SQL Server optimization.
In this issue we discuss Search Arguments, searchable and non-searchable.
SQL Server Execution Plans - August 2011
The third in our series, A Methodology for Query Optimization. You may want to start with the June 2011 article before reading this if you are new to SQL Server optimization.
In this issue we discuss SQL Server Execution Plans. This article contains a link to Grant Fritchey's very good (and FREE) ebook on this subject.
The Covering Index - July 2011
The second in our series, A Methodology for Query Optimization. In this issue we discuss the covering index and illustrate its usage.
You may want to read the June 2011 article before reading this if you are new to SQL Server optimization
Stress Testing SQL Server - March 2011
Microsoft's OSTRESS utility and SQL Profiler's ability to replay traces provide an inexpensive way to stress test SQL Server when developing or modifying database applications.
It's Prediction Day Again! - January 2011
Once a year, the all-knowing, all-seeing SQL guy makes his predictions.
This year the news will be about the impact of social sites and search engines that slam into reverse like a runaway Toyota.
When the Wheels Come Off - October 2010
Prepare yourself for those times that SQL Server will not respond to login requests.
The Dedicated Admin Connection and the SQLCMD command line utility can get you connected when everything else fails.
Fixing Log File Fragmentation - May 2010
Internal fragmentation in the database log file is often overlooked as a cause of poor performance. Here is how to find out if you have it and how to fix it if you do.
SQL Server 2008 Release 2 - April 2010
Is SQL Server 2008 Release 2 a real release or just a service pack we have to pay for? We think it's a little of both. Find out what's in this release for you.
You've Got Mail! - February 2010
SQL Server Database Mail allows you to send email from SQL Server. This incredibly useful feature is a great improvement over its predecessor, SQLMail.
What can Service Broker Do For You? - January 2010
What is Service Broker exactly and how can it help you? Here is an overview of SQL Server's asynchronous messaging service with some
practical examples of how you can use it to solve difficult problems.
A First Look at SQL Azure - December 2009
Cloud Computing is replacing Virtualization as the IT buzzword of the moment.
In this issue we take a look at the details of Azure, Microsoft's entry into the field.