Click here to monitor SSC
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 

Newsletter Archive: February 2016

Find month:
SunMonTueWedThuFriSat
1st

SQLServerCentral Newsletter

  • The PoSh DBA - Towards the Re-usable PowerShell Script
  • Find and Remove Duplicate Records SQL Server
  • What is the True Version of Code?
  • Design : Find and script out Missing Foreign Keys
2nd

SQLServerCentral Newsletter

  • Data security, SQL Server 2016, and Your Business
  • SQL Server System Audit Report
  • Maybe Security is Harder than Rocket Science
  • Instance wide script to add user (the 4th way)
3rd

SQLServerCentral Newsletter

  • Stairway to Database Source Control Level 4: Getting a Database into Source Control (Distributed Repository)
  • Simplify SQL Server ETL Processes with T-SQL Stored Procedures
  • Queues in Databases
  • Design : Find table with Identities with missing unique constraints
4th

SQLServerCentral Newsletter

  • SQL Azure Performance Benchmarking
  • Monitoring In-Memory OLTP: What's Important?
  • The New Operating System
  • Index stats with key,included columns, size - all you can eat
5th

SQLServerCentral Newsletter

  • How to read data from multiple Excel worksheets with SQL Server Integration Services
  • Microsoft Survey on Backup and Security
  • Centrally collect replication conflicts and send an alert
  • Who's Got a Preteen SQL Server?
  • Check Backups
6th

Database Weekly

    7th
    8th

    SQLServerCentral Newsletter

    • tSQLt and the INSERT EXEC Problem
    • Exploration of SQL Server 2016 Always Encrypted – Part 3
    • Culture and Performance
    • Script to document SQL Instance Details
    9th

    SQLServerCentral Newsletter

    • The SQL Server 2016 Query Store: Accessing Query Store Information Using DMVs
    • Thinking About the Cloud?
    • Enabling TDE on Databases in an AlwaysOn Scenario
    • The Digital Woes of Public Records
    • What's running now
    10th

    SQLServerCentral Newsletter

    • Foreign Key Indexes and Binding
    • Cloud Adoption Survey
    • Free eBook: Fundamentals of SQL Server 2012 Replication
    • Byte Me: Literal Thinking
    • Split String Function
    11th

    SQLServerCentral Newsletter

    • Redgate Cloud Research
    • SSIS: Case sensitivity may expose issues with change deployment
    • SQL Server 2016 Row Level Security Block and Filter Predicates Example
    • Reasonable Timeframes
    • Transfer/copy data between servers using Remote Connection
    12th

    SQLServerCentral Newsletter

    • Moved to the Cloud?
    • SQL Server System Views: The Basics
    • Improving Performance for Some LIKE “%string%” Searches (SQL Spackle)
    • The Push to Upgrade from SQL Server 2005
    • Monday whatever the circumstances
    13th

    Database Weekly

      14th
      15th
      16th
      17th
      18th
      19th
      20th
      21st
      22nd
      23rd
      24th
      25th
      26th
      27th
      28th
      29th
      Previous month