Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 

Stay up to date!

Are these newsletters useful? Register to stay up to date with the latest news, articles, scripts and forum posts.

Email address:  

Subscribing to our newsletters gets you:

  • ALL of our content (thousands of articles, scripts, and forum postings)
  • A daily newsletter (example)
  • A weekly news round up in our Database Weekly newsletter (example)
  • The opportunity to ask and answer questions in our forums
  • A daily Question of the Day to test and help you increase your knowledge of SQL Server.

Steve Jones
Editor, SQLServerCentral.com

Newsletter Archive: September 2012

Find month: Show current month
SunMonTueWedThuFriSat
1st
2nd

Database Weekly

    3rd

    SQLServerCentral Newsletter

    • Stairway to Server-side Tracing - Level 8: How to Automate Traces with SSIS
    • Cleaning Up SQL Server Deployment Scripts
    • SQL Saturday #154 | St.Louis, MO
    • SQL Saturday #156 - Providence, RI
    • Labor Day 2012
    • Find Mismatched Views and Stored Procs
    4th

    SQLServerCentral Newsletter

    • SQL in the City - New York 2012
    • SQL Server Data Type Precedence
    • Combining AlwaysOn Groups With Failover Cluster Instances
    • SQL Saturday #170 - Munich, Germany
    • Ridiculous
    • Drop FK For A Specific Table
    5th

    SQLServerCentral Newsletter

    • SQL in the City - Austin 2012
    • SQLskills training goes online worldwide (and free in September!)
    • Stairway to T-SQL DML Level 9: Adding Records to a table using INSERT Statement
    • Upgrading SSIS Custom Components for SQL Server 2012
    • Rogue Algorithms
    • Insert Update Stored Procedure for a table
    6th

    SQLServerCentral Newsletter

    • How to save results of a procedure with more than one result set
    • How to Find Outdated Statistics in SQL Server 2008
    • SQL in the City - San Francisco 2012
    • SQL Saturday #162 - Cambridge, UK
    • Privacy
    • Generate C# class code for table
    7th

    SQLServerCentral Newsletter

    • Key Word Searches
    • Practical PowerShell for SQL Server Developers and DBAs – Part 2
    • SQL Saturday #157 - San Diego
    • Red Gate Software announces speaker line up for US SQL in the City tour
    • The Dream Machine
    • Check AD membership
    8th

    Database Weekly

      9th
      10th

      SQLServerCentral Newsletter

      • SQLskills training goes online worldwide (and free in September!)
      • SQL Saturday #155 - Lima
      • Meredith Ryan Chosen as the Exceptional DBA of 2012
      • Gail Shaw's SQL Server Howlers
      • Fun with Outer Joins
      • A Cloudy Future
      • ASCII Character Groups in String
      11th

      SQLServerCentral Newsletter

      • SQL Saturday #169 - Denver
      • From Hairdresser to DBA – How to start a career in IT
      • Objects, Relationships, Systems, And Processes
      • SQL in the City - Boston 2012
      • Mining and Algorithms
      • Check SQL Job timings
      12th

      SQLServerCentral Newsletter

      • Advanced SSIS Workflow Management – Level 8 of the Stairway to Integration Services
      • SQL Server Resources - A list
      • SQL in the City - Chicago 2012
      • SQLSaturday #160 - Kalamazoo
      • Creativity
      • Database_Object_Last_used_details
      13th

      SQLServerCentral Newsletter

      • Webinar: Temporary Tables in Oracle and SQL Server
      • SSC Clinic: Finding the rogue query
      • SQL in the City - Seattle 2012
      • Ten Things I Wish I’d Known When I Started Using tSQLt and SQL Test
      • More CPU Means More Data
      • Query to check whether my Full Database Backup is running fine.
      14th

      SQLServerCentral Newsletter

      • Choosing a Tabular or Multidimensional Modeling Experience in SQL Server 2012 Analysis Services
      • Red Gate Software announces speaker line up for US SQL in the City tour
      • Why doesn’t ISNUMERIC work correctly? (SQL Spackle)
      • A Quick Count
      • Search for an object across multiple databases on a server.
      15th
      16th

      Database Weekly

        17th

        SQLServerCentral Newsletter

        • SQL in the City - New York 2012
        • Never update systems tables directly - a study in Agent job scheduling
        • TSQL Challenge 82 - Find elements that uniquely make up a group
        • Distributed Computing - Hybrid Systems Considerations
        • Three Rules for Database Development
        • Show all Objects used by Linked Server
        18th

        SQLServerCentral Newsletter

        • SQL in the City - Austin 2012
        • Run an Oracle package from SQL Server Integration Services
        • SQL Server 2012: Migrating BLOBs to FILETABLEs
        • Fuzzy-String Search: Find misspelled information with T-SQL
        • Compress Everything
        • What got restored from where, by who and when
        19th

        SQLServerCentral Newsletter

        • Improve Your Database Unit Testing Skills and Win Free Stuff
        • SQL in the City - San Francisco 2012
        • Stairway to T-SQL DML Level 11: How to Delete Rows from a Table
        • Dress Like Steve
        • Failover or Restart Results in Reseed of Identity - FIX
        20th

        SQLServerCentral Newsletter

        • SQLServerCentral Webinar Series #21 - Forgotten Rings & Other Monitoring Stories
        • Report Builder 3.0: Formatting the Elements in your Report
        • SQL in the City - Chicago 2012
        • Stairway to XML: Level 1 - Introduction to XML
        • Data Worms
        • Run SQL Hosted VBS Script from SQL
        21st

        SQLServerCentral Newsletter

        • Grant’s video warning – backup verification
        • How to receive Deadlock information automatically via email
        • Power View Infrastructure Configuration and Installation: Step-by-Step and Scripts
        • SQL in the City - Boston 2012
        • Teammates
        • SQL Server Index Defragmentation (Updated)
        22nd
        23rd

        Database Weekly

          24th

          SQLServerCentral Newsletter

          • SQL Database Management Survey
          • The Importance of Validating Backups
          • Why is that SQL Server Instance under stress?
          • Rewrite the Coding Rules
          • Backup Database Size calculation Report - Monthwise
          25th

          SQLServerCentral Newsletter

          • Webinar: Temporary Tables in Oracle and SQL Server
          • SQLServerCentral Webinar Series #21 - Forgotten Rings & Other Monitoring Stories
          • Meredith Ryan: DBA of the Day
          • DAX Query Basics
          • Trade-offs
          • SQL Start up Script
          26th

          SQLServerCentral Newsletter

          • Database Security Survey
          • Find out which SQL Server instance is consuming most of the CPU
          • SQL in the City - Seattle 2012
          • Stairway to XML: Level 2 - The XML Data Type
          • Pair Programming
          • Index Defragmentation
          27th

          SQLServerCentral Newsletter

          • Temporary Tables in Oracle and SQL Server
          • Repairing a Broken Log Shipping Plan From a Differential Backup
          • SQL Database Management Survey
          • An Interview with Amazon Web Services
          • Ten Things I Wish I'd Known When I Started Using tSQLt and SQL Test
          • Outsourcing Security
          • Find all actual words from Dictionary Table using jumbled word
          28th

          SQLServerCentral Newsletter

          • A simple T-SQL statement to create a list of lookup values
          • Data Access Tracing in SQL Server 2012
          • NCAs and NDAs
          • SQL Server Uptime
          29th
          30th

          Database Weekly

            Previous month