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

Find month: Show current month
SunMonTueWedThuFriSat
1st

Database Weekly

    2nd
    3rd

    SQLServerCentral Newsletter

    • Some "Laws" of Software Development
    • SQL Saturday #202 - Edinburgh
    • SSRS Report Content Filtering by User Group
    • Relying on Algorithms
    • Truncate or switch range of a partitioned table
    4th

    SQLServerCentral Newsletter

    • Excel Function Returns Cell Address
    • High IO Wait on SQL Server Replication Distribution Database
    • The Joy of Technology
    • What got restored from where, by who and when
    5th

    SQLServerCentral Newsletter

    • Forum Etiquette: How to post data/code on a forum to get the best help
    • A Beginners Look at Hadoop
    • Paging Data with TSQL
    • Fear Fear
    • Search Anything Anywhere
    6th

    SQLServerCentral Newsletter

    • Continuous integration for databases using Red Gate tools
    • Adding new files to a log-shipped database (SQL Spackle)
    • Quickly Copy Data
    • Using Run As to Make Your Life Simple
    7th

    SQLServerCentral Newsletter

    • More Uses for Data Explorer for Excel
    • Incremental Data Loading Using CDC
    • New Custom Metric: Percentage of blocked connections
    • The Decision to Fail
    • Insert Commas Into Number String
    8th

    Database Weekly

      9th
      10th

      SQLServerCentral Newsletter

      • The Importance of Reading Comments
      • Help us improve SQL Source Control
      • Extend SQL Server DDL Triggers for more functionality: Part 2
      • No R2
      • What's changed recently?
      11th

      SQLServerCentral Newsletter

      • SQL Server 2012 Integration Services - Using PowerShell to Configure Project Environments
      • A Quick Tour of the Performance Dashboard Reports
      • The Watson Service
      • Finding queries to tune
      12th

      SQLServerCentral Newsletter

      • Migrating Databases Checklist Part1
      • Stairway to MDX - Level 10: “Relative” Member Functions: .CurrentMember, .PrevMember, and .NextMember
      • Data Vision
      • Space used by db files
      13th

      SQLServerCentral Newsletter

      • Batch ETL of Multiple Data Files Using an SSIS Foreach Loop Container
      • Moving Data From Excel to SQL Server - 10 Steps to Follow
      • The Five Year Plan
      • Generate N sequential numbers (fast)
      14th

      SQLServerCentral Newsletter

      • SQL Server Integration Services Package Restartability
      • Custom Sequence Numbering
      • Do You Want a Meritocracy at Work?
      • How Long Backups Will Take
      15th

      Database Weekly

        16th
        17th

        SQLServerCentral Newsletter

        • SQL Saturday #229 - Dublin
        • Getting Started with the SSAS Tabular Model
        • PowerShell vs GUI Availability Group Rebuild
        • Losing Data
        • Re-Trust Untrusted Foreign Keys and Constraints
        18th

        SQLServerCentral Newsletter

        • Attention users running SQL Server 2008 & 2008 R2!
        • Usage of CTE - Trick with Dates
        • Managing Slowly Changing Dimension with MERGE Statement in SQL Server
        • PASS Data Architecture Virtual Chapter presents Steve Simon
        • The Best Programmers
        • Restore Script Generator
        19th

        SQLServerCentral Newsletter

        • Check If a SQL Server Database Is In Pseudo-Simple Recovery Model Using Windows PowerShell
        • Review: Stellar Phoenix SQL Database Recovery
        • An Overview of SSIS Variables – Step 13 of the Stairway to Integration Services
        • SQL Server Should Work for Us
        • iSpy (on your development)
        20th

        SQLServerCentral Newsletter

        • Avoiding Parameter Sniffing in SQL Server
        • Email Formatted HTML Table with T-SQL
        • Lost in Space
        • SQL Server Dynamic XML Tag
        21st

        SQLServerCentral Newsletter

        • Understanding T-SQL Expression Short-Circuiting
        • Maximizing Throughput with TVPs
        • SQL Saturday #226 - South Florida
        • A Release from Data
        • Reindexing for fragmented indexes
        22nd

        Database Weekly

          23rd
          24th

          SQLServerCentral Newsletter

          • The Switch Workshop, by Red Gate and Re-Wired Group
          • SQL Server Reporting Services ReportItems Collection
          • Change Data Capture - SQL Server 2008
          • When Is Work, Work?
          • Locate a column across databases
          25th

          SQLServerCentral Newsletter

          • New SQL Monitor Custom Metric: Database Autogrowth
          • SQL Server Luxembourg User Group
          • Painless management of a logging table in SQL Server
          • Temporary Stored Procedures
          • More Data Security Issues
          • Trace Analysis script
          26th

          SQLServerCentral Newsletter

          • SQL Saturday #236 St Louis, MO
          • SQL Server Integration Services package to delete files from a Network or Local path based on date
          • Big Data for SQL folks: The Technologies (Part I)
          • Great Engineering Culture
          • Check SQL Error Logs using Powershell
          27th

          SQLServerCentral Newsletter

          • SQLServerCentral Runs sp_Blitz - Informational Items
          • Export to XML Using SSIS
          • Free eBook - Control Your Transaction Log so it Doesn't Control You
          • Better Technical Interviews
          • sp_spaceused rewritten as one query (no cursors)
          28th

          SQLServerCentral Newsletter

          • Automating SQL Server Database Deployments: Scripting Details
          • Display More Than 8000 Characters (SQL Spackle)
          • SQL in the City 2013
          • Capture current queries when cpu is above certain threshold
          29th

          Database Weekly

            30th
            Previous month