Welcome to TechNet Blogs Sign in | Join | Help

January 2009 - Posts

Download - SQL Server 2008 System View Poster!!!

Posted Thursday, January 29, 2009 9:19 PM by spawar
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 Read More...
1 Comments

NEW!!! Sydney SQL Server User Group !!!

Posted Tuesday, January 27, 2009 4:48 PM by spawar
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 Read More...
0 Comments

Verifying if a connection to SQL Server is Encrypted

Posted Monday, January 26, 2009 9:25 PM by spawar
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 -- Read More...
0 Comments

How to measure SSIS component/transformation performance

Posted Friday, January 09, 2009 4:46 PM by spawar
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 Read More...
0 Comments

SQL Server CACHING & Performance Testing

Posted Friday, January 09, 2009 4:40 PM by spawar
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 Read More...
0 Comments

SQL Server 2008 – Transparent Database Encryption (TDE)

Posted Friday, January 09, 2009 7:22 AM by spawar
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 Read More...
0 Comments

Microsoft is Positioned in the Leaders Quadrant by Leading Independent Research Firm

Posted Thursday, January 08, 2009 11:24 AM by spawar
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 Read More...
0 Comments

Reporting Services Tip – Automating the creation of multiple charts

Posted Thursday, January 08, 2009 9:42 AM by spawar
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 Read More...
0 Comments
Filed under:
 
Page view tracker