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 2014

Find month: Show current month
SunMonTueWedThuFriSat
1st
2nd

SQLServerCentral Newsletter

  • Cursor-Killing: Retrieving Recently Modified Data
  • PowerShell One-Liners: Collections, Hashtables, Arrays and Strings
  • IT and the Older Generation
  • Capture User Auths For Database
3rd

SQLServerCentral Newsletter

  • Semi-blocking Transformations in SQL Server Integration Services SSIS
  • Extracting data with headers using PowerShell
  • Developing with SQL Server – What must a beginner know?
  • Query to Find Top CPU Queries
4th

SQLServerCentral Newsletter

  • T-SQL User-Defined Functions: Ten Questions You Were Too Shy To Ask
  • SQLSaturday # 286 - Louisville, KY
  • Stairway to SQL Server Security Level 1: Overview of SQL Server Security
  • DBA is too large a concept
  • Start a job at a defined step on another sql instance
5th

SQLServerCentral Newsletter

  • SQL Server Hardware Configuration Best Practices
  • The DBA Team tackles data corruption
  • Who Truncated That Table and What Do I Do Now?
  • Wandering Towards The Lonely Cloud?
  • do we have local memory pressure
6th

SQLServerCentral Newsletter

  • Find Customers Who Bought "A" and "B" But Not "C" (SQL Spackle)
  • SQL Saturday #303 - Rochester, NY
  • On Adopting the Mindset of an Enterprise DBA
  • Motivating the Team
  • Caching and paging a SQL Result Set
7th

Database Weekly

    8th
    9th

    SQLServerCentral Newsletter

    • Quick Guide to Installing SQL Server 2014
    • Getting the Most out of Statistics
    • Space Hoarders
    • Paginating a SQL query result set
    10th

    SQLServerCentral Newsletter

    • SQL Monitor Custom Metric: Ad Hoc Queries Running Once
    • On Comparing Tables in SQL Server
    • Display All Errors Fired in a Restore Procedure
    • Try to focus on the positive
    • Find Buffer Pool usage by database
    11th

    SQLServerCentral Newsletter

    • Stairway to Database Source Control Level 2: Getting a Database into Source Control
    • Free eBook: Understanding SQL Server Concurrency
    • Traits of a DBA - Part One – The Technical Side
    • Byte Me: Tablet Computing
    • Capture_Login_Auths
    12th

    SQLServerCentral Newsletter

    • Logging in Maintenance Plans
    • Survey: Which new database platforms are you adopting?
    • Database Delivery Patterns and Practices
    • Developers vs. DBAs
    • Find Top 10 consumers of memory from Buffer Pool
    13th

    SQLServerCentral Newsletter

    • Setting Up Your SQL Server Agent Correctly
    • SQL Server Performance Tuning with Hypothetical Indexes
    • MDX Guide for SQL Folks: Part I - Navigating The Cube
    • Habits and Familiarity
    14th
    15th

    Database Weekly

      16th

      SQLServerCentral Newsletter

      • The SQL of The Game of Life
      • SQL Server 2014 Launch Party in Ontario
      • Finding and Eliminating Duplicate or Overlapping Indexes
      • Kitchen Duty
      • Dynamic pivoting
      17th

      SQLServerCentral Newsletter

      • How Safe is Cloud Storage?
      • SQL Saturday #293 Maine
      • Server Role Membership Validation
      • The Last Line of Defense
      • server_config_script_2005_2008_2008R2
      18th

      SQLServerCentral Newsletter

      • Free eBook: SQL Server Hardware
      • Stairway to SQL Server Security Level 2: Authentication
      • Automated testing in Microsoft Azure
      • Cloud Storage Security: Are You Doing Your Part?
      • All Index Size
      19th

      SQLServerCentral Newsletter

      • Data Mining Introduction Part 9: Microsoft Linear Regression
      • PowerShell One-Liners: Accessing, Handling and Writing Data
      • Go to a User Group
      • Query current runtime data for the resource pools and workload groups
      20th

      SQLServerCentral Newsletter

      • Unwelcome posts on our forums
      • My month with Release!
      • Using DBCC DROPCLEANBUFFERS When Testing Performance
      • Support The Boss
      • Object Search
      21st

      Database Weekly

        22nd
        23rd

        SQLServerCentral Newsletter

        • Introduction to SQL Server in Microsoft Azure
        • Apology for today's article
        • Bad Meetings or Meeting Badly
        • Productivity Keyboard Shortcuts
        24th

        SQLServerCentral Newsletter

        • How to Make Scalar UDFs Run Faster (SQL Spackle)
        • Data Mining Introduction Part 10: Microsoft Logistic Regression
        • Differences In Native Compiled Procedures Execution Plans
        • Never Stop Learning
        • Enable and configure DB mail using T-SQL
        25th

        SQLServerCentral Newsletter

        • Free eBook: Troubleshooting SQL Server: A Guide for the Accidental DBA
        • Stairway to T-SQL: Beyond The Basics Level 7: Controlling the Flow of Your T-SQL
        • What you need for a Multi Subnet Configuration for AlwaysOn in SQL Server 2012
        • Byte Me: Insubordinate Clause
        • Find Transactional Replication Source from Destination Table
        26th

        SQLServerCentral Newsletter

        • Continuous Delivery and the Database
        • Unique Indexes Are Code; Non-Unique Indexes Are Data
        • Less and Less Visual
        • Script to Detach All User Databases
        27th

        SQLServerCentral Newsletter

        • The SSIS Data Pump - Level 2 of the Stairway to Integration Services
        • Running SQL Server Databases in the Amazon Cloud (Part 1)
        • Lockdown or Let Them Free
        • Find Transactional Replication Publisher
        28th

        Database Weekly

          29th
          30th

          SQLServerCentral Newsletter

          • Why Primary Keys can be important on large tables
          • Experiments with NEO4J: Using a graph database as a SQL Server metadata hub
          • Developer Week - Nuremberg, Germany
          • The Product Centric Career
          • Script out all alerts
          Previous month