Brian Moran explains why tuning queries is sometimes a waste of time when you are trying to fix performance and scalability problems in SQL Server.
SQL SERVER – Building Technical Reference Library – Notes from the Field #048
Brian Kelley explains how to build a technical reference library: your own notes, code, settings and bugs you have hit, so help is always close at hand.
SQL SERVER – Database Taking Long Time to Create – Notes from the Field #047
Ever seen a database taking a long time to create? Tim Radney explains in simple words why it happens, based on a real question from a forum.
SQL SERVER – Using the SSIS Term Extraction for Data Exploration – Notes from the Field #046
Tim Mitchell shows how SSIS Term Extraction helps with data exploration, so you understand the source data better before you build an ETL process.
Hey DBA – Go Make a Proactive Investment Today! – Notes from the Field #045
Mike Walsh explains why every DBA should be proactive, then gives all of us one challenge to complete: make a proactive investment today.
SQL SERVER – The Basics of the SSIS Execute SQL Task – Notes from the Field #044
Many developers do not know SSIS can run SQL queries. Andy explains the basics of the SSIS Execute SQL Task in very simple words.
SQL SERVER – Detecting Corruption with Suspect Pages Table – Notes from the Field #043
John Sterrett shows how the suspect pages table helps with detecting corruption, a tip worth learning even if your database has never been corrupted.