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 » SQLPASS TV   (RSS)
  • 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.  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
  • 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
  • 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.  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
Powered by Community Server (Commercial Edition), by Telligent Systems
  Privacy Statement