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

Find month: Show current month
SunMonTueWedThuFriSat
1st

SQLServerCentral Newsletter

  • SQL Server Statistics Questions We Were Too Shy to Ask
  • New Free Event for Database Professionals in Virginia
  • SQL Server Central Webinar Series #22 – What counts for a DBA (Wednesday, March 13 2013 5:00pm - 6:00pm GMT)
  • Using a Variable for an IN Predicate
  • Why SQL Server?
  • Compress all Objects
2nd
3rd

Database Weekly

    4th

    SQLServerCentral Newsletter

    • How to recover a SQL Server login password.
    • SQL Saturday #187 - Richmond
    • How to move a SQL Server Log Shipped Secondary Database to Different SQL Server
    • Does Connect Work?
    • Copy Triggers from One DB to Another
    5th

    SQLServerCentral Newsletter

    • An Incremental Database Development and Deployment Framework
    • SQL Server Central Webinar Series #22 – What counts for a DBA (Wednesday, March 13 2013 5:00pm - 6:00pm GMT)
    • Working with SQL Server Recovery Models
    • Data We Don't Want
    • SQL 2012 Always On Status Report
    6th

    SQLServerCentral Newsletter

    • Help Guide the Future of SQL Compare
    • SQL Saturday #194 - Exeter
    • Using Temp Tables in SSIS
    • Hidden Tricks To SQL Server Table Cleanup
    • Two Plugs Away
    • Replace Special Character and Keep What You Want
    7th

    SQLServerCentral Newsletter

    • A SQL-Based Universal Currency Formatter
    • Data Insecurity: A Perspective on Data Encryption
    • Securing SQL Server: Vulnerabilities You Might Not Have Considered
    • Productivity and Accountability
    • Objects Referenced and Referencing
    8th

    SQLServerCentral Newsletter

    • Help Guide the Future of SQL Compare
    • Brent Ozar's Six Scary SQL Surprises
    • Deleting large number of rows from a table in a VLDB
    • Using the SQL Server MERGE Statement to Process Type 2 Slowly Changing Dimensions
    • Writing
    • Identify Obsolete Indexes
    9th

    Database Weekly

      10th
      11th

      SQLServerCentral Newsletter

      • SQL Saturday #204 - Detroit
      • SQL Bits XI
      • Database Deployment: The Bits - Versioning
      • Dynamically Download FTP Files Using SSDT
      • Who Built This Thing?
      • Date Format
      12th

      SQLServerCentral Newsletter

      • SQL Saturday #188 - Lisbon
      • Data Mining Introduction Part 3: The Cluster Algorithm
      • SQL Server Central Webinar Series #22 – What counts for a DBA (Wednesday, March 13 2013 5:00pm - 6:00pm GMT)
      • SQL Server Statistics Questions We Were Too Shy to Ask
      • Self Describing Databases
      • SQL Server Performance Base Line Script
      13th

      SQLServerCentral Newsletter

      • An Orders of Magnitude Problem (T-SQL Tuning)
      • Help Guide the Future of SQL Compare
      • Getting Started with Extended Events in SQL Server 2012
      • Resetting DMVs
      • SQL Server Backup, Integrity Check, Index and Statistics Maintenance
      14th

      SQLServerCentral Newsletter

      • An Incremental Database Development and Deployment Framework
      • Search for a Value Throughout Your Database
      • Expand Your Skills at the PASS Business Analytics Conference
      • The Gambler
      • List all tables and their respective information.
      15th

      SQLServerCentral Newsletter

      • Testing the StreamInsight Service for Windows Azure
      • Designing a Dashboard - Level 6 in the Stairway to Reporting Services
      • Inconsistency
      • Convert XML to String with formatting
      16th

      Database Weekly

        17th
        18th

        SQLServerCentral Newsletter

        • SQLServerCentral at SQL Intersection
        • Stairway to PowerPivot and DAX - Level 4: The DAX BLANK() Function
        • Database Deployment Challenges
        • The Backup Process
        • Script to get max dates on tables that contain a certain column.
        19th

        SQLServerCentral Newsletter

        • Trigger an Email of an SSRS Report from an SSIS Package
        • Accounting for Windows Azure
        • Full Text Searches on Documents in FileTables
        • Serious Storage
        • Get List of tables with no identity columns
        20th

        SQLServerCentral Newsletter

        • The Power of the SQL Server Database Owner
        • Populating a Vertically Filtered Replicated Table
        • Expand Your Skills at the PASS Business Analytics Conference
        • Stop, Smell, Smile
        • Report Progress with Variables
        21st

        SQLServerCentral Newsletter

        • Using Optimizer_WhatIF and StatsStream to Simulate a Production Environment
        • Red Gate brings SQL in the City back to London for the third year running
        • SQLServerCentral Runs sp_Blitz - Performance Part 2
        • Query Tuning, Encryption, and more at SQL Intersection
        • Zettabytes and Beyond
        • DB File Overview
        22nd

        SQLServerCentral Newsletter

        • Use of Identity Property to Resolve Concurrency Issues
        • Creating Custom T-SQL Conditions and Policies for SQL Server Policy-Based Management
        • Toggle Switches
        • Powershell - Document your environment
        23rd

        Database Weekly

          24th
          25th

          SQLServerCentral Newsletter

          • Data Science Laboratory System - Instrumentation
          • Stairway to SQL PowerShell Level 5: SQL Server PowerShell Building Blocks
          • Car Data
          • Monitor current transactions and get all required information
          26th

          SQLServerCentral Newsletter

          • Red Gate brings SQL in the City back to London for the third year running
          • SQL Server's Auto Update Statistics Async Option
          • Data Mining SQLIO Results
          • A Good Security Response
          • Backups Snapshot
          27th

          SQLServerCentral Newsletter

          • Steve Jones and Grant Fritchey at SQL Intersection
          • Forum Etiquette: How to post data/code on a forum to get the best help
          • SQL Server 2012 Integration Services - PowerShell-Based Project Deployment
          • HASHBYTES: Is CHECKSUM really required?
          • What Do You Want to Know About I/O?
          • Backup history details EMAIL (past 24 hours) in HTML format
          28th

          SQLServerCentral Newsletter

          • How to Post Performance Problems
          • Re-throw Errors with Logging
          • Ad-Hoc XML File Querying
          • Halo 4 and Hadoop
          • Backup all SSAS databases using TSQL
          29th

          SQLServerCentral Newsletter

          • SQL Saturday #197 - Omaha
          • Adding Rows in Incremental Loads - Level 3 of the Stairway to Integration Services
          • Using the SQL Server APP_NAME function to control stored procedure execution
          • The Command Shell
          • Copy Sql Objects
          30th

          Database Weekly

            31st
            Previous month