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

Newsletter Archive: May 2018

Find month: Show current month
SunMonTueWedThuFriSat
1st

SQLServerCentral Newsletter

  • Random Word Generation for Data Scrubbing
  • Introduction to Azure SQL Managed Instance
  • Auto-Deleting Data
  • Updated Brute Force Search Tool
2nd

SQLServerCentral Newsletter

  • Preventing Invalid Data Early In An ETL Flow
  • Installing Machine Learning Services – Level 1 of the Stairway to ML Services
  • Free eBook: SQL Server Transaction Log Management
  • Would You Move to Linux for Price?
  • Flexible Index reorganize and rebuild
3rd

SQLServerCentral Newsletter

  • The future of database DevOps
  • 150 SQL Code Smells
  • Scripting Objects with PowerShell
  • Reasons to Upgrade
4th

SQLServerCentral Newsletter

  • “But I don’t need to back up that database.”
  • Avoid use of the MONEY and SMALLMONEY datatypes
  • Navigating Hadoop Resources
  • Intrinsic or Extrinsic
5th

Database Weekly

    6th
    7th

    SQLServerCentral Newsletter

    • Friday the 13th
    • So what is data mapping and why is it the key to GDPR compliance?
    • Parking Garages And Predicates
    • Pride in Azure SQL Database
    8th

    SQLServerCentral Newsletter

    • Join the leading experts in data governance and SQL Server at Redgate’s SQL Privacy Summit
    • SQL Server From .Net: Connecting Visual Studio Community Edition
    • Provisioning SQL Server Instances with Docker
    • Reading Through the Logs
    9th

    SQLServerCentral Newsletter

    • Kafka Integration with HDInsight
    • SQL Server Dynamic Online Catalog: Why Should You Care? Stairway to Exploring Database Metadata Level 1
    • Free eBook: Troubleshooting SQL Server: A Guide for the Accidental DBA
    • Anonymisation Confusion
    10th

    SQLServerCentral Newsletter

    • One Million Tables
    • SQL Compare Snapshots: a lightweight database version control and rollback mechanism
    • Setting up SQL Server on Red Hat Linux in AWS - Part 1
    • Power BI Desktop on the Mac
    11th

    SQLServerCentral Newsletter

    • Create Azure VMs with PowerShell Part 1
    • Automatic Provisioning of Developer Databases with SQL Provision
    • Strange Filtered Index Problem
    • Interviewing Avatars
    12th

    Database Weekly

      13th
      14th

      SQLServerCentral Newsletter

      • Auto assign Column Data Types for Flat file Source Import
      • SQL Server Graph Databases – Part 4: Working with Hierarchical Data in a Graph Database
      • How do you deal with disappointment?
      15th

      SQLServerCentral Newsletter

      • Calculating Employee Attrition Rate with DAX – Part 1
      • Pseudonymizing your data with SQL Data Generator
      • Covering Indexes: Not Just for SELECT but also for UPDATE statements
      • Does the Tone matter?
      16th

      SQLServerCentral Newsletter

      • Free eBook: Understanding SQL Server Concurrency
      • Calculating Employee Attrition with DAX – Part 2
      • What is the Machine Learning Server? Level 2 of the Stairway to ML Services
      • The Value of Data
      17th

      SQLServerCentral Newsletter

      • Welcome to Redgate tools for SQL Operations Studio
      • Using SQL Server as a Source with for an Excel Application
      • Artificially Intelligent - Text Sentiment Analysis
      • How do you keep yourself from burning out?
      18th

      SQLServerCentral Newsletter

      • Harnessing SQL Server Metadata- Disabling and Rebuilding Indexes
      • Transaction Locking and Row Versioning Guide
      • Mercenary
      19th

      Database Weekly

        20th
        21st

        SQLServerCentral Newsletter

        • The State of SQL Server Monitoring 2018
        • Working with Windows Containers and Docker: Save the Data
        • SQL Server on Linux, does it have Microsoft's full attention?
        • A Great Case for Powershell
        22nd

        SQLServerCentral Newsletter

        • Why Are You Dropping and Recreating Your Indexes?
        • Scheduling a PowerShell Script Using SQL Server Agent
        • The 2018 State of DevOps Survey. Don’t just wait for it. Be a part of it.
        • Monitoring Distributed SQL Servers using SQL Monitor
        • Checking CHECKDB
        23rd

        SQLServerCentral Newsletter

        • Stairway to Columnstore Indexes Level 6: Updating and Deleting Data in a Columnstore Index
        • SQL Server Graph Databases – Part 5: Importing Relational Data into a Graph Database
        • Free eBook: Performance Tuning with SQL Server Dynamic Management Views
        • Pause and Backtrack
        24th

        SQLServerCentral Newsletter

        • How DevOps can automate the repayment of technical debt
        • Using FORMAT() for Dates
        • SQL in the City Streamed – Compliant DevOps: June 20 2018
        • Build and Automate a SQL Server Status Report on Server Restart or Scheduled
        • Lessons for all of us
        25th

        SQLServerCentral Newsletter

        • Where Clustered Index Keys Dare
        • Choosing Between Table Variables and Temporary Tables
        • SQL Server System Audit Report
        • The Oddest Thing
        26th

        Database Weekly

          27th
          28th

          SQLServerCentral Newsletter

          • Configuring R Services in SQL Server 2016
          • Finding code smells using SQL Prompt: TOP without ORDER BY in a SELECT statement
          • Create Azure VMs with PowerShell Part 2
          • Happy Memorial Day 2018
          29th

          SQLServerCentral Newsletter

          • Tables Without Clustered Indexes
          • TRY_CONVERT
          • No More Downtime
          30th

          SQLServerCentral Newsletter

          • Free eBook: Defensive Database Programming
          • PowerShell Day-to-Day Admin Tasks – Part 6: Real-Time IT Dashboard
          • Using SQL Server Dynamic Online Catalog to Solve Problems: Stairway to Exploring Database Metadata Level 2
          • Stairway to Server Management Objects (SMO) Level 1: Concepts and Basics
          • How Far Back?
          • SQL Server Long Query Script
          31st

          SQLServerCentral Newsletter

          • Solving the Target Principal Name is Incorrect
          • Automating a SQL Server Database Refresh
          • Using SQL Data Compare to Synchronize Custom Error Messages
          • An Unlikely Taste for Documentation and Archiving
          • Generate scripts for SQL Server Management Studio diagrams
          Previous month