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

Newsletter Archive: March 2017

Find month:
SunMonTueWedThuFriSat
1st

SQLServerCentral Newsletter

  • DevOps and “Shift Left” for Databases
  • Stairway to U-SQL Level 13: SQL.MAP
  • Detecting Issues
  • Missing index with change impact percentage
2nd

SQLServerCentral Newsletter

  • Configure SSRS with an SSL Certificate
  • How to Programmatically Determine Which Edition of SQL Server is Installed
  • Why I am Excited about SQL Server on Linux
  • Getting resource name from blocked process report
3rd

SQLServerCentral Newsletter

  • SSIS Catalog Compare v2.0 Launch Event
  • Clone a SQL Server login and password to a new server
  • Usage of CTE - Trick with Dates
  • Null Defaults
  • Corrupt Page Notification
4th

Database Weekly

    5th
    6th

    SQLServerCentral Newsletter

    • Finding the Worst Performing TSQL Statement
    • Project Bletchley - The Microsoft Vision for Blockchain
    • Detective Stories - Tracking Down the Database's Dependents Part I
    • Containing the Work
    7th

    SQLServerCentral Newsletter

    • SSIS Catalog Compare v2.0 Launch Event
    • Detective Stories - Tracking Down the Database's Dependents Part 2
    • Query Store and In-Memory OLTP
    • Actionable Metrics
    • SQL Login Password Audit
    8th

    SQLServerCentral Newsletter

    • SQL Migrator (Part 1)
    • Move Azure SQL Databases using the Export and Import PowerShell cmdlets
    • TempDB Database On a Local Disk for an FCI
    • The Migration Checklist
    • Tally Generator
    9th

    SQLServerCentral Newsletter

    • SQL Migrator (Part 2)
    • Exploring Azure Storage for SQL Server DBAs
    • How to work with the command line in Azure SQL Data Warehouse
    • Redgate Data Tools in Visual Studio 2017 Enterprise
    • Database Cattle
    10th

    SQLServerCentral Newsletter

    • Understanding Graphical Execution Plans - Part 1: Explaining the Plan
    • TroubleShooting SQL Server Memory Consumption
    • Only as Good as Your Auditor
    11th

    Database Weekly

      12th
      13th

      SQLServerCentral Newsletter

      • Introducing DevOps to Farm Credit Services of America
      • 2016 Salary Survey in PowerBI
      • Change Your SQL Server Oil
      14th

      SQLServerCentral Newsletter

      • Adding Years, Months and Days
      • Managing Azure SQL Database Recovery
      • GUI or CLI
      15th

      SQLServerCentral Newsletter

      • Enable Trace Flags in SQL Server
      • Deployment Automation for SQL Server Integration Services (SSIS)
      • DevOps Isn't Perfect
      16th

      SQLServerCentral Newsletter

      • Installing SQL Server vNext on an AWS EC2 RHEL Instance
      • How to Find Queries Using an Index (and Queries Using Index Hints)
      • Ding - The World’s Largest Mobile Top-up Network Streamlines QA with SQL Server Containers
      • Informing the Internal IT Team
      • Find all published tables with row counts and table size
      17th

      SQLServerCentral Newsletter

      • Windowing Functions: Tell me when that changes
      • Extending DevOps practices to SQL Server databases
      • SQL Server Bulk Insert Row Terminator Issues
      • Using Trace Flags
      18th

      Database Weekly

        19th
        20th

        SQLServerCentral Newsletter

        • Using Power BI in a Hybrid Environment
        • Backups in Azure SQL Data Warehouse
        • Why DevOps? Employee Satisfaction
        • Connect to MongoDB on Remote Linux Server with Powershell
        21st

        SQLServerCentral Newsletter

        • Core Database Source Control Concepts
        • TODAY: extending DevOps practices to SQL Server databases
        • We are All Data Companies
        • Find UDF useage
        22nd

        SQLServerCentral Newsletter

        • Follow-up #1 on leading wildcard seeks
        • Continuous Delivery and the Development DBA
        • Webinar: how to get started with DevOps
        • Launching Products
        23rd

        SQLServerCentral Newsletter

        • Comparing Space Usage for Different Compression Types
        • Getting Started with Azure SQL Data Warehouse - Part 2
        • I Hate To Send This Email
        24th

        SQLServerCentral Newsletter

        • Encrypting SQL Server: Transparent Data Encryption (TDE)
        • The Mysterious Case of the Missing Default Value
        • Change Approvals
        • PatReplace8K
        25th

        Database Weekly

          26th
          27th

          SQLServerCentral Newsletter

          • Create reports in Azure SQL Data Warehouse using SSRSS
          • Using AT TIME ZONE to fix an old report
          • Is Big Data good for Data Professionals?
          • Stored Proc Archives rows to another table
          28th

          SQLServerCentral Newsletter

          • Performing a Right and Comprehensive Age Calculation
          • Performing a Right and Comprehensive Age Calculation
          • Who Changed My Database Schema?
          • Hacked
          • Building calendar table using MTVF
          29th
          30th
          31st
          Previous month