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

Newsletter Archive: October 2017

Find month: Show current month
SunMonTueWedThuFriSat
1st
2nd

SQLServerCentral Newsletter

  • Should DBAs learn Linux?
  • Real-time moving averages for IoT with R
  • SQL Prompt Tip: how to control when the suggestion box pops up
  • Get-DbaPowerShell
3rd

SQLServerCentral Newsletter

  • Data in Motion and Data at Rest
  • So, what is GDPR and why should Database Administrators care?
  • Azure DWH part 17: ADF:Import Data from SQL Server on-premises to ASDW
  • No More Service Packs
4th

SQLServerCentral Newsletter

  • Understanding Azure Data Factory – A Cloud Based Integration Service
  • Stairway to U-SQL Level 18: Populating a Data Lake with PowerShell
  • Free eBook: SQL Server Transaction Log Management
  • Rewrite Your Code Tomorrow
5th

SQLServerCentral Newsletter

  • The Basics of Good T-SQL Coding Style – Part 4: Performance
  • Making Good Use of SQL Server Auditing
  • Database provisioning from backups using SQL Clone
  • Teaching Quickly
  • Rebuild or recompile all views
6th

SQLServerCentral Newsletter

  • The SQL Prompt Functionality Finder
  • SQL Server Integration Services SSIS 2016 Tutorial
  • 8 Ways to Export SQL Results To a Text File
  • Why Don't You Unit Test Code?
7th

Database Weekly

    8th
    9th

    SQLServerCentral Newsletter

    • Unearthing Bad Deployments with SQL Monitor and Redgate’s Database DevOps Tools
    • Azure DWH part 18: Working with SQL Server Analysis Services
    • Indexing for Windowing Functions: WHERE vs. OVER
    • Don't Use Code Coverage
    • SQL Server procedure to script tables
    10th

    SQLServerCentral Newsletter

    • WorkPlace Encounters: Grappling With ASYNC_NETWORK_IO Waits
    • Automated Database Provisioning for Development and Testing
    • How to examine differences with SQL Compare Summary View and SQL View
    • Citizen Scientists
    11th

    SQLServerCentral Newsletter

    • Webinar: how to cut time & disk space for database provisioning by 99%
    • Network Configuration of SQL Server Always On Availability Groups in Azure
    • Stairway to SQL Server Agent - Level 2: Job Steps and Subsystems
    • Free eBook: Troubleshooting SQL Server: A Guide for the Accidental DBA
    • Time is Precious
    12th

    SQLServerCentral Newsletter

    • Statistics in SQL: Student’s t-test
    • Group Managed Service Accounts (gMSAs) in SQL2016
    • The importance of bringing Python to SQL Server
    • The Blame Game
    13th

    SQLServerCentral Newsletter

    • A Freecon Halloween at the PASS Summit
    • How to import an existing database to ReadyRoll
    • A Lightweight, Self-adjusting, Baseline-less Data Monitor
    • A Double Dose of Trouble
    14th

    Database Weekly

      15th
      16th

      SQLServerCentral Newsletter

      • Webinar: how to cut time & disk space for database provisioning by 99%
      • Loading Data using R and PowerBI
      • The Power of Python and SQL Server 2017
      • The Cloud is Better In At Least One Way
      17th

      SQLServerCentral Newsletter

      • Introduction to Statistics
      • Key Lookups and ColumnStore Indexes
      • A Freecon Halloween at the PASS Summit
      • Don’t Underestimate the Importance of Good Co-workers
      18th

      SQLServerCentral Newsletter

      • SQL Server AlwaysOn Availability Groups Using an Azure Template
      • Free eBook: Understanding SQL Server Concurrency
      • Deeper into Nonclustered Indexes: Stairway to SQL Server Indexes Level 2
      • Software Patents
      19th

      SQLServerCentral Newsletter

      • Simple SQL: Random Thoughts
      • SQL Server Performance Benchmarking with Patterns
      • Discover database DevOps and more at PASS Summit
      • Top Talent Leaves
      20th

      SQLServerCentral Newsletter

      • Overview of Azure Data Lake
      • A Tale of Partition Schemes and Disappearing Dragons
      • The Remote Balance
      21st

      Database Weekly

        22nd
        23rd

        SQLServerCentral Newsletter

        • Azure DWH part 19: Backup and Restore SSAS
        • How Redgate use SQL Clone internally to provision databases
        • 9 New Features with SQL Server 2017
        • All DevOps All Day
        24th

        SQLServerCentral Newsletter

        • How to determine SQL Server database transaction log usage
        • A Freecon Halloween at the PASS Summit
        • Parameter Sniffing In Action
        • Gigging for a Career
        25th

        SQLServerCentral Newsletter

        • Improved parentheses formatting in SQL Prompt 8.1
        • SQL Server R Services: Working with ggplot2 Statistical Graphics
        • Stairway to Database Design Level 5: Procedures
        • Free eBook: Performance Tuning with SQL Server Dynamic Management Views
        • HA HA HA
        26th

        SQLServerCentral Newsletter

        • How to Hire a Junior DBA
        • SQL Monitor Quick Tip: Using the SQL static code analysis performance rules
        • Distributed Computing Principles and SQL-on-Hadoop Systems
        • Unstructured Data
        27th

        SQLServerCentral Newsletter

        • The SQL Server Features that Time Forgot
        • Extracting a DAX Query Plan With Analysis Services 2016 Extended Events
        • Adding Time Intelligence to a Power BI Data Model
        • Physical or Virtual Storage
        28th

        Database Weekly

          29th
          30th

          SQLServerCentral Newsletter

          • Templates and Snippets in SSMS and SQL Prompt
          • Backup SQL Server Databases in Parallel with PowerShell
          • Parse Data from a Field Containing Multiple Values using CROSS APPLY
          • How Far are You Willing To Go To Get Something?
          31st

          SQLServerCentral Newsletter

          • Six Scary SQL Surprises
          • Create SSRS Data Driven Subscriptions on Standard Edition
          • Halloween 2017
          Previous month