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

Newsletter Archive: January 2017

Find month:
SunMonTueWedThuFriSat
1st
2nd

SQLServerCentral Newsletter

  • Stairway to Biml Level 1: What is Biml?
  • Memory Limits in SQL Server 2016 SP1
  • Technology Guilt
  • SQL Server ErrorLog Archive Script
3rd

SQLServerCentral Newsletter

  • The 2016 Salary Survey Results
  • Triggers: Threat or Menace?
  • Identify Servers and the Databases Mounted in SharePoint
  • The Salary Range
  • View Autogrowth on a daily basis
4th

SQLServerCentral Newsletter

  • Stairway to Columnstore Indexes Level 11: Optimizing Queries For Batch Mode (Part 2)
  • Removing Email from msdb Database
  • Number Security
  • Query details about objects allocated in TEMPDB.
5th

SQLServerCentral Newsletter

  • Dynamic Data Masking Feature in SQL Server 2016
  • Questions About SQL Server Security and Access Control You Were Too Shy to Ask
  • What Do You Have Against a Little Hard Work?
6th

SQLServerCentral Newsletter

  • An Introduction to SQL Server Containers
  • SQL Server Ad Hoc Access to OLE DB Provider Has Been Denied Error
  • How to run SSIS Project as a SQL Job
  • Your 2017 Goals
  • Extracting string after and before a Character/Pattern
7th

Database Weekly

    8th
    9th

    SQLServerCentral Newsletter

    • Using R to Identify Key Features Quickly
    • Using SQLite with PowerShell and SQL Server
    • SQL Server 2014 Build List
    • Changes are Coming to the SQLServerCentral Forums
    10th

    SQLServerCentral Newsletter

    • Simpson's Paradox
    • SQL Server 2016 Enterprise Edition Performance Advantages
    • SQL Server is Getting More Popular
    • PoorDBA Tools - 1: DB Log Space used
    11th

    SQLServerCentral Newsletter

    • Free Webinar – Database DevOps Demo
    • Stairway to U-SQL Level 12: SQL.ARRAY and CROSS APPLY EXPLODE
    • SQL Server Database Provisioning
    • Not Excited by Linux
    • Powershell Script for regular DBA activities
    12th

    SQLServerCentral Newsletter

    • Identifying Last Night’s SQL Agent Job Failures
    • Backing Up SQL Server Databases is Easier in PowerShell than T-SQL
    • Backup Data Security
    • Backup databases in an Availability Group
    13th

    SQLServerCentral Newsletter

    • Configure SQL Server AlwaysOn Availability Group on a Multi-Subnet Cluster
    • Scrubbing Personally Identifiable Information
    • Securing Your Instances
    14th

    Database Weekly

      15th
      16th

      SQLServerCentral Newsletter

      • Using Power BI Desktop to Visualize SQL Server Metadata
      • Free Webinar – Database DevOps Demo
      • A Possible Alternative to SQL UNPIVOT
      • Writing the Correct Query is Important
      17th

      SQLServerCentral Newsletter

      • SQL Server in Azure Virtual Machines - Performance Optimizations
      • Using SQL Server and R Services for analyzing Sales data (Part 3)
      • Delaying Patches is Problematic
      18th

      SQLServerCentral Newsletter

      • Put your Database under Source Control
      • Five Useful SQL Server Management Practices
      • SQL Server v.Next : STRING_AGG() performance
      • Byte Me: Escalation Path
      19th

      SQLServerCentral Newsletter

      • Free Webinar: An Introduction to DevOps
      • Keeping Fact Tables Online while Loading via Partition Switching
      • What's New in Reporting Services 2016 Service Pack 1
      • The (Former) Complexity of PowerShell
      20th

      SQLServerCentral Newsletter

      • Development Delusions: That it is Enough to Build a Better Mousetrap
      • Data Mining Introduction
      • Legacy Limits
      21st

      Database Weekly

        22nd
        23rd

        SQLServerCentral Newsletter

        • Getting Started with R Services in SQL Server 2016 – Part 2
        • Need to run multiple scripts against multiple servers?
        • Join Two CSV Files with a Common Column
        • SQL Server 2012 Build List
        • The Purpose of a Database
        • Generic, parameterised, create DB script
        24th
        25th
        26th
        27th
        28th
        29th
        30th
        31st
        Previous month