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: January 2013

Find month: Show current month
SunMonTueWedThuFriSat
1st

SQLServerCentral Newsletter

  • Free Tools for the DBA: PAL Tool
  • Automatically Generate Stored Procedures
  • The Year 2013
  • Generate Drop / Create Script for views, stored Procedures
2nd

SQLServerCentral Newsletter

  • Querying SQL Server Agent Job History Data
  • Stairway to SQL Server Agent: Level 1: Setup and Overview
  • Hacked
  • Find Largest size Tables in a Database
3rd

SQLServerCentral Newsletter

  • Single Quotation Marks in SQL
  • Free eBook: Inside the SQL Server Query Optimizer
  • Partitioning in SQL Server
  • All Flash
  • Find failed SQL Jobs
4th

SQLServerCentral Newsletter

  • The SSIS Data Pump - Level 2 of the Stairway to Integration Services
  • Row Sorting in SQL
  • DR Prep
  • Search All Stored Procedures in a Database
5th

Database Weekly

    6th
    7th

    SQLServerCentral Newsletter

    • Double Counting and Sign Reversals
    • How Come the Hourglass? Why Database Applications Slow Down
    • The $50,000 Laptop
    • The Ultimate Missing Index Finder
    8th

    SQLServerCentral Newsletter

    • Free Webinar: Statistics in Oracle and SQL Server
    • Using the Script Task in SSIS to Process Data Files When They Arrive
    • Partitioning in SQL Server - Part 2
    • Statistical Protection
    • AUTOGENERATE INSERT UPDATE SELECT STATEMENTS UPDATED
    9th

    SQLServerCentral Newsletter

    • Stairway to XML: Level 1 - Introduction to XML
    • SQL Server Rounding Functions - Round, Ceiling and Floor
    • Is Big Data good for Data Professionals?
    • Defragmenting and rebuilding indexes
    10th

    SQLServerCentral Newsletter

    • SQL Server T-SQL Tuning -TVF and Scalar Functions
    • Introducing Boomerang - A Notification Framework
    • SQLServerCentral Runs sp_Blitz - Security
    • A Patch Disaster
    • Script to replace 5 consecutive digits with special character
    11th

    SQLServerCentral Newsletter

    • Using MDX to Calculate Both Values and Percentages for Analysis Services
    • An Introduction to Database Design
    • Free Webinar: Statistics in Oracle and SQL Server
    • Free eBook: SQL Server Tacklebox
    • The Auditing Poll
    • 2008 Index Fragmentation Maintenance
    12th
    13th

    Database Weekly

      14th

      SQLServerCentral Newsletter

      • Developing a SQL Server Backup Strategy
      • Using a TSQL semaphore in SSIS
      • Global Insecurities
      • Finding actual number of physical cpu installed
      15th

      SQLServerCentral Newsletter

      • SQLServerCentral Runs sp_Blitz - Reliability
      • Creating SSIS Package Templates for Reusability
      • How to write a custom metric
      • Cramming for Interviews
      • Recreate a temporary table from TempDB
      16th

      SQLServerCentral Newsletter

      • Stairway to T-SQL DML Level 12: Using the MERGE Statement
      • Free Webinar: Statistics in Oracle and SQL Server
      • SQL Server T-SQL Tuning – NOT IN and NOT Exists
      • Message Queues in Software
      • Database details for Daily checks
      17th

      SQLServerCentral Newsletter

      • Handling Errors in SQL Server 2012
      • Free eBook: SQL Server Execution Plans
      • Fun with ACID
      • Serious Security
      • GetDateInString
      18th

      SQLServerCentral Newsletter

      • Working With Multi-Select Parameters for SSRS Reports
      • Data Everywhere - Level 3 in the Stairway to Reporting Services
      • The Growth of Storage
      • Convert string Hex to Numeric with inline TSQL
      19th

      Database Weekly

        20th
        21st

        SQLServerCentral Newsletter

        • VARCHAR (MAX), NVARCHAR (MAX) and NTEXT Data Types
        • SQL Saturday #185 - Trinidad
        • Antipathy for Entity Attribute Value data models
        • The Optimists
        • Finding out whether you are using enterprise level feature
        22nd

        SQLServerCentral Newsletter

        • SQLServerCentral Runs sp_Blitz - Performance Part 1
        • Hypothetical Indexes on SQL Server
        • Free Webinar: Statistics in Oracle and SQL Server
        • Encryption Not Restriction
        • Truncate or switch range of a partitioned table
        23rd

        SQLServerCentral Newsletter

        • Capturing Baselines on SQL Server: Where's My Space?
        • Troubleshooting SQL Server RESOURCE_SEMAPHORE Waittype Memory Issues
        • Building Better Software
        • Check Candidate Columns for NOT NULL Constraints
        24th

        SQLServerCentral Newsletter

        • Free eBook: SQL Server Backup and Restore
        • Securing SQL Server 2012 Integration Services Packages using Digital Certificates
        • T-SQL Restore Script Generator
        • Serverless Software
        • Grouped Failover, a 2008R2 version of Availability Groups
        25th

        SQLServerCentral Newsletter

        • Stairway to SQL Server Indexes: Level 3, Clustered Indexes
        • We Loaded 1TB in 30 Minutes with SSIS, and So Can You
        • Free eBook: SQL Server Backup and Restore
        • Geeky Oscars
        • Table-Column Data Profiler
        26th

        Database Weekly

          27th
          28th

          SQLServerCentral Newsletter

          • Update statistics in parallel
          • SQL Server 2012 Build List
          • Beating Backup Corruption
          • Still 32
          • List Database Users and their Corresponding Roles
          29th

          SQLServerCentral Newsletter

          • Providing SQL Agent Job Log Data for Developers
          • My SQL Server Database is Corrupt - Now What?!
          • Acing an Audit
          • SQL Job Timeline (Graphical)
          30th

          SQLServerCentral Newsletter

          • SQL Server Performance Tuning – Index Tuning
          • Stairway to XML: Level 9 - Creating XML-Based Functions
          • SQL Server 2008 Build List
          • The Knowledge Graph
          • Open transactions on a database
          31st

          SQLServerCentral Newsletter

          • SQL Server 2012 Integration Services - Introduction to Managing SQL Server with PowerShell
          • Custom Metric - Indexes with Excessive Writes
          • Templates and teamwork
          • A New Type of Colocation Facility
          • Change database compatability level of all databases
          Previous month