SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 

Newsletter Archive: October 2018

Find month:
SunMonTueWedThuFriSat
1st

SQLServerCentral Newsletter

  • Compress and Decompress in SQL Server 2016
  • Using undocumented DBCC WRITEPAGE to instigate SQL Server database corruption
  • Exhuming the GDPR Bodies
  • Give Up on Natural Primary Keys
  • Conditionally Order By Different Column
2nd

SQLServerCentral Newsletter

  • Redgate's Estate Management Research Survey
  • Who's Using the DAC?
  • Modern Data Warehouse Design Pattern – Part II
  • Are Indexes Actually Changes to the System?
  • Data Collections restart and clear cache files
3rd

SQLServerCentral Newsletter

  • Stairway to Columnstore Indexes Level 12: Clustered or Nonclustered?
  • Using undocumented DBCC WRITEPAGE to instigate SQL Server database corruption
  • Free eBook: Understanding SQL Server Concurrency
  • Cloud Backup
  • number of rows and columns of an instance
4th

SQLServerCentral Newsletter

  • Insert missing SQL Server IDENTITY column values using SET IDENTITY_INSERT command
  • Introducing SQL Server SSRS in Windows Containers
  • Using Azure Storage Explorer
  • Start the DevOps Journey
5th

SQLServerCentral Newsletter

  • Redgate's Estate Management Research Survey
  • 6 DBA Lessons I Wish Someone Would Have Taught Me Earlier
  • In-Memory OLTP Table Checkpoint Processes Performance Comparison
  • The Single Pane of Glass
  • How to Identify backup tables within production databases
6th

Database Weekly

    7th
    8th

    SQLServerCentral Newsletter

    • Power BI Introduction: Publishing Reports to the Power BI Service — Part 8
    • Generate documents from SQL Server
    • SQL Server Cursor Example
    • Remember the Simple Things
    9th

    SQLServerCentral Newsletter

    • How to Detect SQL Injection Attacks using Extended Events and SQL Monitor
    • Databases with MAXSIZE Set
    • SSIS Basics: Bulk-Import various text files into a table
    • Single Source of Truth
    10th

    SQLServerCentral Newsletter

    • Stairway to Biml 9 – Refactoring a Simple Custom Biml Framework
    • Get SQL Server Row Count and Space Used with the sp_rows
    • Free eBook: Performance Tuning with SQL Server Dynamic Management Views
    • Normal Data
    11th

    SQLServerCentral Newsletter

    • Fifty Different Ways to Enact Data Privacy Laws?
    • HTTP Requests Using SQLCLR
    • Collecting Data with Elastic Database Jobs in SQL Azure
    • Self-Healing ETL
    12th

    SQLServerCentral Newsletter

    • Redgate University has opened its doors online
    • Finding & Fixing Statistics Without Histograms
    • Trigger Happy
    • The Importance of Consistent Server Setup
    • View Server Roles and Permissions per Login
    13th

    Database Weekly

      14th
      15th

      SQLServerCentral Newsletter

      • A Primer on Defect Management
      • Being Careful with Schema Ownership
      • Modeling and Design Are More Important in DevOps
      16th

      SQLServerCentral Newsletter

      • Configuring a MySQL Database on Amazon RDS
      • Testing the Performance of Individual SQL Statements within a Batch using SQL Prompt
      • Using Redgate API to compare data in the same table
      • Selling Automation to Ops
      17th

      SQLServerCentral Newsletter

      • Using Azure Quickstart Templates
      • Installing the Database Server - Level 2 of the Stairway to SQL Server on Linux
      • Free eBook: Defensive Database Programming
      • Using Tools That Fit
      18th

      SQLServerCentral Newsletter

      • Join Kendra Little at SQL in the City to capture the value of DevOps
      • Creating Machine Learning Applications using Azure Cognitive Services
      • Auditing the password changes using LOGIN_CHANGE_PASSWORD_GROUP Server
      • Using your critical eye to see something positive
      19th

      SQLServerCentral Newsletter

      • The Real World: Implementing Data Compression in SQL Server 2008 R2
      • Your SQL Server is Bored: What Low Wait Times Mean
      • The 4 pillars of SQL Server Monitoring
      • Horrible Bosses
      20th

      Database Weekly

        21st
        22nd
        23rd
        24th
        25th
        26th
        27th
        28th
        29th
        30th
        31st
        Previous month