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: July 2014

Find month:
SunMonTueWedThuFriSat
1st

SQLServerCentral Newsletter

  • Finding SQL Server objects that reference invalid objects
  • Kill SPID (SQL Spackle)
  • Database Permissions
  • All the People Smarter than Me - Editorial
  • Query to find all sessions in each group
2nd

SQLServerCentral Newsletter

  • Free eBook: Fundamentals of SQL Server 2012 Replication
  • Database Branching and Merging Strategies
  • Stairway to Biml Level 5 - Biml Language Elements
  • The myth of the ‘shared development model’
  • Avoid Transaction Logs volume from filling
3rd

SQLServerCentral Newsletter

  • SQL Bits - Telford, UK
  • SQL Server Tables - 11 Questions You Were Too Shy to Ask
  • Dynamic Management Views: Changes in SQL Server 2012
  • Do Other Departments Know What You Do?
  • Replication Monitor Script
4th

SQLServerCentral Newsletter

  • SSRS In a Flash - Level 1 in the Stairway to Reporting Services
  • Granular or Cell Level Encryption in SQL Server
  • The "Numbers" or "Tally" Table: What it is and how it replaces a loop.
  • July 4, 2014
  • Check Backups
5th

Database Weekly

    6th
    7th

    SQLServerCentral Newsletter

    • Finding Unused SQL Server Stored Procedures With PowerShell
    • SQLServerCentral.com 2014 Users Survey
    • Creating Memory-Optimized Table in SQL Server 2014
    • Cloud Skills
    • SQL Server CPU Usage History Histogram
    8th

    SQLServerCentral Newsletter

    • Rollback and Recovery Troubleshooting; Challenges and Strategies
    • Dynamic Management Views: Changes in SQL Server 2014
    • Never give up
    • CPU Usage by Database
    9th

    SQLServerCentral Newsletter

    • Microsoft Azure Diagnostics Part 2: Basic Configuration of Azure Cloud Service Diagnostics
    • Stairway to T-SQL: Beyond The Basics Level 8: Coding Shortcuts using += and -= Operators
    • Free eBook: SQL Server Backup and Restore
    • Paying It Forward
    • Calculating Working Hours
    10th

    SQLServerCentral Newsletter

    • The Mindset of the Enterprise DBA: Creating and Applying Standards to Our Work
    • Agile 2014, Florida
    • Instant File Initialization
    • Is It Time To Clear Out Those Quirky Functions?
    • Find SQL Server Install Date
    11th

    SQLServerCentral Newsletter

    • Single Quotation Marks in SQL
    • Do You Really Need to Tune Big Data Applications?
    • Mudita: Joy in the success of others
    • Reindex Procedure with a Twist (or two) the SQL
    12th

    Database Weekly

      13th
      14th

      SQLServerCentral Newsletter

      • SQL Monitor Metric: Memory used by ad hoc queries running once
      • SQL Server Analysis Server (SSAS) KeyColumn vs NameColumn vs ValueColumn
      • Data Mining: Part 11 XMLA and the automation
      • Infect Your Colleagues with the Learning Bug
      • Physical Server or a Virtual Machine?
      15th

      SQLServerCentral Newsletter

      • Version Control as a Cloud Service
      • Implementation of partition switching within SSIS
      • Not Good Enough For Government Work
      • Email the Auto-growth events that have occurred in the last 24 hours t
      16th

      SQLServerCentral Newsletter

      • Free eBook: SQL Server Transaction Log Management
      • Automate Registering and Maintaining Servers in SQL Server Management Studio (SSMS)
      • Stairway to SQL Server Security Level 3: Principals and Securables
      • SQL Saturday #302 - Albany
      • One Size Does Not Fit All
      • Create MERGE statements with data!
      17th

      SQLServerCentral Newsletter

      • Developing a Custom SSIS Source Component
      • Convert Rows into Columns
      • Access Disdain
      • Fix orphaned users after restoring database to another server
      18th
      19th

      Database Weekly

        20th
        21st

        SQLServerCentral Newsletter

        • 13 Questions about SQL Server Data Types You were Too Shy to Ask
        • Data Mining: Part 12 DMX for Data Mining
        • SQL in the City: Save the Date
        • Back from Sabbatical
        • Object dependencies in xml format
        22nd

        SQLServerCentral Newsletter

        • SQL-only ETL using a bulk insert into a temporary table (SQL Spackle)
        • Is Source Control Really That Boring?
        • Traits of a DBA - Part Two – The Personal Side of a DBA
        • DevOps
        • Column Exists or not?
        23rd

        SQLServerCentral Newsletter

        • Free eBook: Performance Tuning with SQL Server Dynamic Management Views
        • Calculating and Verifying Check Digits in T-SQL
        • Stairway to T-SQL: Beyond The Basics Level 9: Dynamic T-SQL Code
        • Byte Me: Deep Insight
        • CTE DML
        24th

        SQLServerCentral Newsletter

        • SQL in the City Workshop - Continuous Integration Stairway
        • Restoring the SQL Server Master Database Even Without a Backup
        • Columnstore Index Changes in SQL Server 2014
        • Data Decisions or Instinct?
        • Move End of Month file from source to destination
        25th

        SQLServerCentral Newsletter

        • Exploring Recursive CTEs by Example
        • SQL Monitor Custom Metric: WriteLog Wait Time
        • Why Put Your Database into Source Control?
        • Summer, Summer, Summertime
        • Yet another way to defrag indexes
        26th

        Database Weekly

          27th
          28th

          SQLServerCentral Newsletter

          • Microsoft Azure Cloud Services Part 2: Anatomy of a Cloud Service
          • How to Handle Calculations Related to fiscal year and quarter
          • Frustration with Bad Design
          • Find server in complex CMS hierarchy
          29th

          SQLServerCentral Newsletter

          • Avoiding Database Deployment Disasters – 7 Tips
          • New SQL Server 2014 Permissions: CONNECT ANY DATABASE
          • One a Week
          • Drop Any Object if it exists
          30th
          31st
          Previous month