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 2014

Find month: Show current month
SunMonTueWedThuFriSat
1st

SQLServerCentral Newsletter

  • SQL Server Optimizer – Under the Hood Part 1
  • Using Extended Properties To Keep Everyone Informed
  • Happy New Year 2014
  • Stored Procedures Performance
2nd

SQLServerCentral Newsletter

  • SQL Server 2014 In-Memory OLTP Architecture and Data Storage
  • Free eBook: 45 Database Performance Tips for Developers
  • Hidden Formatting Troubles with STR() (SQL Spackle)
  • Looking to 2014
  • SQL Server Documenter
3rd

SQLServerCentral Newsletter

  • How to receive Deadlock information automatically via email
  • Keeping Track of your SQL Servers with a DBA Configuration Repository
  • Breaking Down Barriers
  • Advanced Display Table and Column Info
4th

Database Weekly

    5th
    6th

    SQLServerCentral Newsletter

    • Exporting CLR Assemblies from SQL Server back to .dll files
    • A Simple Recursion Finds Joins
    • SQL Saturday #271 - Albuquerque, NM
    • Survey: About your SQL Server Database Releases
    • Budget for Training
    • View Active Session SQL
    7th

    SQLServerCentral Newsletter

    • An AlwaysOn Bug with Service Broker Transmission Queue
    • Data Science Laboratory System – Graph Databases
    • Who won the Tribal Awards?
    • DBAs Need to Learn to Develop
    • Generate MERGE statements with Table data
    8th

    SQLServerCentral Newsletter

    • SQL Server 2014 Hybrid Cloud Scenarios: Migrating On-Premises SQL Server to Windows Azure Virtual Machines
    • Free eBook: SQL Server Execution Plans, Second Edition
    • Relational database or graph database? Why not have both?
    • The Holiday Challenge
    • Total Space Used for all databases per disk
    9th

    SQLServerCentral Newsletter

    • An Introduction to Windows Azure Table Storage
    • Stairway to SQLCLR Level 1: What is SQLCLR?
    • Sabbatical
    • Dynamically create drop user statistics scripts
    10th

    SQLServerCentral Newsletter

    • Fuzzy-String Search: Find misspelled information with T-SQL
    • Stop & Start Your VM’s on Azure with Powershell
    • The Desktop Setup
    • To check the Backup Status for an SQL Instance
    11th

    Database Weekly

      12th
      13th

      SQLServerCentral Newsletter

      • Understanding Peer-to-Peer Transactional Replication, Part 1
      • Cleveland, OH - SQL in the City Seminar - Deployment Stairway
      • Agile Database Development
      • No Bosses
      • To check the full backup duration of an SQL Instance
      14th

      SQLServerCentral Newsletter

      • New SQL Monitor Custom Metric: Default User Service Account
      • SQL Enlight for SQL Server Management Studio
      • Generate two-dimensional QR Code® bar codes in an SSRS report
      • Double Checks
      • TEMPDB Configuration per vCPU
      15th

      SQLServerCentral Newsletter

      • Free eBook: Troubleshooting SQL Server: A Guide for the Accidental DBA
      • Stairway to T-SQL: Beyond The Basics Level 1: The TOP Clause
      • SQL Server 2014 Memory Optimization Advisor
      • We're not craftsmen and craftswomen
      • Determine when a Stored Procedure was created and last altered
      16th

      SQLServerCentral Newsletter

      • SQL Server 2014 Backup Basics
      • Calculating Duration Using DATETIME Start and End Dates (SQL Spackle)
      • Learn SQL Server in Arabic
      • Step Up, Don’t Step Back
      • Track database growth
      17th

      SQLServerCentral Newsletter

      • Fun with Outer Joins
      • How to Post Performance Problems
      • Creating a DBA's Library
      • Picking Your Packaging
      • List table space usage and row counts
      18th

      Database Weekly

        19th
        20th

        SQLServerCentral Newsletter

        • Logging and Error Handling for SQL Stored Procedures
        • The PoSh DBA - Reading and Filtering Errors
        • Better Writing
        • Truncate Table Partition command in SQL Server
        21st

        SQLServerCentral Newsletter

        • Migrating SQL Server Databases to Windows Azure by Leveraging BACPAC Files
        • Free Online Business Analytics Training for Those Who Love Data
        • Mastering Dimensions of Time
        • Uncontrolled Code
        • Get Database info
        22nd

        SQLServerCentral Newsletter

        • An Overview of Project Conversion - Level 14 of the Stairway to Integration Services
        • Calculating the Median Value within a Partitioned Set Using T-SQL
        • Free eBook: Performance Tuning with SQL Server Dynamic Management Views
        • Software in 2014
        • SQL SERVER 2008 Data Dictionary
        23rd

        SQLServerCentral Newsletter

        • Skipping Columns (& other tricks) Using BCP Format Files (SQL Spackle)
        • Search multiple SQL Server Error Logs at the same time
        • Too Much Choice
        • Modified SP_WHOM
        24th

        SQLServerCentral Newsletter

        • The SQL Server Sqliosim Utility
        • A Versioning system for SSRS
        • Common Checks
        • Script DB Level Permissions v2.1
        25th

        Database Weekly

          26th
          27th

          SQLServerCentral Newsletter

          • Managing SSIS Security with Database Roles
          • Leveraging Constraint Evaluation Sequence in SQL Server
          • SQL Saturday #241 Cleveland, OH
          • Management at Scale
          • Scripting SQL Agents Jobs using Powershell
          28th

          SQLServerCentral Newsletter

          • SQL Server Deadlocks by Example
          • Forum Etiquette: How to post Reporting Services problems
          • Servicing SQL Server in the Future
          • Table-Column Data Profiler
          29th

          SQLServerCentral Newsletter

          • Getting Starting with Change Data Capture (CDC) in SQL Server – Part 1
          • Stairway to T-SQL: Beyond The Basics Level 2: Writing Subqueries
          • Free eBook: Defensive Database Programming
          • The DBA is Dead
          • Total space used per table
          30th

          SQLServerCentral Newsletter

          • Backup to the right location, by default
          • Finding “Active” Rows for the Previous Month (SQL Spackle)
          • SQL Saturday #273 Tampa. FL
          • Software Patents
          • Get Databases with no backup
          31st

          SQLServerCentral Newsletter

          • Database Mirroring Setup
          • Reduce Time for SQL Server Index Rebuilds and Update Statistics
          • Adding to SQL Server
          • Calculate Table Size and row count
          Previous month