Witty WIT Speakers needed for 24 Hours of PASS – March 2011

SQL PASS is planning another 24 Hours of PASS (24HOP). It will be March 15-16, 2011. Since that is during Women’s History month all the speakers will be women. So if you’re a Woman in Tech (WIT) and know something about SQL or how Windows or storage affects SQL this is a great opportunity!  …


Women in Technology – Why Does it Matter?

Women in Technology – Why Does it Matter?   The yearly SQL PASS summit is always one of my favorite times of year. It’s a week packed full of great technical content and many networking opportunities. Not to mention the parties and fun. J And of course the #sqlkilts. One of the highlights of the…


New Opportunities to be a SQL Master

Have you ever wanted to prove to yourself and others just how much you really know about SQL Server? The MCITP exams are a great start; they show you have a baseline level of knowledge about the product. However, sometimes it is possible to pass the MCITP level exams with little real world experience. For…


Do I need DTC for my SQL Server?

I get a lot of questions about the “best” way to configure the Distributed Transaction Coordinator (DTC) for SQL Server on a Windows 2008 cluster. There is no one best way to do it, and the first question you ask should be “do you even use DTC and if so how and how often?”. If…


Out with the Old (SQL 7.0) and in with the New (SQL 2008 SP2)

We are fast approaching the end of support for SQL Server 7.0. It has been in “extended support” for a while, meaning you could call for help but no non-security hotfixes would be created. But after January 11, 2011 extended support for SQL Server 7.0 ends and you will no longer be able to contact…


Kathi Kellenberger interviewed me for the PASS site

 Thanks to SQL expert and fellow PASS Women in Technology member Kathi Kellenberger for interviewing me for the PASS site! An Interview with Microsoft Employee Cindy Gross


New Releases – SQL Server Migration Assistant (SSMA)

We have shipped some updates to our migration tool – the SQL Server Migration Assistant (SSMA). It is now easier than ever to migrate to SQL Server 2005, 2008, and/or 2008 R2 from Access, Oracle, Sybase, and MySQL. You can even use SSMA to migrate from Access or MySQL to SQL Azure.   Customers and…


Memory Trimming: A significant part of sql server process memory has been paged out.

I have written about this topic before (in my old SQLCommunity blog) but I still see lots of questions about it. So here is a simplified explanation of this memory trimming issue that is common with SQL Server on Windows 2003. On Windows 2003 you may occasionally see memory trimming messages in your SQL Server…


Online learning with Kalen Delaney – SQL Server 2008 Indexes – Internals and Best Practices

Kalen always does a great job of explaining the guts of SQL Server. She has a deep, intuitive grasp of index internals. Even better, she can take that knowledge and share it so everyone can learn something, whether you’re a relative newbie or a veteran. This particular workshop is a deep-dive with advanced topics so…


CTP of SP2 for SQL Server 2008 is now available

SQL Server 2008 will soon have a new service pack – SP2. SQL Server service packs go through a CTP (aka beta) cycle prior to release. The CTP of SP2 is now available for you to download and test. This is only the pre-release version, so only use it for testing.   ·         SQL Server…