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

Newsletter Archive: November 2017

Find month: Show current month
SunMonTueWedThuFriSat
1st

SQLServerCentral Newsletter

  • Live Query Plans and Blocking
  • Free eBook: Defensive Database Programming
  • Stairway to AlwaysOn Level 3: Infrastructure 101
  • Does Your Work Attire Really Make a Difference?
2nd

SQLServerCentral Newsletter

  • Why is My Database Application so Slow?
  • Loading partitioned table incrementally using SSIS
  • What are the leading DevOps drivers in financial services?
  • Good Practices for Software Development
  • Generate scripts for SQL Server Management Studio diagrams
3rd

SQLServerCentral Newsletter

  • Azure SQL Database Long-Term Backup Retention
  • Additional Data Files and Proportional Fill
  • Why it’s time to think seriously about SQL Server 2017
  • Core T-SQL
  • Script to send database consistancy errors
4th

Database Weekly

    5th
    6th

    SQLServerCentral Newsletter

    • SQL Code Smells
    • Name Value Pairs Table Handling
    • Looking Back at the Summit
    7th

    SQLServerCentral Newsletter

    • How to record T-SQL execution times using a SQL Prompt snippet
    • Importing Files in Parallel with SSIS
    • Dynamic Data Masking on Azure SQL Database
    • What are you worth?
    8th

    SQLServerCentral Newsletter

    • SQL Server R Services: Working with Data Frames
    • Free eBook: SQL Server Backup and Restore
    • Stairway to AlwaysOn Level 4: Analyse and Deploy a Windows Server Failover Cluster
    • Should We Move to Azure?
    9th

    SQLServerCentral Newsletter

    • Change Integer to BigInt on a Very Large Table
    • Can the database be included in DevOps in financial services?
    • How to Do a SQL Server Architecture Review
    • Introverted vs Extroverted
    10th

    SQLServerCentral Newsletter

    • Advanced Analytics with R & SQL: Part I - R Distributions
    • Mixing MongoDB and Relational Databases in the Enterprise
    • How Long Before You Upgrade?
    11th

    Database Weekly

      12th
      13th

      SQLServerCentral Newsletter

      • Missing Data
      • Alert Inbox Grouping Preview in SQL Monitor
      • Dynamically Create Warehouse Dimensions
      • Who Owns the Data?
      • Delete Change Tracking table data sys.syscommittab
      14th

      SQLServerCentral Newsletter

      • Vagrant and SQL Server 2017 on Linux
      • How to Do a Free SQL Server Health Check
      • Holiday parties: Do you love them or hate them?
      • Logshipping Report
      15th

      SQLServerCentral Newsletter

      • Remembering passwords in SQL Compare and SQL Data Compare
      • Stairway to MDX - Level 2: The Ordinal Function
      • Free eBook: Inside the SQL Server Query Optimizer
      • Consuming hierarchical JSON documents in SQL Server using OpenJSON
      • The SQL Server Crossword
      16th

      SQLServerCentral Newsletter

      • Cleanly Uninstalling Stubborn SQL Server Components
      • Webinar: data protection & privacy in the world of DevOps
      • Exporting Custom Messages from Sys.Messages
      • Start Fixing Your DB with Better Code
      17th

      SQLServerCentral Newsletter

      • Questions About RDS SQL Server That You Were Too Shy to Ask
      • Auto Generate Your Database Documentation
      • SQL Clone Quick Tip: Offloading DBCC checks
      • SOS
      • Dynamic SQL procedure for bulk insert
      18th

      Database Weekly

        19th
        20th
        21st

        SQLServerCentral Newsletter

        • Preparing your data platform for peak period sales
        • DBAs and the ITIL Framework, Part II: Asset Management
        • More SQL Server Features that Time Forgot
        • Avoiding Development Taxes
        • Reporting by date - DateTrunc
        22nd

        SQLServerCentral Newsletter

        • Free eBook: Fundamentals of SQL Server 2012 Replication
        • SQL Source Control v6 now supports SQL Server 2017, SQL Graph, and TFS 2018
        • Stairway to MDX - Level 3: The Order() Function
        • Dynamic Data Masking on Azure SQL Database
        • The Pressure to Perform
        • Read Only access to all databases to a user in a SQL Server Instance
        23rd

        SQLServerCentral Newsletter

        • Extending DevOps practices to SQL Server databases with ReadyRoll and VSTS
        • Databases in Azure… Where to begin? Create a Database and log in!
        • SQL Server R Services: Generating Sparklines and Other Types of Spark Graphs
        • Happy Thanksgiving 2017
        24th

        SQLServerCentral Newsletter

        • Implied Predicate and Partition Elimination
        • How advanced is database DevOps in financial services?
        • Bones of SQL - The Calendar Table
        • The Most Wanted Upgrade
        25th

        Database Weekly

          26th
          27th

          SQLServerCentral Newsletter

          • Track Sensitive Data with SQL Server Extended Properties
          • How to manage and monitor large SQL Server estates
          • SQL Saturday statistics – Web Scraping with R and SQL Server
          • Practice Until You Don't Get It Wrong
          28th

          SQLServerCentral Newsletter

          • What to Do When You Get a “Cache is Out of Date” Error Message
          • What's your opinion on database DevOps?
          • Database Cloning Tools in Lower Environments
          • We Need DevOps for Performance
          29th

          SQLServerCentral Newsletter

          • How to deploy changes to Azure SQL Database using SQL Compare and Azure Active Directory
          • Free eBook: SQL Server Execution Plans, Second Edition
          • Stairway to DAX and Power BI - Level 12: Function / Iterator Function Pairs: The DAX CountA() and CountAX() Functions
          • Simple SQL: Handling Location Datatypes
          • DMO Word Scramble
          30th

          SQLServerCentral Newsletter

          • The Difference Between Rollup and Cube
          • Free virtual event: SQL in the City Streamed
          • Free Database Unit-Testing Framework for SQL Server
          • Certifying Schools
          Previous month