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: November 2012

Find month: Show current month
SunMonTueWedThuFriSat
1st

SQLServerCentral Newsletter

  • Manipulating XML Data in SQL Server
  • MDX Guide for SQL Folks: Part I - Navigating The Cube
  • Checking In
  • Generate Insert Scripts
2nd

SQLServerCentral Newsletter

  • Parsing Parameters in a Stored Procedure
  • SQL Server Function to return a range of dates
  • Last chance for a day of free SQL Server training at SQL in the City 2012
  • A Welcome Delay
  • Shrinking all log files on SQL Server 2008R2
3rd
4th
5th
6th

SQLServerCentral Newsletter

  • Free eBook: SQL Server Hardware
  • Tracking Database File AutoGrowth with Event Notifications
  • Using SQL Server Concatenation Efficiently
  • Unprotected Queries
  • Table Search Based on the Column
7th

SQLServerCentral Newsletter

  • The OLAP Sprint
  • Stairway to Transaction Log Management in SQL Server, Level 6: Managing the Log in BULK_LOGGED Recovery Model
  • SQL Server 2012: Installing Data Quality Services
  • Savvy Managers
  • Search for String in all columns
8th

SQLServerCentral Newsletter

  • Day 1 of The OLAP Sprint
  • Partitioned Tables, Indexes and Execution Plans: a Cautionary Tale
  • Memory Corruptions, or Why You Need DBCC CHECKDB
  • More Than One Way to Skin a Cat
  • Smart Index Rebuild - All Databases
9th

SQLServerCentral Newsletter

  • Reading SQL Server's Transaction Log
  • Day 2 of the OLAP Sprint
  • Script to create dynamic PIVOT queries in SQL Server
  • What Do You Want from SQL in the City?
  • Top 14 KPI
10th
11th

Database Weekly

    12th

    SQLServerCentral Newsletter

    • Data Mining Introduction
    • Day 3 of The OLAP Sprint
    • SQL Server 2012 Build List
    • Viewing VMware Counters in PerfMon for SQL Server
    • Monitoring is Essential
    • Script to construct a restore/recovery script
    13th

    SQLServerCentral Newsletter

    • Designing Databases for Rapid Resilience
    • Hierarchies on Steroids #1: Convert an Adjacency List to Nested Sets
    • Day 4 of The OLAP Sprint
    • Too Much Data
    • SCD Implementation with TSQL
    14th

    SQLServerCentral Newsletter

    • Day 5 of The OLAP Sprint
    • Prevent Truncation of Dynamically Generated Results in SQL Server Management Studio
    • Stairway to SQL Dialects Level 2: Postgres
    • The Future of DBAs
    • Quantization of an RGB color code into a palette
    15th

    SQLServerCentral Newsletter

    • Hierarchies on Steroids #2: A Replacement for Nested Sets Calculations
    • FileStream and FileTable in SQL Server 2012
    • Day 6 of The OLAP Sprint
    • Failure Lessons
    • Index-scripting UDF
    16th

    SQLServerCentral Newsletter

    • Generating SubTotals using GROUPING
    • Day 7 of The OLAP Sprint
    • SQL Server 2012 AlwaysOn: Multisite Failover Cluster Instance
    • SQL Saturday #168 - Tampa BI Edition
    • The Cost of Storage
    • Dynamic Transaction Log Backup
    17th
    18th

    Database Weekly

      19th

      SQLServerCentral Newsletter

      • Create SQL Server Analysis Services Partitions using AMO
      • SQL Saturday #179 - Kharkov, Ukraine
      • 5 Reasons You Must Start Capturing Baseline Data
      • Human Power
      • SQL Server Documenter
      20th

      SQLServerCentral Newsletter

      • Has tempdb grown since the last restart?
      • Free ebook: Troubleshooting SQL Server: A Guide for the Accidental DBA
      • Performance Tuning Re-indexing and Update Statistics – A Case Study
      • A Tool for the Job
      • Deleting Duplicate Records
      21st

      SQLServerCentral Newsletter

      • The Small Print
      • Dynamic Database Backup
      22nd

      SQLServerCentral Newsletter

      • Happy Thanksgiving 2012
      • RAID and Its Impact on your SQL Performance
      • Thanksgiving 2012 Bloopers
      • Top 10 Wait State Issues Reporter
      23rd

      SQLServerCentral Newsletter

      • SQL Server Transaction Log Fragmentation: a Primer
      • Returning the Top X row for each group (SQL Spackle)
      • The SQL Server Pro Awards
      • Script for no of Index in a table
      24th
      25th

      Database Weekly

        26th

        SQLServerCentral Newsletter

        • Handling Backups for Rapid Resilience
        • Stairway to Transaction Log Management in SQL Server, Level 7: Dealing with Excessive Log Growth
        • SQL Saturday #181 - Tokyo
        • Review Your Indexing
        • Intelligent Index Reorganize and Rebuild Script - v1.0
        27th

        SQLServerCentral Newsletter

        • SQL Saturday #182 - Istanbul
        • Understanding the SQL Server 2012 BI Semantic Model (BISM)
        • Back to Basics: Capturing Baselines on Production SQL Servers
        • Targeted Learning
        • Scripting CREATE INDEX Statements Automatically From Your Tables
        28th

        SQLServerCentral Newsletter

        • What MAXDOP Setting Should be Used for SQL Server
        • Advanced Event Behavior – Level 10 of the Stairway to Integration Services
        • Regulators, Mount Up
        • Query to get Database Size and Growth Report
        29th

        SQLServerCentral Newsletter

        • Free eBook: The Red Gate Guide to SQL Server Team-based Development
        • Database Deployment: The Bits - Getting Data In
        • Splitting Strings Based on Patterns
        • Don't Explain Too Much
        • Print Text Month Calendar
        30th

        SQLServerCentral Newsletter

        • Auditing SQL Server 2012 Server Roles
        • Stairway to Server-side Tracing - Level 10: Profiler versus Server-Side tracing
        • Staging Deployments
        • Dependencies View 2008
        Previous month