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

Find month: Show current month
SunMonTueWedThuFriSat
1st
2nd

SQLServerCentral Newsletter

  • SQLServerCentral Webinar Series #26: Best Practices in Database Deployment Part 2
  • Test Your SQL Server Backups with PowerShell
  • Common table expressions and circular references
  • SQL Saturday #251 Paris, France
  • Labor Day 2013
  • SQL Powershell Script to check Server's disk space Remotely
3rd

SQLServerCentral Newsletter

  • SQL Server Reporting Services Tips and Tricks to Improve the End User Experience
  • New SQL Monitor Custom Metric: Large Transaction Log Files
  • Variable Default Values to a Stored Procedure (SQL Spackle)
  • Sensor Data
  • Script out/store all indexes on a server
4th

SQLServerCentral Newsletter

  • Stairway to SQL PowerShell Level 1: SQL PowerShell Basics
  • Opportunity for Business Intelligence developer
  • New Enhanced Column Store Index in SQL Server 2014 – Part 1
  • It's not you; it's us
  • Add user with DDL Trigger
5th

SQLServerCentral Newsletter

  • Monitoring job history using Reporting Services
  • Getting Data between Excel and SQL Server using ODBC
  • Forum Etiquette: How to post data/code on a forum to get the best help
  • Good and Bad Interview Questions
  • Kill User Processes Per Database or Server Wide
6th

SQLServerCentral Newsletter

  • SQL Licensing - What Managers Need to Know
  • SQL Server Error Log Scanning
  • Techniques For Improving SQL Query Performance - Indexing, Parameterization and Partitioning
  • SQL Saturday #244 Johannesburg
  • Developer Pressure
  • SQL Powershell Script To Restore multiple databases at One Go
7th

Database Weekly

    8th
    9th

    SQLServerCentral Newsletter

    • A Hazard of Using the SQL Update Statement
    • SQL Saturday #250 Pittsburgh
    • Using DAX to create SSRS reports: The Basics
    • No More MCM
    10th

    SQLServerCentral Newsletter

    • A Variety of Tracks at DevConnections
    • Compare Big Data Platforms vs SQL Server
    • Loginless Database Users and Dynamic SQL
    • What does certification achieve?
    • Restore multiple db's to new server with new file locations
    11th

    SQLServerCentral Newsletter

    • Stairway to PowerPivot and DAX - Level 2: The DAX COUNTROWS() and FILTER() Functions
    • Manual cleanup Change Data Capture for a SQL Server database
    • SQL Saturday #249 San Diego
    • How to Recognize When a Relational Database is "Good Enough"
    • The Future of Knowledge Measurement
    • Find Foriegn Keys and their details in a database
    12th

    SQLServerCentral Newsletter

    • SQLskills and SQL Intersection
    • Soundex - Experiments with SQL CLR
    • SQL Saturday #213 Providence, RI
    • Condensing a Delimited List of Integers in SQL Server
    • Versions of Disaster
    • Analyzing Dangerous Settings in SQL Server
    • Analyzing Dangerous Settings in SQL Server
    13th

    SQLServerCentral Newsletter

    • Stairway to Server-side Tracing - Level 2: Creating a SQL Trace Using T-SQL (Stairway Series)
    • Improved Application Availability During Online Operations in SQL Server 2014
    • Risk and Assumptions
    • Prevent DISK FULL when database grows
    14th

    Database Weekly

      15th
      16th

      SQLServerCentral Newsletter

      • Automate SQL Server Log Monitoring
      • Backup to the Cloud: The Silver Lining
      • SQL Saturday #228 Cambridge, UK
      • If we can do it, so can you
      • List database restore COMPLETION datetime
      17th

      SQLServerCentral Newsletter

      • New SQL Monitor Custom Metric: Percentage of Free Log Space
      • SQL Server Analysis Services (SSAS) 2012 Top and Bottom Functions
      • Setting Different Colors for Connections in SSMS
      • Sensors and Data
      • Sales Report on a View
      18th

      SQLServerCentral Newsletter

      • Stairway to Database Design Level 3: Building Tables
      • Installing SQL Server 2014 CTP1
      • SQL Saturday #190 Denver
      • Job Worries over Automation
      • Primary Keys which are not Clustered Indexes in a database
      19th

      SQLServerCentral Newsletter

      • Blocking Chain (SQL Spackle)
      • Databases and Dominoes
      • TribalSQL: 15 New Voices in SQL Server
      • Opportunities Abound
      • usp_who5
      20th

      SQLServerCentral Newsletter

      • Automate Your Backup and Restore Tasks
      • SQL Server Reporting Services Report Manager Tips and Tricks
      • Can SQL Server do ‘Big’?
      • Display Databases with X days without backup
      21st
      22nd
      23rd

      SQLServerCentral Newsletter

      • SQL Server Cloud Migration Part I
      • The PoSh DBA – Getting to know PowerShell
      • Citizen Scientists
      • Get all the Child Tables up to N level
      24th

      SQLServerCentral Newsletter

      • Manage SQL Server Reporting Services in Management Studio
      • Five Rules For Successful Conversations With DBAs
      • The Human Cost of Managing Data
      • Universal foreach aka sp_uforeach
      25th

      SQLServerCentral Newsletter

      • SSIS 2012 - Introduction to Windows Azure SQL Databases
      • Stairway to SQL PowerShell Level 2: SQL PowerShell Setup and Config
      • It Happens
      • Determine if BACKUP COMPRESSION is available
      26th

      SQLServerCentral Newsletter

      • Calculating Elapsed Times (SQL Spackle)
      • Red Gate will be exhibiting at SQL Server Live! Orlando
      • A Practical Guide to Microsoft Hyper-V Replica: Part II
      • Scripting
      • Recursive CTE Example
      27th

      SQLServerCentral Newsletter

      • Generating Random Numbers in SQL Server Without Collisions
      • Extended Properties Introduction
      • An Interview with Allen Kinsel, PASS Board Candidate
      • Dating Your Employer
      • Find Top 5 expensive Queries from a Read IO perspective
      28th

      Database Weekly

        29th
        30th

        SQLServerCentral Newsletter

        • The Fundamentals of SQL Server Replication by Sebastian Meine
        • Developing for Delivery, a Practical Example
        • SQL in the City Pasadena 2013
        • Hybrid Databases
        • Restore Database with any number of Ndf files
        Previous month