(Tony Davis) In any engineering project, you can’t avoid testing your product against reality. A friend who once worked at a car design center told me that throughout each development cycle, in adding to a component-testing program with test-rigs and simulations, they would drive each newly-designed

(Robert Sheldon) SQL Server Enterprise provides Transparent Data Encryption (TDE), an encryption technology built into the database engine for protecting confidential information at the database level.

(Scott Murray) What are the SQL Server Reporting Services Document Map and Bookmark properties? How can they be used? Do they work for all rendering formats? Can you show me any examples?

(Rohit Garg) Steps of Moving MSDB & Model SQL Server system Database to new locaation:-

(Kris Wenzel) This article is inspired by a series of questions that one of my readers, Nan, recently sent me regarding DISTINCT, TOP, and ORDER BY.

(Thomas LaRock) Friction. It’s all around us. You might say friction is what makes the world go ’round. A constant battle between irresistible forces meeting immovable objects. In the end, something gives.

(Pinal Dave) While talking to one of the attendees after my session at GIDS, I realized that I don’t have much information available on my blog about the usage of one of the fantastic performance tuning tool called Database Engine Tuning Advisor.

(Daniel Calbimonte) In part 1, part 2 and part 3 of this series, I compared SQL commands for MariaDB and SQL Server. In this tip, we will review some of the operational items related to the database platforms.

(Pinal Dave) Playing around with DMVs is so much fun. Many a times we need little inspiration and a problem in hand to solve. Out of many things I monitor, I have personally seen folks having trouble in finding what is going wrong when the server turns slow.

(Chris Bell) Sometimes you just want to get an idea of what’s going on with your SQL Server.