A Microsoft SQL Server community of 1,777,379 DBAs, developers and SQL Server users

In this chapter we will talk about security recommendations for SQL Server Data Mining.  Read more...

Grant Fritchey reviews Midnight DBA's Minion Reindex, a highly customizable set of scripts that take on the task of rebuilding and reorganizing your indexes.   Read more...

The easiest way to determine if there is encrypted data in a database is to get that information from whoever wrote the application. Aside from that, there are a few things you can look for which would suggest that you have encrypted data in a given database.  Read more...

Using sub-queries as tables only requires an alias  Read more...

This SQL Prompt tip shows you how code highlighting makes it easier to find which items match up with each other.  Read more...

Not all data is discrete; some data types represent a continuum. In SQL, we have to approximate them and live with the special problems of handling continuous data. We need to understand the problems associated with continuous data types, when these will happen, and how it affects constraints and the results of queries. Joe Celko explains.  Read more...

How to remove identify and remove duplicate data from your tables  Read more...

Extreme Programming (XP) is no general panacea; but for the right team, and for a product that needs to release bug fixes and new features as fast as possible, its benefits are obvious. Working on one of Red Gate's most popular tools, SQL Prompt, Aaron Law and David Priddle use XP. But is their adherence to XP a personal preference or does it bring real benefits?   Read more...

On January 28th 3PM GMT, Randolf Geist will present a free, one-hour webinar analyzing different database query profiles based on a real-world customer case. He'll also look at how these different profiles influence the efficiency of Exadata's features and the new Oracle In-Memory column store option. Register now.   Read more...

Presents an open-source T-SQL based version tracking system for MSSQL  Read more...

This post is part of a series on this blog that will help me, and hopefully you, pass exam 70-463: Implementing...  Read more...