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: 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...
  • Blog Post: 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 Microsoft...
  • Blog Post: 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...
  • 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: 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 SQL Server 2008. · Build 2766: Cumulative update package 7 for SQL Server 2008 Service Pack 1 http://support.microsoft.com/kb/979065/en-us · Build 1835: Cumulative update package 10 for SQL Server...
  • Blog Post: 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 2008, the link is at the bottom of the R2 download page). Each kit has videos, samples, labs, and more to help you learn about new features. For instance, I can open the FILESTREAM.HTM page and have access...
  • Blog Post: 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 multi-step installation process. http://blogs.msdn.com/petersad/archive/2009/04/16/create-a-merged-slipstream-drop-containing-sql-server-2008-server-pack-1-and-a-cumulative-update-cu-based-on-server...
  • Blog Post: 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 of SQL Server 2005 or later? You can use the undocumented/unsupported sp_MSforeachdb to loop through all the databases. For more information on fragmentation see my previous blog http://blogs.msdn.com/cindygross...
  • Blog Post: How People Abuse Their SQL Server Transaction Log - Things NOT to Do

    Care and Feeding of the Transaction Log Want to learn more about how the transaction log works? Kalen Delaney, celebrated author of SQL Server 2008 Internals and the Inside SQL Server series as well as a world class trainer and performance tuner, is giving a pre-conference talk at SQL PASS next...
  • Blog Post: SQL Server Security Granularity

    I have had some questions recently about how to grant developers certain permissions without giving them sysadmin rights. Hopefully this summary will help you determine how to grant the least possible privileges. The summary is based on SQL Server 2005 but will also apply to SQL Server 2008. · I would...
  • Blog Post: SQL Server 2008 SP1 is now available

    SQL Server 2008 SP1 (build 2531) is now available. Downloads SQL Server 2008 Service Pack 1 Microsoft® SQL Server® 2008 Express Edition Service Pack 1 Microsoft SQL Server 2008 Feature Pack, April 2009 Microsoft SQL Server 2008 Upgrade Advisor, April 2009 Microsoft SQL Server 2008...
  • Blog Post: How to configure DTC for SQL Server in a Windows 2008 cluster

    How to configure DTC for SQL Server in a Windows 2008 cluster [This post was revised 11 May 2009 with new mapping information, fixed formatting issues 23 March 2010] With Windows 2008 you now have the option to use multiple DTCs. There is a lot of confusion over whether to do that for SQL Server...
Page 1 of 1 (12 items)