(Rob Farley) Because I hate seeing > or & in my results…

(Chris Skorlinski) Here are some thoughts on using Transactional (or Peer-2-Peer) Replication Subscriber to support both REPORTING and DISATER RECOVERY.

(Adam Machanic) Reports. They’re supposed to look nice. They’re supposed to be a method by which people can get vital information into their heads.

(Dinesh Asanka) This is a setting that DBA are advised to place at the start of the stored procedure.

(Matteo Lorini) Have you ever come across a situation where a query will perform well most of the time, but as soon as you change the predicate value, the same query is 10 to 30 times slower?

(Anu Chawla) Choosing the right number of hard drives and the correct RAID (redundant array of independent disks) configuration when you design your database server can save you a lot of time. If you make a mistake, changing the RAID configuration and moving the database to correct any problems on a

(Thomas LaRock) Auditing your instances of SQL has become more of a concern these days. SQL 2008 introduced a new feature named SQL Server Audit. In this tip I will cover how to setup auditing.

(Bo Chen) There seem to be plenty of articles either from Microsoft’s tech sites or other forums regarding how to manage (add/remove) nodes in SQL Server clusters, however, none of them (at least I didn’t find any) touch this topic in detail. Mismanagement, when adding/removing nodes in SQL Server c

(Tony Davis) It is hard to believe that it was once possible to corrupt a SQL Server Database by storing perfectly normal data values into a table; but it is true. In SQL Server 2000 and before, one could inadvertently load invalid data values into certain data types via RPC calls or bulk insert met

(Sudeep Raj) Scenario: How to delete files created a number of days before today. The files will have the date appended to the file name and we will not check the file properties to decide the file age. The file name would follow the naming convention: File_mmddyyyy.txt