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

Newsletter Archive: June 2018

Find month: Show current month
SunMonTueWedThuFriSat
1st

SQLServerCentral Newsletter

  • The 2018 State of DevOps Survey. Don’t just wait for it. Be a part of it.
  • Quick Tips For Debugging Large Stored Procedures
  • NonClustered Index Structure
  • Do We Understand Data?
2nd

Database Weekly

    3rd
    4th

    SQLServerCentral Newsletter

    • Scalar Functions with Query Plans: Not all is obvious!
    • Building reusable table build scripts using SQL Prompt
    • Importing JSON Collections into SQL Server
    • Will Coding Be Less Important?
    • SQL Server Backup, Integrity Check, Index and Statistics Maintenance
    5th

    SQLServerCentral Newsletter

    • Logshipping to SQL Server on Linux
    • Introduction to Azure Cosmos DB Security
    • The Journey to DevOps
    • SQL Server All View Refresh
    6th

    SQLServerCentral Newsletter

    • Power BI – Part 1: Introduction
    • Stairway to ColumnStore Indexes Level 7: Optimizing Nonclustered Columnstore Indexes
    • Free eBook: SQL Server Backup and Restore
    • SQL Server Tuning Skills
    • Export diagrams
    7th

    SQLServerCentral Newsletter

    • Docker SQL Server 2017 Linux Containers with database cloning
    • Script triggers from any database in SQL Server
    • Get What You Pay For?
    • SQL Server All Indexes Script
    8th

    SQLServerCentral Newsletter

    • How to Create Deadlocks and Troubleshoot Them
    • I thought my database was collation agnostic
    • Better Comments
    • Database-based Transaction Counting Find Script
    9th

    Database Weekly

      10th
      11th

      SQLServerCentral Newsletter

      • Improving SQL Server 2016 Large Database Performance
      • SQL Prompt Safety Net Features for Developers
      • Converting a Database to In-Memory OLTP
      • Be Prepared with Baselines
      • Statistics not updated for the last 30 days
      12th

      SQLServerCentral Newsletter

      • Dynamic File Column mapping in SSIS.
      • Indexes That Have Not Been Used but Are Being Updated
      • Using Power BI in a Hybrid Environment
      • Machine Learning in the Database
      • SQL Server WaitStats Script
      13th

      SQLServerCentral Newsletter

      • Data Governance, DevOps, and Delivery
      • Getting Started with Level 1 of the Stairway to Azure SQL Database
      • Free eBook: Inside the SQL Server Query Optimizer
      • The Data Submarine
      • Generate a script for FullText Catalogs and Indexes
      14th

      SQLServerCentral Newsletter

      • Using Regular Expressions With T-SQL: From Beginner To Advanced
      • SQL Server From .Net: Reading SQL Server Metadata in ADO.Net
      • Why you should automate your release pipeline
      • Building Test Data
      • Entering random data into a table
      15th

      SQLServerCentral Newsletter

      • How to Tell If Your SQL Server Has Too Much Memory
      • Finding code smells using SQL Prompt: Asterisk in SELECT list
      • Splitting Strings in SQL Server 2016
      • More Query Tuning?
      • Index Utilization Summary Report Script
      16th

      Database Weekly

        17th
        18th

        SQLServerCentral Newsletter

        • Jobs You Wouldn't Expect To Be Threatened By Tech But Are
        • Hyper-V and PowerShell: Shielded Virtual Machines
        • Idle Connection Resiliency
        • State v Migrations
        19th

        SQLServerCentral Newsletter

        • SQL Server Database Corruption Detection
        • Reducing risk with Smart Recommendations in SQL Census
        • Databases with MAXSIZE Set
        • After Six Months On The Job What Challenges Remain?
        20th

        SQLServerCentral Newsletter

        • Stairway to ColumnStore Indexes Level 8: Optimizing Clustered Columnstore Indexes
        • Welcome to the new world of curating data, not owning it
        • Free eBook: Fundamentals of SQL Server 2012 Replication
        • Release Wednesday
        21st

        SQLServerCentral Newsletter

        • Converting Trace to Extended Events
        • In-Memory OLTP – SQL Server In-Memory OLTP Internals Overview
        • SQL Prompt Hidden Gems: The SSMS Results Pane
        • When it comes to salaries, I'm not average
        22nd

        SQLServerCentral Newsletter

        • In-Memory OLTP – Common Workload Patterns and Migration Considerations
        • SQL Server Restart or Cluster Failover Notification
        • Demoing Latch Waits with Stupid Tricks
        • Common Mistakes
        23rd

        Database Weekly

          24th
          25th

          SQLServerCentral Newsletter

          • Receive SQL Server Alerts through Slack
          • Power BI Introduction: Working with Power BI Desktop — Part 2
          • Enable FIPS 140-2 Compliance in SQL Server
          • Database subsetting. What it is, what it’s for, and why we’d love to hear from you.
          • Closer to the Heart
          26th

          SQLServerCentral Newsletter

          • Azure DWH part 28: The ASDW enemies
          • Optimizing Your Query Plans with the SQL Server 2014 Cardinality Estimator
          • Detecting Data Breaches
          • The Opportunistic Hacker
          27th

          SQLServerCentral Newsletter

          • Exploring SQL Server Indexes: Stairway to Exploring Database Metadata Level 3
          • Scale-Out SQL Server Integration Services Environment: A Sample Pattern
          • Free eBook: SQL Server Execution Plans, Second Edition
          • When Work Gets in the Way of Work
          28th

          SQLServerCentral Newsletter

          • Calculating MTD, QTD, YTD, Running and Cumulative Total in Power BI
          • Introduction to T-SQL Window Functions
          • The OUTPUT Clause for INSERT and DELETE Statements
          • String or binary data would be truncated
          29th

          SQLServerCentral Newsletter

          • Introducing Microsoft BI Reporting and Analysis Tools
          • Data Governance, DevOps, and Delivery
          • Foreign Key Indexes and Binding
          • How are you recharging this year?
          30th

          Database Weekly

            Previous month