THE SQL Server Blog Spot on the Web

Welcome to SQLblog.com - The SQL Server blog spot on the web Sign in | |
in Search

Browse by Tags

All Tags » SQL 2012   (RSS)
  • Skewed Data - Poor Cardinality Estimates... and Plans Gone Bad

    The session Skewed Data, Poor Cardinality Estimates, and Plans Gone Bad by Kimberly Tripp (@KimberlyLTripp) has been published on channel SQLPASS TV.  Abstract When data distribution is heavily skewed, cardinality estimation (how many rows the query optimizer expects each operator to process) can be wildly incorrect, resulting in ...
    Posted to Sergio Govoni (Weblog) by Sergio Govoni on February 14, 2014
  • Review of the book SQL Server 2012 Reporting Services Blueprints

    Recently I had the opportunity to read the book SQL Server 2012 Reporting Services Blueprints written by Marlon Ribunal and Mickey Stuewe and published by Packt Publishing. First, I have to tell you that I am not a Reporting Services guy, I have much more knowledge on other topics such as Database Development, Performance Tuning, and so on. ...
    Posted to Sergio Govoni (Weblog) by Sergio Govoni on January 25, 2014
  • Building Your T-SQL Tool Kit: Window Function Fundamentals

    The session Building Your T-SQL Tool Kit: Window Function Fundamentals by Christina E. Leo (@christinaleo) has been published on channel SQLPASS TV. Abstract Have you pulled a script to identify duplicates from a blog post but couldn't quite get it to work because you weren't sure what that ROW_NUMBER() function was doing? Maybe you ...
    Posted to Sergio Govoni (Weblog) by Sergio Govoni on January 21, 2014
  • Fundamentals of SQL Server 2012 Replication

    From Red-Gate web site you can download, for free (plus a trial of SQL Monitor), the eBook Fundamentals of SQL Server 2012 Replication written by Sebastian Meine (@sqlity). Data replication is traditionally considered a complex feature and generally we get discouraged easily, already during the preparation of the test environment. Why the ...
    Posted to Sergio Govoni (Weblog) by Sergio Govoni on November 13, 2013
  • SQL Server 2012 SP1 Cumulative Update #5 released!

    Microsoft has released the Cumulative Update #5 for SQL Server 2012 SP1: http://support.microsoft.com/kb/2861107/en-us After you have applied the CU5, the version number of SQL Server 2012 SP1 will be 11.0.3373.0.
    Posted to Sergio Govoni (Weblog) by Sergio Govoni on July 15, 2013
  • How to install NetFx3 on Windows Server 2012 (required by SQL Server 2012)

    In this post, we will learn how to install the NetFx3 feature (.Net Framework 3.5) on Windows Server 2012 (R2). This feature is required by SQL Server 2012.   Scenario Recently I have had the opportunity to setup a new Windows Server 2012 (R2) virtual machine in which I must install a new SQL Server 2012 instance. SQL Server 2012 ...
    Posted to Sergio Govoni (Weblog) by Sergio Govoni on July 12, 2013
  • Is the SAN dying???

    Is the SAN dying? The reason that I ask this question is that MSFT has unleashed technologies this year that point in that directionAlways ON Availability Groups shuns shared storageWindows 2012 has Storage Replication Technology that does not require a SANWindows 2012 has Hyper-V Replica Technology that does not require a SANPDW v2 continues to ...
    Posted to Rick Heiges (Weblog) by RickHeiges on December 11, 2012
  • September 12 in San Fran

    Just a reminder that I will be speaking at the SF UG SQL Server User Group on Sep 12.  Here is a link with all of the details.  If you are in the area, It would be great to see you!
    Posted to Rick Heiges (Weblog) by RickHeiges on September 11, 2012
  • Sep 10 Week - I'll be on the West Coast Speaking in Irvine and San Fran

    In my role as a Solutions Architect for Scalability Experts, I often get to present to customers about the work that we performed.  Unfortunately, this is often on short notice and I can't coordinate a trip to participate in a User Group Meeting.  Next week, I was able to coordinate my west coast trip to be able to present.  I am ...
    Posted to Rick Heiges (Weblog) by RickHeiges on September 6, 2012
  • Comparing Standard Editions of SQL Server

    Recently, I've been speaking with customers about upgrading SQL Server.  At times, some customers have a lot of Standard Edition  SQL Server 2005 / 2008 / 2008R2 in their organization and they want to see the features they get when upgrading to SQL Server 2012.  Last week, I sent out some tweets to the #sqlhelp hashtag to see if ...
    Posted to Rick Heiges (Weblog) by RickHeiges on July 10, 2012
Powered by Community Server (Commercial Edition), by Telligent Systems
  Privacy Statement