I had a question regarding automating the creation of multiple charts from one dataset, instead of having all the series being plotted on the one chart. An example of where this may be applicable if you have a dataset that has CPU usage for a number of...

SQL Server 2008 System Views - Map just went live and is available for download at http://www.microsoft.com/downloads/details.aspx?FamilyID=531c53e7-8a2a-4375-8f2f-5d799aa67b5c&displaylang=en There is a 2005 version link in Related Downloads at the...

In keeping you informed of third-party evaluations of our products and technologies, I wanted to draw your attention to recent research from Gartner, Inc. ( www.gartner.com ). The report – released December 23, 2008 under the title “ Magic Quadrant for...

Following are some tit bits about TDE in SQL Server 2008: Instant file initialization is disabled for all encrypted databases so page headers are in a known state and the file does not include stray bits off the disk Tempdb is encrypted if there are any...

As you know SQL Server uses caches to speed up access to data and also query plans.   There are two caches one for Data and the other of Query Plans. When you are doing performance testing, with static data and you want to get accurate results of...

To assist in improving performance of your SSIS packages, you are essentially looking at performing a process of elimination performance analysis. You can remove transformations isolating just the source and destination to see if the transforms are causing...

If you do not have a network parser such as netmon and want to verify if the connection from the client to the SQL server is encrypted, the following query can be utilised: SELECT encrypt_option FROM sys.dm_exec_connections WHERE session_id = @@SPID ...

My mate, Victor Isakov (MCT, MCITP, MCM, SQL Ranger) is starting a new SQL Server User Group Meeting during lunchtimes in the Sydney CBD. It will run on the 1st Wednesday of every month, from 12:30 to 14:30, at Westpac Place. This new user group will...