THE SQL Server Blog Spot on the Web

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

Search

You searched for the word(s):
Showing page 1 of 2 (19 total posts) < 1 second(s)
  • Introducing Microsoft SQL Server 2014

    The release of the latest two versions of SQL Server (2008 R2 and 2012) has been accompanied by the publication of their respective eBooks. On April 2nd, a post on Microsoft Press Blog has announced the publication of the eBook Introducing Microsoft SQL Server 2014! &nbsp; This eBook is divided in two parts; the first one is dedicated to ...
    Posted to Sergio Govoni (Weblog) by Sergio Govoni on April 6, 2014
  • Unexpected SPID change

    A few time ago I had the opportunity to investigate about an unexpected SPID (Session&nbsp;Process ID) change. The inquiry began when a customer of ours starts to complain for locks, and lock time out error. These locks sometime were more frequent and sometimes not. To investigate about this issue, I have taken two SQL Profiler trace files ...
    Posted to Sergio Govoni (Weblog) by Sergio Govoni on April 3, 2014
  • Hurry up! Buy one book and get one for free on Packt Publishing!

    Packt Publishing wants to celebrate the release of their 2000th title with the great offer ''Buy One, Get One Free'' applied into their comprehensive catalog. If you buy a book, of your choice, you will get another one for free. In addition, you will exploit this offer unlimitedly during the offer period. I suggest you to take a look to ...
    Posted to Sergio Govoni (Weblog) by Sergio Govoni on March 26, 2014
  • Performance Tuning with SQL Server Dynamic Management Views

    From Red-Gate website you can download (for free) the ebook Performance Tuning with SQL Server Dynamic Management Views&nbsp;written by Louis Davidson (@drsql) and Tim Ford (@sqlagentman). DMVs are objects that publish information about the health state of a SQL Server instance. They allow you to monitor the heart of the system to diagnose ...
    Posted to Sergio Govoni (Weblog) by Sergio Govoni on March 14, 2014
  • Troubleshooting Clusters

    The session Troubleshooting Clusters by Allan Hirt (@SQLHA) has been published on channel SQLPASS TV. Abstract Whether you are new to clusters or have years of experience, you may still cross your fingers when implementing a failover cluster instance (FCI) of SQL Server or an availability group (AG). Both require an underlying Windows Server ...
    Posted to Sergio Govoni (Weblog) by Sergio Govoni on February 23, 2014
  • 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.&nbsp;&nbsp;Abstract&nbsp;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&nbsp;by Christina E. Leo (@christinaleo) has been published on&nbsp;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
  • Automate Your ETL Infrastructure with SSIS and PowerShell

    SQLPASS TV channel has been published the session Automate Your ETL Infrastructure with SSIS and PowerShell that Allen White (@SQLRunr) has done during the PASS Summit 2013.&nbsp; Abstract Much of your ETL process flow consists of packages that are very similar in structure, capturing data from a single source and transferring that to a single ...
    Posted to Sergio Govoni (Weblog) by Sergio Govoni on December 25, 2013
  • PASS DW/BI Virtual Chapter Upcoming Sessions (December 2013)

    Let me point out the upcoming live events scheduled for December 2013 organized by&nbsp;PASS Business Intelligence Virtual Chapter. &nbsp; Create and Load a Staging Environment from Scratch in an Hour with Biml Date: Thursday 12 December Noon PST / 3 PM EST / 8 PM GMTSpeaker: Scott CurrieURL: ...
    Posted to Sergio Govoni (Weblog) by Sergio Govoni on December 6, 2013
1 2 Next >
Powered by Community Server (Commercial Edition), by Telligent Systems
  Privacy Statement