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

Women in Technology – Why Does it Matter?

Women in Technology – Why Does it Matter? The yearly SQL PASS summit is always one of my...

Author: Cindy Gross Date: 12/09/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

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...

Author: Cindy Gross Date: 08/13/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

<Previous Next>