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

Browse by Tags

Tagged Content List
  • Blog Post: PASS BAC PREVIEW SERIES: SQL Professionals and the World of Self-service BI and Big Data

    Are you excited about the upcoming PASS Business Analytics Conference? You should be! This conference will offer a wide range of sessions about Microsoft's End to End Business Intelligence (including Self-Service BI), Analytics, Big Data, Architecture, Reporting, Information Delivery, Data Management...
  • Blog Post: 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 slides and demo queries are attached. Once the recording is available I will update this blog with a link to it. Taming the Tempdb Tempest Summary: · Multiple data files of the same size...
  • Blog Post: 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...
  • Blog Post: 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...
  • Blog Post: 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 2008 Service...
  • Blog Post: 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 hotfix). This enhancement can lead to faster root cause analysis for slow IO issues. Once you apply this Windows hotfix you can use Event Tracing for Windows (ETW) via perfmon or xperf to capture more...
  • Blog Post: DBCC CHECKDB / Database Integrity

    It is very important to understand DBCC CHECKDB. Make sure you run DBCC CHECKDB periodically and that if you do find some sort of corruption you address it immediately - both the current problem in the SQL Server database and the underlying problem that caused it. · How often should we run...
  • Blog Post: 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 . For example, the question might be: once we no longer support SQL Server 2000, does that mean we don't support databases restored/attached to later versions of SQL and still set to 80 compatibility mode...
  • Blog Post: 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 issues. You can search for setup content, get downloads, watch videos and more. Learn how to slipstream (new in SQL 2008 SP1) or sysprep (new in R2). Check it out and let us know what you think! SQL Server...
  • Blog Post: 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 published TPC-E benchmark results. It holds the top four performance results and the best price/performance result. The testing used up to 96 cores. Did you catch that coolness? We can now use more than 64 cores...
  • Blog Post: DMV series: sys.dm_db_partition_stats

    DMV: sys.dm_db_partition_stats This DMV returns information for the current database context. It can tell you how many rows are in each table (per partition) and how much of the space is used and reserved for in-row, overflow, and LOB data (with or without the metadata overhead). Remember...
  • Blog Post: 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 x86. Yes, you can move SQL Server data back and forth between x64, x86, and IA64 architectures. The data and log files themselves do not store anything that indicates the architecture and work the...
  • Blog Post: 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 the slides and supporting files here on this blog (at the bottom it says Attachment(s): PerformanceTools.zip ). The basic agenda of items covered is: ¢ Methodology ¢ SQLDiag ¢ PSSDiag ...
  • Blog Post: 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 to provide input for our next release, so take advantage while you can! http://blogs.msdn.com/jdbcteam/archive/2010/03/18/microsoft-sql-server-jdbc-survey.aspx
  • Blog Post: 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 is something it is important to understand so I am providing some background information on it. Here is the message you may see in the SQL error log: SQL Server has encountered xxx occurrence...
  • Blog Post: How to Rename SQL Server

    How to rename a SQL Server varies a bit depending on the SQL version, whether it is clustered or not, and whether you want to rename the server/virtual server part of the name (works except for SQL 2000 clusters) or the instance part of the name (requires a reinstall). Also, you do not want to try renaming...
  • Blog Post: SQL DAC

    When you start SQL Server (2005+) it creates a separate "Dedicated Administrator Connection" or DAC using a special TCP port. One sysadmin at a time can connect with this DAC connection by specifying Admin:ServerName\Instance. From SQLCMD you can either prefix the server name with Admin: or you can use...
  • Blog Post: SQL 2008 R2 releasing in May 2010

    SQL Server 2008 R2 gets an official date http://blogs.technet.com/dataplatforminsider/archive/2010/01/19/sql-server-2008-r2-gets-an-official-date.aspx SQL Server 2008 R2 gets May release date http://www.infoworld.com/d/applications/sql-server-2008-r2-gets-may-release-date-497?source=rss_infoworld_news...
  • Blog Post: 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 Initialization " on our PFE blog . Keep an eye on the PFE blog for more posts from my team in the near future.
  • Blog Post: Professional SQL Server 2008 Internals and Troubleshooting

    Our new book, Professional SQL Server 2008 Internals and Troubleshooting, will be shipping soon! Order now! :-) Christian Bolton , Justin Langford , Brent Ozar , and James Rowland-Jones have each written several chapters in this book. Steven Wort , Jonathan Kehayias and I each contributed a chapter as...
  • Blog Post: 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 2005 SP2 based CU17 ( 9.00.3356) . This is the last SP2 based CU as SP2 will no longer be supported after 1/12/2010 . KB = Cumulative update package 17 for SQL Server 2005 Service Pack 2 http://support...
  • Blog Post: SQL Server's Default Trace

    Are you familiar with SQL Server's default trace setting? It can be helpful with finding basic who/when type information on major events. For example, you may want to know who was creating and dropping databases on a given instance. SQL Server has a couple of options that might help you find out...
  • Blog Post: 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 unless you absolutely have to, such as when you are taking a backup prior to trying to fix the corruption (which means you should be on the phone with Microsoft PSS). If you do skip corrupted data you have...
  • Blog Post: 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 allocate files. TempDB is a unique database in several ways. The ones most relevant to this discussion are: · It is often one of the busiest databases on an instance. This means the performance...
  • Blog Post: SQL Server and Fragmentation

    There are several types of fragmentation that affect SQL Server, all of which have the potential to cause performance problems. 1) At the disk/OS level individual files can become fragmented due to growth over time. This can be addressed by a defragmentation tool at the SAN or Windows level. Ask your...
Page 1 of 2 (40 items) 12