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

Newsletter Archive: September 2017

Find month: Show current month
SunMonTueWedThuFriSat
1st

SQLServerCentral Newsletter

  • Learning designed for the data professional
  • What is the biggest mistake you made in production?
  • PowerShell Tool Time: Our First Toolbox
  • Improving Log Shipping
2nd

Database Weekly

    3rd
    4th

    SQLServerCentral Newsletter

    • Statistics in SQL: The Mann–Whitney U test
    • Protecting production data in non-production environments
    • Time Traveling with Temporal Tables on SQL Server 2016
    • The End of Summer
    5th

    SQLServerCentral Newsletter

    • Azure DWH part 15: PolyBase and Azure Data Lake
    • Register for the Redgate Hub Launch Livestream on September 6
    • Introduction to Azure Cosmos DB
    • What is your definition of a DBA?
    6th

    SQLServerCentral Newsletter

    • Using SQL Server Dynamic Online Catalog to Explore Keys and Relationships: Stairway to Exploring Database Metadata Level 4
    • Five Mistakes Performance Tuners Make
    • Free eBook: Inside the SQL Server Query Optimizer
    • SQL Security Crossword
    7th

    SQLServerCentral Newsletter

    • SQL Graph Objects in SQL Server 2017: the Good and the Bad
    • The Shortcomings of Predictive Accuracy
    • Why don’t you unit test SQL Server code?
    • Using Tools that Fit
    • SQL Procedure for adding Database in existing Always-On HADR.
    8th

    SQLServerCentral Newsletter

    • Setup and Implement SQL Server 2016 Always On Distributed Availability Groups
    • DBAs and the ITIL Framework
    • Creatures of habit, snowflakes, and integration tax
    • The Control Poll
    9th

    Database Weekly

      10th
      11th

      SQLServerCentral Newsletter

      • What Mail Items Have Been Sent With Database Mail
      • Challenge Your Code Design
      • Final Thoughts
      12th

      SQLServerCentral Newsletter

      • Pattern Recognition via Principal Components Analysis
      • Guide available for enhancing privacy and addressing GDPR requirements with the Microsoft SQL platform
      • SQL Data Aggregation Aggravation
      • The Randomness of Analog
      • Add new Databases to a AG Setup with PowerShell
      • Database Restoration SQL Procedure for SQL Server 2014.
      13th

      SQLServerCentral Newsletter

      • Moving Dynamic Data Masked Data to New Locations
      • Protecting SQL Server from Ransomware
      • Free eBook: Fundamentals of SQL Server 2012 Replication
      • A Backup Change
      • SQL Agent jobs that run SSIS packages
      14th

      SQLServerCentral Newsletter

      • Automate MSBI deployments Using PowerShell
      • sp_AllNightLog: Creating Jobs Like I’m The President
      • Extending DevOps practices to SQL Server databases with ReadyRoll from Redgate
      • I Will Write Bad Code
      • Get SSAS Tabular Model (2016) Roles using Powershell `
      15th

      SQLServerCentral Newsletter

      • A Pattern for Email Address storage and retrieval
      • SQL Server R Services: Digging into the R Language
      • Voting for Change
      16th

      Database Weekly

        17th
        18th

        SQLServerCentral Newsletter

        • Redgate wants your opinion
        • The Instance ID MSSQLSERVER Is Already In Use
        • How to Drop All Your Indexes – Fast
        • The Full Court CosmosDB Press
        19th

        SQLServerCentral Newsletter

        • Moving beyond principal components analysis
        • Benchmark your Database DevOps maturity level
        • Searching and finding a string value in all columns in a SQL Server table
        • The Library Job Hunt
        20th

        SQLServerCentral Newsletter

        • Investigating the Cause of SQL Server High CPU Load Conditions When They Happen
        • Stairway to U-SQL Level 17: Executing U-SQL Jobs with PowerShell
        • Free eBook: SQL Server Execution Plans, Second Edition
        • Interviews: What is ACID?
        21st

        SQLServerCentral Newsletter

        • SQL Server 2016 SSIS Basics - Install SQL Server Data Tools
        • Use SQL Server? Redgate would like to hear from you
        • Purging Old Database Mail Items
        • The Avalanche of Cloud Computing
        22nd

        SQLServerCentral Newsletter

        • Insert Stored Procedure Results Into New Table Without Using OPENQUERY
        • The Best of Both Worlds: Using Excel and Power BI Together
        • Help from Cortana
        23rd
        24th
        25th

        Database Weekly

        • A SQL Server Bug and Data Security

        SQLServerCentral Newsletter

        • SQLCLR in Practice: Creating a Better Way of Sending Email from SQL Server
        • Extending DevOps practices to SQL Server databases with ReadyRoll from Redgate
        • When sp_HelpText is not so helpful!
        • The Flash DBA
        26th

        SQLServerCentral Newsletter

        • What If Week: What Would You Fix Or Change?
        • Azure DWH part 16: BCP to import and export data
        • The Problems with Gods
        27th

        SQLServerCentral Newsletter

        • Stairway to Advanced T-SQL Level 9: Compare, Modify, Derive and Validate Date and Time Values
        • Free eBook: SQL Server Internals: In-Memory OLTP
        • How to use a Project in SQL Server Management Studio
        • Delightful Database Diversion
        28th

        SQLServerCentral Newsletter

        • Representing a simple hierarchical list in SQL Server with JSON, YAML, XML and HTML
        • Guide to Create a SQL Central Management Server
        • Benchmark your Database DevOps maturity level
        • We Have a Date
        29th

        SQLServerCentral Newsletter

        • A whole new way to see differences in SQL Compare
        • 3 Things I Wish I Knew When I Started Using Entity Framework
        • Implementing SQL Server Failover Clustering in Azure
        • A New New World
        30th

        Database Weekly

          Previous month