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 2014

Find month: Show current month
SunMonTueWedThuFriSat
1st
2nd
3rd

SQLServerCentral Newsletter

  • Avoid using NOLOCK on SQL Server UPDATE and DELETE statements
  • The SQL TABLE Type: Beyond Table-Valued Parameters
  • SQL Saturday #269 - Exeter, UK
  • Downtime
  • Find Size of files used in Database
4th

SQLServerCentral Newsletter

  • Join Operations – Hash Match
  • SQLSaturday #269: SQL South West, Exeter, UK
  • Fixing Cache Bloat Problems With Guide Plans and Forced Parameterization
  • Is Rolling Back The Same as Failing?
  • The dynamic unpivoter.
5th

SQLServerCentral Newsletter

  • Stairway to T-SQL: Beyond The Basics Level 3: Building a Correlated Subquery
  • Junk Drawer
  • Free eBook: SQL Server Backup and Restore
  • Byte Me: Bugging Out
  • Template - Type 6 SCD Stored Procedure
6th

SQLServerCentral Newsletter

  • Vote Now: Final Service Packs for 2008/2008 R2
  • SQL Server 2012 AlwaysOn Groups and FCIs Part 2
  • Big Data: Integration with Little Data
  • One size does not fill all
  • Calendar Table by Interval Minutes
7th

SQLServerCentral Newsletter

  • SQL Saturday #275 - Copenhagen
  • Adding SQL Server AlwaysOn to existing Failover Clusters
  • Automate Sliding Window Partition Management: Part I
  • Mini-Me
  • Generate merge script for all primary key tables in a database
8th

Database Weekly

    9th
    10th

    SQLServerCentral Newsletter

    • Using the Statistical Program R for Running Statistics
    • Why I Developed SQL Code Guard: A Fairy Tale from a DBA
    • Continuous Delivery
    • Calendar Table by Month
    11th

    SQLServerCentral Newsletter

    • SQL Monitor Custom Metric: Performance-Related Database Settings
    • SQL Saturday #262 - Boston
    • Rapid SQL Server Database Deployment
    • SaaS and Multi-tenancy Models
    • Developers, developers, developers
    • Calendar Table by Year
    12th

    SQLServerCentral Newsletter

    • Worst Day as a DBA
    • Getting Started with Change Data Capture – Part 2
    • Multiple Flexible Source Locations – Level 17 of the Stairway to Integration Services
    • Free eBook: SQL Server Transaction Log Management
    • A True SQL OS
    • Calendar Table by Day
    13th

    SQLServerCentral Newsletter

    • Seven SQL Server Under-Used Utilities
    • SQL Saturday #287 - Madison, WI
    • SFTP, encrypt or compress data files in SSIS using custom components
    • #sqlhelp
    • Recreate Missing Log Files
    14th

    SQLServerCentral Newsletter

    • Automate Sliding Window Partition Maintenance: Part II
    • Speakers Needed - SQL Saturday #292 Detroit
    • Big Data Basics - Introduction to HDFS
    • Squeezing the DBA
    • Script to Get the Backup History
    15th

    Database Weekly

      16th
      17th

      SQLServerCentral Newsletter

      • Having fun with PARSENAME (SQL Spackle)
      • Windows Azure SQL Database - Uploading Data by Using the bcp Utility
      • How Many Passwords?
      • Script to Get the Database Restore history
      18th

      SQLServerCentral Newsletter

      • SQL Server Luxembourg: Natural Born Killers
      • Creating a Date Range from Multiple Rows Based on a Single Date
      • Paul Randal: Geek of the Week
      • The Worst Code
      • Script to Get the Database size in GB's
      19th

      SQLServerCentral Newsletter

      • Microsoft SQL Server 2014 released to manufacturing
      • Review Your BUCKET_COUNT Statistics with DMV
      • Stairway to T-SQL: Beyond The Basics Level 4: Using Views to Simplify Your Query
      • Free eBook: Performance Tuning with SQL Server Dynamic Management Views
      • Byte Me: Vendor Problems
      • Script to Check the Database Backup duration
      20th

      SQLServerCentral Newsletter

      • Grant EXEC on all Stored Procedures to a Role
      • The PoSh DBA – Specifying and Gathering Performance Counters
      • Privacy and Data
      • Script to Restore Entire database from a directory
      21st

      SQLServerCentral Newsletter

      • Automate Sliding Window Partition Maintenance: Part III
      • On Handling Dates in SQL
      • Bad Days
      • SQL Server Backup, Integrity Check, Index and Statistics Maintenance
      22nd

      Database Weekly

        23rd
        24th

        SQLServerCentral Newsletter

        • Worst Day as a DBA Story Finalists
        • Reaping the benefits of the Window functions in T-SQL
        • Automating the Retrieval of SQL Backups from Windows Azure BLOB Storage
        • Is Unit Testing Important?
        • Using Seqence Container instead of Identity
        25th

        SQLServerCentral Newsletter

        • Demonstrating the Effects of Using Data Compression in SQL Server
        • Using EXCEPT to Determine Row Differences
        • Inspiring Change
        • DBCC,Backup, Verify and create Agent Job to restore
        26th

        SQLServerCentral Newsletter

        • Private Cloud, What Is It and Why Do You Need It?
        • Stairway to XML: Level 1 - Introduction to XML
        • Free eBook: Defensive Database Programming
        • The Endless Upgrade Cycle
        • Partitioned Table View
        27th

        SQLServerCentral Newsletter

        • SQL Server Analysis Services ProcessAdd for a Partition
        • Transactional Replication and the Ballooning Log File
        • Getting Fired
        • Defragmentation and update statistics for all online databases
        28th

        SQLServerCentral Newsletter

        • AlwaysOn Availability Groups - What Not to do when Adding Databases
        • The SQL Server 2008 Datetimeoffset Data Type
        • The Perfect Environment
        • Alternative for Policy Management in SQL Server
        29th

        Database Weekly

          30th
          31st

          SQLServerCentral Newsletter

          • David McCandless Keynoting at PASS Business Analytics Conference 2014
          • Applying The Scientific Method to SQL Server Performance Tuning
          • Database Master Key Error After Database Restore
          • X in Technology
          • Transfer users from one base to another
          Previous month