Cindy Gross: Small Bites of Big Data, Small Data, All Data
Small Bites of Big Data, Small Data, All Data for Hadoop, SQL Server, Hive, Distributed Systems, Scale Out....
Using Mount Points with SQL Server
Using Mount Points with SQL Server Author: Cindy Gross, Dedicated Support Engineer Tech Reviewer:...
Author: Cindy Gross Date: 07/05/2011
Invite a guest in, or not?
The guest user in SQL Server is a bit of a funny object. While we’re taught to be polite to...
Author: Cindy Gross Date: 04/29/2011
Taming the Tempdb Tempest - WI SQL Server Virtual User Group, 22 Apr 2011
Thanks to the Wisconsin Virtual SQL Server User Group for letting me talk about tempdb today! The...
Author: Cindy Gross Date: 04/22/2011
Save the SQL error logs….
Many people use sp_cycle_errorlog to rollover to a new SQL error log periodically. Please make sure...
Author: Cindy Gross Date: 03/29/2011
24HOP: SQL Server Performance Tools
Thanks to everyone who attended my session today! I think the 740 or so of you overloaded the audio....
Author: Cindy Gross Date: 03/15/2011
General Hardware/OS/Network Guidelines for a SQL Box
I have put together some general guidelines for how you want a server to be delivered to the DBA...
Author: Cindy Gross Date: 03/10/2011
Power Saving Options on SQL Server
Power Saving Options on SQL Server Windows 2008 and Windows 2008 R2 have settings for “Power...
Author: Cindy Gross Date: 03/09/2011
My database is X GB, how big should my log be?
My database is 10GB, how big should my log be? .... I don't know. J That's not enough information to...
Author: Cindy Gross Date: 03/01/2011
Can I Have a Single Node SQL Server Cluster
I occasionally hear the question of whether you can create a one node SQL Server cluster. That...
Author: Cindy Gross Date: 03/01/2011
The ins and outs of MAXDOP
Configuring MAXDOP One of the few sp_configure options that good DBAs regularly change is “max...
Author: Cindy Gross Date: 01/28/2011
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...
Author: Cindy Gross Date: 12/13/2010
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?...
Author: Cindy Gross Date: 11/14/2010
Do I need DTC for my SQL Server?
I get a lot of questions about the "best" way to configure the Distributed Transaction Coordinator...
Author: Cindy Gross Date: 10/18/2010
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...
Author: Cindy Gross Date: 09/30/2010
Kathi Kellenberger interviewed me for the PASS site
Thanks to SQL expert and fellow PASS Women in Technology member Kathi Kellenberger for interviewing...
Author: Cindy Gross Date: 09/05/2010
New Releases - SQL Server Migration Assistant (SSMA)
We have shipped some updates to our migration tool - the SQL Server Migration Assistant (SSMA). It...
Author: Cindy Gross Date: 08/17/2010
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...
Author: Cindy Gross Date: 07/21/2010
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...
Author: Cindy Gross Date: 07/13/2010
Windows storport enhancement to help troubleshoot IO issues
For Windows 2008 and Windows 2008 R2 you can download a Windows storport enhancement (packaged as a...
Author: Cindy Gross Date: 07/13/2010
DBCC CHECKDB / Database Integrity
It is very important to understand DBCC CHECKDB. Make sure you run DBCC CHECKDB periodically and...
Author: Cindy Gross Date: 06/13/2010
SQL Server lifecycle and the compatibility level settings
I've had several people ask how the compatibility mode/level fits in with the SQL Server lifecycle....
Author: Cindy Gross Date: 06/07/2010
New SQL Server Setup Portal is Live!
There's a new setup portal to help you out with any SQL Server 2008 or SQL Server 2008 R2 setup...
Author: Cindy Gross Date: 05/14/2010
No new certifications for SQL 2008 R2
Some of you may be wondering if you should get the SQL Server 2008 certifications or wait for new...
Author: Cindy Gross Date: 05/03/2010
JDBC 3.0 released
We have released our latest JDBC driver Microsoft SQL Server JDBC 3.0 in sync with SQL Server 2008...
Author: Cindy Gross Date: 04/21/2010
SQL Server 2008 R2 is has released!
It’s here! SQL Server 2008 R2 is available and faster than ever! SQL Server 2008 R2 has five...
Author: Cindy Gross Date: 04/20/2010
Visual Studio 2010 has launched!
You can now get Visual Studio 2010 and the Visual Studio 2010 and .NET Framework 4 Training Kit!...
Author: Cindy Gross Date: 04/13/2010
DMV series: sys.dm_db_partition_stats
DMV: sys.dm_db_partition_stats This DMV returns information for the current database context. It can...
Author: Cindy Gross Date: 04/02/2010
Moving data between 32-bit and 64-bit SQL Server instances
I was recently asked about whether SQL Server data can move between architectures, say from x64 to...
Author: Cindy Gross Date: 04/01/2010
SQL Server Performance Tools - Boise Code Camp Presentation
Today I am presenting about SQL Server Performance Tools at the Boise Code Camp. You can download...
Author: Cindy Gross Date: 03/28/2010
Do you use JDBC with SQL Server?
If you use JDBC with SQL Server please fill out our survey before April 5, 2010. This is your chance...
Author: Cindy Gross Date: 03/22/2010
SQL Server 2008 SP1 CU 7 and RTM CU10 Released
This week we released cumulative updates for both RTM (RTM based CU 10) and SP1 (SP1 based CU 7) of...
Author: Cindy Gross Date: 03/19/2010
What do those "IO requests taking longer than 15 seconds" messages on my SQL box mean?
You may be sometimes seeing stuck/stalled IO messages on one or more of your SQL Server boxes. This...
Author: Cindy Gross Date: 03/17/2010
How to Rename SQL Server
How to rename a SQL Server varies a bit depending on the SQL version, whether it is clustered or...
Author: Cindy Gross Date: 02/11/2010
SQL DAC
When you start SQL Server (2005+) it creates a separate "Dedicated Administrator Connection" or DAC...
Author: Cindy Gross Date: 02/11/2010
Remote Desktop Options
You probably use remote desktop to connect to your servers or other desktops. You may see Remote...
Author: Cindy Gross Date: 02/11/2010
SQL 2008 R2 Developer Kit now available!
You can download a free developer kit for SQL Server 2008 R2 (there's also one available for SQL...
Author: Cindy Gross Date: 02/04/2010
How to slipstream SP1 based CU5 into SQL Server 2008
Starting with SQL Server 2008 SP1 you can “slipstream” SP1 and/or SP1 + SP1 based CUs to avoid a...
Author: Cindy Gross Date: 01/21/2010
SQL 2008 R2 releasing in May 2010
SQL Server 2008 R2 gets an official date...
Author: Cindy Gross Date: 01/21/2010
How to Find the Amount of Fragmentation on Your SQL Server Instance
Need to find the amount of fragmentation in all your indexes in all databases for a given instance...
Author: Cindy Gross Date: 01/07/2010
How and Why to Enable Instant File Initialization
See my new blog post (written with Denzil Ribeiro) about "How and Why to Enable Instant File...
Author: Cindy Gross Date: 12/22/2009
Professional SQL Server 2008 Internals and Troubleshooting
Our new book, Professional SQL Server 2008 Internals and Troubleshooting, will be shipping soon!...
Author: Cindy Gross Date: 12/21/2009
Latest SQL Server 2005 Cumulative Updates - SP2 based CU17, SP3 based CU7
There are two new cumulative updates (CUs) available for SQL Server 2005 as of today. · SQL Server...
Author: Cindy Gross Date: 12/21/2009
SQL Server's Default Trace
Are you familiar with SQL Server's default trace setting? It can be helpful with finding basic...
Author: Cindy Gross Date: 12/16/2009
Backing up a corrupted SQL Server database
I had a question about how to do a backup and skip a corrupted block of data. First, DO NOT DO IT...
Author: Cindy Gross Date: 12/02/2009
Compilation of SQL Server TempDB IO Best Practices
It is important to optimize TempDB for good performance. In particular, I am focusing on how to...
Author: Cindy Gross Date: 11/20/2009
SQL Server and Fragmentation
There are several types of fragmentation that affect SQL Server, all of which have the potential to...
Author: Cindy Gross Date: 11/20/2009
SQL Server 2008 setup may report a Windows 2008 cluster validation failure
You may receive the error "The cluster either has not been verified or there are errors or failures...
Author: Cindy Gross Date: 11/20/2009
How to tell what edition your SQL Server setup files are
The setup files for SQL Server look pretty much the same for all editions. If you saved the files...
Author: Cindy Gross Date: 11/20/2009