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

Newsletter Archive: August 2017

Find month: Show current month
SunMonTueWedThuFriSat
1st

SQLServerCentral Newsletter

  • How to Generate a Restore Script
  • Simple Talk is hiring a full-time editor
  • Azure DWH part 13: Load data using Data Platform Studio
  • Who's Licensed?
2nd

SQLServerCentral Newsletter

  • Performance Myths : Oversizing string columns
  • Free eBook: Troubleshooting SQL Server: A Guide for the Accidental DBA
  • Stairway to T-SQL DML Level 3: Implementing a Relational Model in SQL Server
  • Data Science en Masse
3rd

SQLServerCentral Newsletter

  • SQL Monitor plans for the second half of 2017
  • Fuzzy Search
  • Ingest data from a web page into SQL Server 2017 using R
  • The Second Best Job
4th

SQLServerCentral Newsletter

  • Developing Metadata Design Patterns in BIML
  • Dynamic Pivot, Passing Temp Table Variables to Dynamic SQL
  • Learning through Puzzles
5th

Database Weekly

    Database Weekly

      6th
      7th

      SQLServerCentral Newsletter

      • SQL Server Management Studio Recovery, Reporting, Key Combinations and Efficiency Tips
      • Using Super Keys to Enforce Database Constraints
      • To-do list: good, bad or indifferent?
      8th

      SQLServerCentral Newsletter

      • Removing sensitive data from a database
      • How to Automatically Create and Refresh Development and Test Databases
      • Fixing Plan Issues in the Middle of the Night
      • What's Your Approach?
      9th

      SQLServerCentral Newsletter

      • Sliding Scale Parallelism: Why Stop At DOP?
      • Microsoft IT: A Case Study on “Hekaton” against RPM – SQL Server 2014 CTP1
      • Stairway to AlwaysOn Level 2: Storage 101
      • Free eBook: Understanding SQL Server Concurrency
      • My Problem, or Yours?
      10th

      SQLServerCentral Newsletter

      • Filegroup Restoring and Join Elimination
      • SQL Server R Services: The Basics
      • Accelerating Your Career
      11th

      SQLServerCentral Newsletter

      • Introduction to Azure SQL Data Sync
      • The ABCs of Database Creation
      • What's in your CLR?
      12th

      Database Weekly

        13th
        14th

        SQLServerCentral Newsletter

        • SQL Server Management Studio Tips
        • Using multiple custom SQL formatting styles in SQL Prompt
        • SQL Server function to check dynamic SQL syntax
        • Hiring Guitarists
        15th

        SQLServerCentral Newsletter

        • Let’s Corrupt a Database Together, Part 3: Detecting Corruption
        • Using Database Master Keys in SQL Server
        • Hiring Heterogeneously
        16th

        SQLServerCentral Newsletter

        • Monitoring Azure Cloud and Hybrid Environments
        • New permissions features brings access control to SQL Clone
        • Free eBook: Performance Tuning with SQL Server Dynamic Management Views
        • Stairway to SQL Server Automated Database Testing Level 1: Why You Need TDD
        • SQL Crossword #2 SELECT Keywords
        17th

        SQLServerCentral Newsletter

        • How to Read a Transaction Log Backup
        • Testing COALESCE with tSQLt
        • Opinions and Votes
        18th

        SQLServerCentral Newsletter

        • Database Code Analysis
        • Analysing Sales Patterns: R + SQL Server
        • Failed Projects
        19th

        Database Weekly

          20th
          21st

          SQLServerCentral Newsletter

          • Azure DWH part 14: PolyBase to access to Non relational data
          • Extending DevOps practices to SQL Server databases with Redgate, Git & Jenkins
          • Is It Time To Stop Using IsNumeric()?
          • A Data ID
          22nd

          SQLServerCentral Newsletter

          • How to Find Out Which Database Object Got Deleted
          • Load Extended Events via Powershell
          • Jumping Ahead
          23rd

          SQLServerCentral Newsletter

          • Stairway to SQL Server Extended Events Level 1: From SQL Trace to Extended Events
          • Installing SQL Server Agent on SUSE Linux
          • Free eBook: Defensive Database Programming
          • Use More Pull Requests
          24th

          SQLServerCentral Newsletter

          • Curious Case of SUM Function
          • Why Missing Index Recommendations Aren’t Perfect
          • Register for the Redgate Hub Launch Livestream on September 6
          • The Downsides of AI
          25th

          SQLServerCentral Newsletter

          • The Basics of Good T-SQL Coding Style – Part 3: Querying and Manipulating Data
          • SQL Server and Data Governance
          • SQLCMD Mode; Run all SQL files in a directory
          • Why PolyBase Matters
          • The Career Bucket List
          • CDC watchdog for databases in AlwaysOn AG
          26th

          Database Weekly

            27th
            28th

            SQLServerCentral Newsletter

            • SQL Census update: new server view
            • Implementing Azure SQL Data Sync in the Azure Portal
            • TDS Remoting: A Better Way to Create Linked Servers for ODBC Sources
            • Graphing Performance
            29th

            SQLServerCentral Newsletter

            • Poll: If you could gain an extra hour in your working day, what would you spend it on?
            • Fighting Evil in Your Code: Comments on Comments
            • Incremental Package Deployment – A SSIS 2016 Feature
            • Who's Responsible?
            30th

            SQLServerCentral Newsletter

            • Automating the Synchronization of RDS SQL Server Agent Jobs in a Multi-AZ Environment
            • Stairway to U-SQL Level 16: The Azure Data Lake Catalog
            • Free eBook: SQL Server Backup and Restore
            • Database Development Made Easy?
            31st

            SQLServerCentral Newsletter

            • Register for the Redgate Hub Launch Livestream on September 6
            • Resolving could not open a connection to SQL Server errors
            • SSIS as an Execution Engine for Multiple Sql scripts
            • Appreciating New Perspectives
            Previous month