Click here to monitor SSC
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 

Newsletter Archive: April 2016

Find month:
SunMonTueWedThuFriSat
1st

SQLServerCentral Newsletter

  • New MySQL Engine Supports T-SQL
  • The Database Transaction Unit (DTU) Decoded
  • Relational Algebra and its implications for NoSQL databases
  • SnowCrash for SQL Server
  • Counting
2nd

Database Weekly

    3rd
    4th

    SQLServerCentral Newsletter

    • Move an Existing Log Shipping Database to a New Monitor Server
    • Bad Cardinality Estimates from SSMS Plans – Redux
    • Would You Move For a Job?
    • Querying deadlock graph from SQL Extended Events
    5th

    SQLServerCentral Newsletter

    • SQL Server on Linux
    • A SQL Server Patching Shortcut
    • New – work better with Git using SQL Source Control 5 beta
    • The 2015/2016 Simple-Talk Awards
    • No Overtime
    • A new set-based T-SQL solution for Sudoku puzzle
    6th

    SQLServerCentral Newsletter

    • Free eBook: SQL Server Backup and Restore
    • Stairway to Dynamic Data Masking Level 3: The Configured Data Masks
    • Performance Surprises and Assumptions: STRING_SPLIT
    • Byte Me: Spy Where?
    • Script out all alerts
    7th

    SQLServerCentral Newsletter

    • Using Code Snippets in SSMS
    • Exploring SQL Server 2016 Dynamic Data Masking – Part Two - Masking and Exporting Data in Existing Tables
    • Naming Is Hard
    • Generate RESTORE DATABASE Script without Using CMDSHELL
    8th

    SQLServerCentral Newsletter

    • Finding Special Characters within Character Strings
    • The Comeback of Migrations-Based Deployments
    • How Much Can You Learn?
    • Code For Truncating Table with foreign Key Constraints
    9th

    Database Weekly

      10th
      11th

      SQLServerCentral Newsletter

      • NonClustered Index Structure
      • Getting Started with Temporal Table in SQL Server 2016 – Part 1
      • The Data Dewey Decimal System
      • Script move of DB files from one location to another
      12th

      SQLServerCentral Newsletter

      • How to fix SQL Server deadlocks with monitoring
      • Splitting Strings in SQL Server 2016
      • The 2015/2016 Simple-Talk Awards: Winners Announced
      • A Welcoming Conference
      • Quick snapshot
      13th

      SQLServerCentral Newsletter

      • Free eBook: SQL Server Hardware
      • TEMPDB Enhancements in SQL Server 2016
      • Changes to a Writable Partition May Fail Unexpectedly
      • Build a POC
      • Datetime Formats
      14th

      SQLServerCentral Newsletter

      • Data Mining Part 37: The Data Mining query transformation task
      • What is Code Coverage For?
      • Successful Projects
      • Create notifications for failed jobs with one easy script
      15th

      SQLServerCentral Newsletter

      • sp_msforeachdb: Improving on an Undocumented Stored Procedure
      • T-SQL Window Function Speed Phreakery: The FIFO Stock Inventory Problem
      • What's Your Downtime?
      • Dynamic sql procedure for bulk insert
      16th

      Database Weekly

        17th
        18th

        SQLServerCentral Newsletter

        • SQL Server System Functions: The Basics
        • Exporting Azure Data Factory (ADF) into TFS Source Control
        • The Hidden Trigger
        • Dynamically Generate Format File For OPENROWSET
        19th

        SQLServerCentral Newsletter

        • Unattended Installation
        • What Does the Near-Future of PowerShell & SQL Server Look Like? An Interview with Ken Van Hyning
        • Row Level Security with SQL Server 2016
        • Crack that Encrypted Data
        • GetNumsAB
        20th

        SQLServerCentral Newsletter

        • Free eBook: Fundamentals of SQL Server 2012 Replication
        • Getting Started Tuning Performance in Azure SQL Database
        • Stairway to T-SQL: Beyond The Basics Level 6: Using the CASE Expression and IIF Function
        • Byte Me: Inadequate Cooling
        • Database File Move Etc
        21st

        SQLServerCentral Newsletter

        • Migrating an on premise SQL Server Database to Azure
        • Database Version Control
        • Guess the RTM Build
        • Version independent spGetBackupDateFromFile
        22nd

        SQLServerCentral Newsletter

        • Automatic SSRS report output of all report parameter combinations
        • Reaping the benefits of the Window functions in T-SQL
        • Backups Over Time
        • Open Transaction Alarm to Log to the Event log
        23rd

        Database Weekly

          24th
          25th

          SQLServerCentral Newsletter

          • Verify SQL Backups With SQL Powershell
          • Write for SQLServerCentral - Bonus for Azure
          • Knee-Jerk Performance Tuning: Incorrect Use of Temporary Tables
          • The Pen Test
          • Determine Easter Sunday
          26th

          SQLServerCentral Newsletter

          • The Practical Problems of Determining Equality and Equivalence in SQL
          • SQL Server Resource Governor
          • Announcing Bilm Academy
          • Specialist or Generalist
          • Format Date Time Function
          27th

          SQLServerCentral Newsletter

          • Data Mining Part 38: Text Mining - The term lookup
          • Free eBook: SQL Server Execution Plans, Second Edition
          • How to change server level collation for a SQL Server Instance
          • Cloud First
          • Calculate Age (in years)
          28th

          SQLServerCentral Newsletter

          • Azure SQL Database Elastic Database Jobs
          • Generate a SSIS-package that reads from Twitter using Biml
          • Losing All Traces of Data
          • Pad length
          29th
          30th
          Previous month