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

Newsletter Archive: August 2018

Find month:
SunMonTueWedThuFriSat
1st

SQLServerCentral Newsletter

  • Stairway to Biml Level 7 – Populating the Database for a Custom Biml Framework
  • Rolling up multiple rows into a single row and column for SQL Server data
  • Free eBook: Performance Tuning with SQL Server Dynamic Management Views
  • CI and CD Aren't Magic
2nd

SQLServerCentral Newsletter

  • Why code quality is vital in the world of database DevOps
  • Using a Derived Table to Compare Data with Values from a Previous Year
  • Understanding your Azure EA Billing Data and Building a Centralized Data Storage Solution
  • Handling Inconvenient Requests
3rd

SQLServerCentral Newsletter

  • SQL Authentication Via AD Groups Part II: Who has what access?
  • Interpreting Missing Index Recommendations
  • Is SQL Server Mature?
4th

Database Weekly

    5th
    6th

    SQLServerCentral Newsletter

    • SQL Server Data Table as CRM Data Source on VBA Form
    • The ‘Right to be Forgotten’ and Data Masker for SQL Server
    • How to Successfully Deliver IT Projects in a Not-so-Agile Organization
    • Will Terminators Be Required?
    7th

    SQLServerCentral Newsletter

    • Steps to Migrate Oracle Database to Azure SQL Database
    • Join Redgate’s SQL data catalog early access program
    • Representing XML data in SQL Server
    • The Ideal IDE
    • Table Space Used in DB
    8th

    SQLServerCentral Newsletter

    • SQL Server Index Tutorial Overview
    • Stairway to Columnstore Indexes Level 10: Optimizing Queries For Batch Mode (Part 1)
    • Free eBook: Defensive Database Programming
    • Dynamic SQL Crossword
    • Database schema wise size detail
    9th

    SQLServerCentral Newsletter

    • The march of DevOps from the backroom to the boardroom
    • The Top Five Things That DBAs Need to Monitor
    • Using a CTE as a Tally Table
    • Unwired for Weeks
    • SQL table to HTML
    10th

    SQLServerCentral Newsletter

    • Learning about FOR JSON
    • Rounding Tips and Tricks
    • Common Entity Framework Problems: N + 1
    • The Worst Day
    11th

    Database Weekly

      12th
      13th

      SQLServerCentral Newsletter

      • The conflict between data protection and DevOps
      • Go Unit Tests: Tips from the Trenches
      • Why QUOTENAME is important
      • What is NoSQL?
      • Replace-Function
      14th

      SQLServerCentral Newsletter

      • Practical PowerShell Processes with SQL Change Automation
      • Using pw-inspector in Brute Force attack on SQL Server
      • How to Remove Transparent Data Encryption From a Database
      • The Master of the Schema
      15th

      SQLServerCentral Newsletter

      • SQL Server Performance Tuning Scripts, Tips and Tricks
      • Free eBook: SQL Server Backup and Restore
      • Installing Ubuntu in Level 1 of the Stairway to SQL Server on Linux
      • Maintain Your Trustworthiness
      16th

      SQLServerCentral Newsletter

      • Information Security in Practice
      • Aggregate Data for the Last Day of the Month
      • SQL Prompt code analysis: avoid non-standard column aliases
      • What Data is Really Needed?
      17th

      SQLServerCentral Newsletter

      • Forget GDPR. Think HIPAA, SOX, PCI, SHIELD and the CCPA.
      • How to Check Performance on a New SQL Server
      • Using Code Snippets in SSMS
      • The Best Days
      18th
      19th
      20th

      SQLServerCentral Newsletter

      • Approaches to Import JSON in SSIS (SQL Server 2016+) Part 1
      • Power BI Introduction: Power Query M Formula Language in Power BI Desktop — Part 6
      • Creating Multiple Masked Databases with SQL Provision
      • Data Has a Dollar Value
      21st
      22nd
      23rd
      24th
      25th
      26th
      27th
      28th
      29th
      30th
      31st
      Previous month