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

Find month: Show current month
SunMonTueWedThuFriSat
1st

SQLServerCentral Newsletter

  • Schema-Owned Tables and Generated DROP Scripts (SQL Spackle)
  • Intervals and Counts - Part 1
  • Disaster Recovery Tip #8: Maintain up-to-date contact information
  • The Human Touch
  • Automate Data Purity Investigation
2nd

SQLServerCentral Newsletter

  • New SQL Monitor Custom Metric: Failed SQL Server logins
  • Sorting Months By Number (SQL Spackle)
  • The Big Data DBA
  • SQL Saturday #235 New York City, NY
  • The School Year
  • Find Stored Procedures and Functions That Reference Certain Tables
3rd

Database Weekly

    4th
    5th

    SQLServerCentral Newsletter

    • Growing Your SQL Server Skills without Breaking the Bank
    • Changing SQLServerCentral - Initial Thoughts
    • Using Microsoft Excel to Retrieve SSAS Tabular Data
    • Winning
    • Parse XML to table
    6th

    SQLServerCentral Newsletter

    • Data Mining Introduction Part 6: Time series algorithm
    • SQL Saturday #240 Curacao
    • Changing SQLServerCentral - Newsletter Layout
    • An Introduction to Windows Azure BLOB Storage
    • Separation of Duty
    • Delete All Database User Accounts for a Given Server Login
    7th

    SQLServerCentral Newsletter

    • Free eBook: Troubleshooting SQL Server: A Guide for the Accidental DBA
    • Building an Incremental Load Package – Level 3
    • Concatenation of Different SQL Server Data Types
    • Biml Workshop presented by Varigence and Linchpin People
    • The Standard Limitation
    • Display the number of days since last Database backup.
    8th

    SQLServerCentral Newsletter

    • Introduction to SQL Server Check Constraints
    • SQLServerCentral.com Users Survey 2013
    • SQL Saturday #233 Oklahoma City
    • 10 Myths about Backups in SQL Server
    • Balloons and Data
    • Simplest way to search any string in db objects
    9th

    SQLServerCentral Newsletter

    • Survey: Help Improve SQL Doc
    • Automated Trigger To Require a WHERE Clause
    • SSIS 2012 - Using PowerShell to Remotely Execute File System Packages
    • Would You Choose SQL Server?
    • Dynamically Drop a User From Your SQL Instance
    10th

    Database Weekly

      11th
      12th

      SQLServerCentral Newsletter

      • How efficient is your covered index?
      • The Basics of Good Negotiations Webinar
      • Understanding the importance of key length with the SQL Server asymmetric encryption algorithms
      • Review Your Code
      • usp_tableReference
      13th

      SQLServerCentral Newsletter

      • How to Compile, Deploy and Consume a SQL Server CLR Assembly
      • The SQL of Gaps and Islands in Sequences
      • SQL in the City Seminar San Diego 2013 – DBA Team Seminar
      • Patch Problems
      • Execute T-SQL Scripts in Parallel
      14th

      SQLServerCentral Newsletter

      • What’s New with SQL Server 2014
      • Free eBook: SQL Server Transaction Log Management
      • Using Biml as an SSIS Design Patterns Engine – Level 4
      • Lossy data and incorrect data
      • Fastest way to split delimited string in SQL Server
      15th

      SQLServerCentral Newsletter

      • SSIS Deployments with SQL Server 2012
      • SQLServerCentral.com Users Survey 2013 - Last week
      • Move an On Premise SQL Server Database to the SQL Azure Cloud
      • Who Wants to Be Rich?
      • SQL Server System Report
      16th

      SQLServerCentral Newsletter

      • Data Science Laboratory System - Key/Value Pair Systems
      • Creating A SQL Server 2008\2008 R2 Failover Cluster
      • Should He Stay or Should He Go?
      • Generate Create View statements for database tables.
      17th

      Database Weekly

        18th
        19th

        SQLServerCentral Newsletter

        • SQL Server Central Webinar Series #25 - Best Practices in Database Deployment Part 1: Aug 27th @ 4PM BST
        • Implementing, loading and optimizing a Type 2 Slowly Changing Fact Table
        • SQL Server 2012 Analysis Services Partitioning Performance Demonstration
        • Opinions and Votes
        • Monitor your website or any URL from SQL Server
        20th

        SQLServerCentral Newsletter

        • New SQL Monitor Custom Metric: Untrusted Foreign Keys
        • Upgrading the GIS application and database.
        • Columnstore Indexes in SQL Server 2012
        • SQL in the City Seminar Denver 2013 – SQL Development Seminar
        • Guidance
        • Fastest way to find DB object dependencies
        21st

        SQLServerCentral Newsletter

        • News From EAP Testing
        • Stairway to Database Design Level 2: Domains, Constraints and Defaults
        • Free eBook: Performance Tuning with SQL Server Dynamic Management Views
        • Always Abstract
        • Show database size info across an instance
        22nd

        SQLServerCentral Newsletter

        • Getting started with Power View Reports with SharePoint, Excel and SQL Server
        • SQL Saturday #246 Salt Lake City
        • Generating Dummy Data
        • The Costs of Data
        • Display the SELECT statement for any table
        23rd

        SQLServerCentral Newsletter

        • SQL Server Central Webinar Series #25 - Best Practices in Database Deployment Part 1: Aug 27th @ 4PM BST
        • Teach Business Users How To Create Power View Reports With SQL Server Data Sources
        • Displaying Sorted Hierarchies (SQL Spackle)
        • Cool Projects
        • Create a Comma Delimited CSV File from Any Table/View with Debugging
        24th

        Database Weekly

          25th
          26th

          SQLServerCentral Newsletter

          • Minimal Logging
          • SQL Server Central Webinar Series #25 - Best Practices in Database Deployment Part 1: Aug 27th @ 4PM BST
          • Eight Steps to Effective SQL Server Monitoring
          • 10 Things I Hate About Interviewing With You Webinar
          • Physical Security
          • Enable Filestream on Instance and database
          27th

          SQLServerCentral Newsletter

          • Bulk Move/Rename of SSRS Reports through Web Services
          • SSIS 2012 - Using PowerShell to Remotely Execute File System Packages in Multi-Server Scenarios
          • SQL in the City Pasadena 2013
          • Lost in the Noise
          • SQL Server Backup, Integrity Check, Index and Statistics Maintenance
          28th

          SQLServerCentral Newsletter

          • SQL in the City Atlanta 2013
          • Free eBook: Defensive Database Programming
          • Stairway to PowerPivot and DAX - Level 1: Getting Started with PowerPivot and DAX
          • How to hide SQL Server user databases in SQL Server Management Studio
          • Stunned
          • SQL Powershell Script to check Server Uptime Remotely
          29th

          SQLServerCentral Newsletter

          • Database Administration as a Service
          • SQL in the City Charlotte 2013
          • SQL Server Stored Procedures and SET options
          • The Value of Your Time
          • Open transactions on a database
          30th

          SQLServerCentral Newsletter

          • Drive Space Monitoring Gets An Update
          • The Database Administrator's Back-to-School Checklist
          • Great IT Shops
          • Find the most executed stored procedure(s)
          31st

          Database Weekly

            Previous month