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

Newsletter Archive: May 2017

Find month:
SunMonTueWedThuFriSat
1st

SQLServerCentral Newsletter

  • What the heck is a DTU?
  • SQL Server Unit Testing in Visual Studio
  • Introducing a DevOps Workgroup to Farm Credit Services of America
  • More Open Data
  • Database Refresh Sync
2nd

SQLServerCentral Newsletter

  • OUTPUT Clause Basics (For Inserts and Deletes)
  • Azure Load Balancers and SQL Server
  • How to implement a T-SQL code formatting standard using SQL Prompt
  • The Secret Password
  • Quick and dirty script to ascertain datafile headroom
3rd

SQLServerCentral Newsletter

  • Free eBook: SQL Server Execution Plans, Second Edition
  • Stairway to DAX and Power BI - Level 7: Function / Iterator Function Pairs: The DAX AVERAGE() and AVERAGEX() Functions
  • Why is my clone so small?
  • Build Dynamic Backup Locations with Minion Backup
  • Byte Me: Entrepreneurial
  • Fix Orphan Users for All databases - Fixed Collation Problem
4th

SQLServerCentral Newsletter

  • SQL Server Join Example
  • Performance Tuning Using Extended Events: Part 3
  • How to Move a Table to a Different File Group
  • IoT Pros and Cons
5th

SQLServerCentral Newsletter

  • Azure Machine Learning - Your first experiment
  • Exploring Azure Storage for SQL Server DBAs – Part 2
  • Dude, where’s my database? Inventory management by Foundry
  • Thinking Time
6th

Database Weekly

    7th
    8th

    SQLServerCentral Newsletter

    • Basic data masking for development work using SQL Clone and SQL Data Generator
    • View R Plots from within SQL Server Management Studio
    • Deploying Multiple SSIS Projects via PowerShell
    • Three Days and a Notebook
    • Date Dimension Script
    9th

    SQLServerCentral Newsletter

    • Date and Time Conversions Using SQL Server
    • Best option for working with Files in SSIS
    • Balloons and Data
    • Find function dependencies
    10th

    SQLServerCentral Newsletter

    • Using an R Package within SQL Server with Real time analysis in Power BI
    • SQL Data Mask: now featuring configurable masks
    • Free eBook: SQL Server Internals: In-Memory OLTP
    • AlwaysON Availability Group and Jobs Part 1
    • So, you didn’t get the job; maybe it is YOUR fault.
    • Faster Backuphistory delete
    11th

    SQLServerCentral Newsletter

    • Performance Myths: Table variables are always in-memory
    • AlwaysON Availability Group and Jobs Part 2
    • What do you do when you have a repetitive task to do?
    12th

    SQLServerCentral Newsletter

    • Displaying Backup or Restore Progress
    • Backup and restore of a SQL Clone
    • How Long Before Your Database Runs Out of Space?
    • Less QA?
    13th

    Database Weekly

      14th
      15th

      SQLServerCentral Newsletter

      • Backing Up SQL Server Databases Hosted on Azure VMs
      • Azure DWH Part 8: Accessing Azure SQL Data Warehouse with C#
      • Why people flocked to the SQL Clone live stream event
      • The Human Impact of a Capable AI
      • Round Natural Numbers to the nearest Power of 10
      16th

      SQLServerCentral Newsletter

      • Fixing an SSRS Password Error while Changing Credentials
      • Encrypting SQL Server: Dynamic Data Masking
      • SQL Database Analysis
      • Index Usage Stats
      17th

      SQLServerCentral Newsletter

      • Do you use Visual Studio Code?
      • Free eBook: SQL Server Transaction Log Management
      • Cardinality Estimation for a Predicate on a COUNT Expression
      • The Road to Database CI
      • Array Element by Agonizing Array Element
      18th

      SQLServerCentral Newsletter

      • How Redgate helped define a truly automated database deployment process
      • Some of my greatest mistakes
      • Using the DbFit Framework for Data Warehouse Regression Testing
      • Data Privacy and Security: The Implications of GDPR
      19th

      SQLServerCentral Newsletter

      • Do you use Visual Studio Code?
      • Installing SQL Server Agent on Ubuntu Server
      • Forecasting with SQL
      • Registration Now Open for SQL Cruise Alaska in August 2017
      • Pseudonymisation
      20th

      Database Weekly

        21st
        22nd

        SQLServerCentral Newsletter

        • Step-by-step Installation of SQL Server 2016 on a Windows Server 2016 Failover Cluster - Part 4
        • Webinar: Extending DevOps practices to SQL Server databases
        • Azure DWH part 9: Azure PHP and ASDW
        • Listening and Taking Action
        23rd

        SQLServerCentral Newsletter

        • Azure Networking for SQL Server DBAs
        • Yet another SSIS XML Destination
        • How to document multiple SQL Server databases using SQL Doc and PowerShell
        • Naming Conventions for the Cloud
        24th

        SQLServerCentral Newsletter

        • Free eBook: Troubleshooting SQL Server: A Guide for the Accidental DBA
        • Stairway to Columnstore Indexes Level 12: Clustered or Nonclustered?
        • Masking your on-premise database with SQL Data Mask
        • Byte Me: Taking it to the top
        • Compute Holiday Day of the Month for any Year
        25th

        SQLServerCentral Newsletter

        • Getting Started with Azure SQL Data Warehouse - Part 4
        • Training: Zero to BIML
        • The OUTPUT Clause for INSERT & DELETE Statements
        • Audio Attacks
        • Transparent Database Encryption on all User Databases
        26th

        SQLServerCentral Newsletter

        • It’s not you, it’s me (I/O troubleshooting)
        • How to deploy a database plus static data using SQL Compare and SQL Data Compare
        • Datetime vs. Datetime2
        • Do I Need to Learn Linux and R and Python?
        27th

        Database Weekly

          28th
          29th
          30th
          31st
          Previous month