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: April 2015

Find month:
SunMonTueWedThuFriSat
1st

SQLServerCentral Newsletter

  • Deploying the same database to many different RDBMSs
  • Get Your Service Broker Messages in Order. Always.
  • Free eBook: SQL Server Transaction Log Management
  • Byte Me: Shifting Gear
  • Check if SQL Server is running
2nd

SQLServerCentral Newsletter

  • A More Versatile SQL Server Random Number Function
  • Using APPLY to make your queries DRYer
  • Microservices for Databases
  • Check Existence of Server and find Instance Type
3rd

SQLServerCentral Newsletter

  • Azure Active Directory - Schema Extensions
  • Calculating Duration Using DATETIME Start and End Dates (SQL Spackle)
  • Large Chunks of Data
  • Delete SQL Instancename from default backup location
4th

Database Weekly

    5th
    6th

    SQLServerCentral Newsletter

    • A Hazard of Using the SQL Update Statement
    • Introduction to SQL Server Spatial Data
    • Your Cloud Held Hostage – Could It Happen?
    • Search a string in a text with number of occurrences
    7th

    SQLServerCentral Newsletter

    • Deleting Historical Data from a Large Highly Concurrent SQL Server Database Table
    • What is Database Continuous Integration?
    • Kanban
    • Fastest way to find DB object dependencies
    8th

    SQLServerCentral Newsletter

    • Painless Refactoring of SQL Server Database Objects
    • Stairway to SQL Server Security Level 7: Security Across Databases with Cross-Database Ownership Chaining
    • Free eBook: Performance Tuning with SQL Server Dynamic Management Views
    • Release Wednesday
    • Parse XML to table
    9th

    SQLServerCentral Newsletter

    • Creating a multi-option parameter report for SQL Server Reporting Services
    • Cardinality Estimator – What’s new in SQL Server 2014
    • State v Migrations
    • Generate password using PowerShell
    10th

    SQLServerCentral Newsletter

    • Five Rules For Successful Conversations With DBAs
    • The Internet of Things: A New World Order?
    • After Six Months On The Job What Challenges Remain?
    • Find Stored Procedures and Functions That Reference Certain Tables
    11th

    Database Weekly

      12th
      13th

      SQLServerCentral Newsletter

      • Never Ignore a Sort Warning in SQL Server
      • Maps in SQL Server Reporting Services
      • Pre-built or Ad Hoc
      • Automate Data Purity Investigation
      14th

      SQLServerCentral Newsletter

      • Prevent and Log Certain SQL Server Login Attempts
      • Using LAST_VALUE
      • SQL Monitor Custom Metric: Tables Without Clustered Indexes
      • The Opportunistic Hacker
      • Long Running Jobs Monitor
      15th

      SQLServerCentral Newsletter

      • SQL Server Spatial Indexes
      • Free eBook: Defensive Database Programming
      • Stairway to SQL Server Security Level 8: Data Encryption
      • Byte Me: Feeling The Squeeze
      • Show Database and Log sizes, free space and location
      16th

      SQLServerCentral Newsletter

      • Selecting Data Using the TOP Clause
      • Microsoft® SQL Server® 2014 Service Pack 1 (SP1) released
      • How to Categorize Uncategorized Data
      • QA for Data
      • Split String Function
      17th

      SQLServerCentral Newsletter

      • Webinar: Wait, what exactly are we shipping? Keeping control in database continuous delivery
      • How DBAs Can Adopt the Craftsman Mindset
      • The Elusive Conditional WHERE Clause
      • Monitoring After Deployment
      • READ Data from default Trace
      18th

      Database Weekly

        19th
        20th

        SQLServerCentral Newsletter

        • SSIS Design Pattern - Staging Delimited Flat Files
        • How to Get SQL Server Data Conversion Horribly Wrong
        • Embrace Stored Procedures
        • Use Of Cursor Vs Simple While Loop
        21st

        SQLServerCentral Newsletter

        • Automating Image-Based Deployment of SQL Server on Azure IaaS VMs - Preparing OS Image
        • Data Mining Part 26: Introduction to Cubes
        • Would a Duress Password be a Good Idea?
        • Check existence of a database
        22nd

        SQLServerCentral Newsletter

        • Stairway to SQL PowerShell Level 9: Objects For Everyone
        • Schema-Based Access Control for SQL Server Databases
        • Free eBook: SQL Server Execution Plans, Second Edition
        • Security Through Chaos
        • A script to answer: Should I use SPARSE?
        23rd

        SQLServerCentral Newsletter

        • Adding Slicers to a Reporting Services Report
        • Webinar: Wait, what exactly are we shipping? Keeping control in database continuous delivery
        • Continue a Foreach loop after an error in a SQL Server Integration Services package
        • Your Role Is Changing
        • Powershell command to extract SQL aliases configured
        24th

        SQLServerCentral Newsletter

        • Understanding Cross-Database Transactions in SQL Server
        • How to Recover a SQL Server Login Password
        • Code Reviews
        • Percentage of NULL Column Rows
        25th

        Database Weekly

          26th
          27th

          SQLServerCentral Newsletter

          • Data Mining Part 27: Microsoft Data Mining with Cubes
          • Learn Continuous Integration for Databases in Bellevue, WA
          • Time Testing SQL Azure Point In Time Database Restores
          • Microsoft Exercise
          • Extract default & Named Instance from @@servername
          28th
          29th
          30th
          Previous month