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

Newsletter Archive: January 2018

Find month: Show current month
SunMonTueWedThuFriSat
1st

SQLServerCentral Newsletter

  • Can you prevent deletes and inserts without a WHERE clause from running?
  • PowerShell Tool Time: Controlling Our Tools
  • Happy New Year 2018
2nd

Database Weekly

    SQLServerCentral Newsletter

    • How you can improve your SQL with code analysis in SQL Prompt
    • Automatic Plan Correction
    • Create Size-based Backups for SQL Server 2017
    • Understanding Your Value
    • Powershell Script for regular DBA activities_GenerateScripts
    3rd

    SQLServerCentral Newsletter

    • How to Turn on Instant File Initialization
    • Stairway to MDX - Level 4: The Order() Function: Beyond Cube Hierarchies
    • Free eBook: Performance Tuning with SQL Server Dynamic Management Views
    • The top 10 considerations when designing a data platform
    • No Magical DevOps
    • Difference between dates displayed in days, hours, minutes and seconds
    4th

    SQLServerCentral Newsletter

    • SQL Server Machine Learning Services – Part 1: Python Basics
    • A Brief History of Data Analysis
    • If you hear these phrases, you might need Microsoft Visual Studio Team Services
    • Using Better Tools
    5th

    SQLServerCentral Newsletter

    • Questions about Data Masking That You Were Too Shy to Ask
    • Critical SQL Server Patches for Meltdown and Spectre
    • Nasty Fast PERCENT_RANK
    • It's Time to Patch and Upgrade
    6th

    Database Weekly

      7th
      8th

      SQLServerCentral Newsletter

      • Implementing Azure SQL Database Virtual Network Service Endpoints and Rules
      • How to Change the File Extension for a Data File
      • 6 reasons why your development team needs SQL Prompt
      • It's the Engineers
      • String Search
      9th

      SQLServerCentral Newsletter

      • Azure DWH part 23: Data Mining
      • Free eBook: SQL Server Internals: In-Memory OLTP
      • GDPR: Why We Stopped Selling Stuff to Europe
      • Is This Data Science?
      10th

      SQLServerCentral Newsletter

      • Stairway to SQL Server Agent - Level 4: Configuring Database Mail
      • How SQL Monitor Monitors Azure-based SQL Server Failover Cluster Instances
      • Free eBook: Defensive Database Programming
      • SQL Crossword - Best Practices
      • Get Index Scan Count
      11th

      SQLServerCentral Newsletter

      • GDPR - A guide for the perplexed
      • A Walk Around SQL Operations Studio
      • What is database DevOps, and why is it important for DBAs?
      • Job Interviews: What is Normalization?
      12th

      SQLServerCentral Newsletter

      • Finding code smells using SQL Prompt: procedures that lack schema-qualification
      • Binary Files Import and Export
      • SQL Server 2017 and Python Basics
      • Disable or Drop
      13th

      Database Weekly

        14th
        15th

        SQLServerCentral Newsletter

        • How to automatically provision sanitized data using SQL Clone, Data Masker, and PowerShell
        • SQL Server Machine Learning Services – Part 2: Python Data Frames
        • Install Visual Studio 2015 in Server without Internet Connection
        • Do you have or make professional goals?
        16th

        SQLServerCentral Newsletter

        • NEW – Create, protect and manage non-production databases with SQL Provision
        • Step by Step Guide to Migrate SQL Server Data to SQL Server 2017
        • Disk Encryption and The Impact to DBAs
        • Customize Software or Process
        17th

        SQLServerCentral Newsletter

        • Stairway to MDX - Level 5: Members, and an Introduction to the MDX Members Functions
        • Introduction to Agile with SQL Server
        • Free eBook: SQL Server Backup and Restore
        • It's Not Yours
        • Database maintenance progress
        18th

        SQLServerCentral Newsletter

        • Formatted ASCII Results from a SELECT
        • Critical SQL Server Patches for Meltdown and Spectre
        • Introducing sp_BlitzLock: For Troubleshooting SQL Server Deadlocks
        • Finding code smells using SQL Prompt: old-style join syntax
        • The GDPR Sky is Falling
        19th

        SQLServerCentral Newsletter

        • Stairway to U-SQL Level 1: Introduction to U-SQL and Azure Data Lakes
        • Keeping track of history: SQL Compare and Temporal Tables
        • How to identify blocking in SQL Server
        • How to Grow In Your Career
        20th

        Database Weekly

          21st
          22nd

          SQLServerCentral Newsletter

          • Do Disabled Indexes Affect Missing Index Recommendations?
          • Free webinar: Database DevOps demo
          • Automatic Database Seeding
          • Critical SQL Server Patches for Meltdown and Spectre
          • Innovation Needs Information
          23rd

          SQLServerCentral Newsletter

          • Azure DWH part 24: Elastic queries
          • Validation, Verification, and Modification
          • Allowing Failure
          • usp_who5
          24th

          SQLServerCentral Newsletter

          • Stairway to Database Design Level 7: Triggers
          • Free eBook: Inside the SQL Server Query Optimizer
          • How to Change the Default Backup Directory
          • Effectiveness
          • Insert data into a SQL Server Table using Powershell using Invoke-SQLc
          25th

          SQLServerCentral Newsletter

          • Adaptive Query Processing – Batch Mode Adaptive Join
          • Create Size Based Backups for SQL Server 2017
          • Finding code smells using SQL Prompt: the SET NOCOUNT problem
          • Are You Patched?
          • Compare MS SQL Agent jobs on two servers
          26th

          SQLServerCentral Newsletter

          • How Can DevOps Concepts Provide Value in Digital Transformation Projects?
          • How to Upgrade SQL Server
          • The Database DevOps Challenges SQL Clone Solves
          • Are You Always Up?
          • How to read an audit file
          27th

          Database Weekly

            28th
            29th

            SQLServerCentral Newsletter

            • Sending table form HTML emails from a SQL Server database engine
            • SQL Server Machine Learning Services – Part 3: Plotting Data with Python
            • The top 7 business benefits of establishing DevOps in your organization
            • IoT Increases Efficiency
            • Run SQL/T-SQL scripts on folder
            30th

            SQLServerCentral Newsletter

            • Azure DWH part 25: Auditing and threat detection
            • Network Issue or THREADPOOL waits?
            • The 2018 State of Database DevOps report
            • Lowering the Noise
            31st

            SQLServerCentral Newsletter

            • Stairway to DAX and Power BI - Level 13: Simple Context Manipulation: Introducing the DAX All() Function
            • Historical Stock Prices and Volumes from Python to a CSV File
            • Free eBook: Fundamentals of SQL Server 2012 Replication
            • Thanks for the Memories, Tom
            Previous month