Most Popular SQL Server

SQL Server Express as a Production Database

There are a lot of misperceptions and misinformation about Microsoft’s SQL Server® Express edition. Some of these misperceptions are holdovers from the limitations of previous releases, and others stem from misunderstandings about the product’s features and licensing. In this article, I’ll tackle some of the myths about using SQL Server Express as a production database, […]

Read More

Three Ways to Counter Parameter Sniffing Problems

When I started working with SQL Server® almost ten years ago, various aspects of performance tuning had to be taken into account. Since that time, there has been a lot of talk about parameter sniffing, but not many people really know what that means. I intend to change that with this blog. What is the […]

Read More

How to Write Performance Monitor Data to SQL Server

When you are creating a system benchmark you need a place to store your benchmark data and when you’re collecting SQL Server performance data what better place could there be than SQL Server? Performance Monitor is your primary tool for collecting performance data and Performance Monitor has the capability of writing performance data to SQL […]

Read More

Using the SQL Server Resource Governor to Manage I/O

In large enterprises and multi-tenant environments controlling the resources that are used by a given workload or application can be an important factor in meeting your SLAs. If one workload consumes too large a chuck of your system’s resources then all of the other workloads running on that host could be adversely affected. That’s where […]

Read More

How and When to Use SQL Server FILESTREAM Datatypes–Part 2

The FILESTREAM data type is SQL Server’s principle BLOB storage technology. The FILESTREAM data type lets you combine native NTFS file system performance with relational database data integrity. It supports up to 16 TB files which maximum file size supported by the NTFS file systems and simultaneously provides you with full data consistency. The FILESTREAM […]

Read More

How and When to Use SQL Server FILESTREAM Datatypes–Part 1

Combining Binary Large Object (BLOBs) with relational databases like SQL Server has always been like combining oil and water. They just don’t mix very well. BLOB objects like pictures, videos, text documents and xml documents don’t fit within the standard relational data types. SQL Server originally offered support for BLOBs using the TEXT, NTEXT and […]

Read More

Backups just got better with SQL Server 2016

Every release of SQL Server brings many new capabilities–and opportunities for something new to learn. SQL Server 2016 is nothing new in this regards. Along with many other new features in SQL Server 2016, Microsoft has invested enhancements to backup. After exploring these enhancements further, I believe these features are very much of a cloud […]

Read More

3 SQL Server Trace Flags to Know Before Troubleshooting

In SQL Server, there are various options available to override the default behavior of the product, including use of trace flags. Trace flags almost every DBA is likely to have used include 1204 or 1222. These are used for printing deadlock graphs in ERRORLOG file for troubleshooting. While these don’t have anything to do with troubleshooting performance, they are a good […]

Read More