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

Newsletter Archive: May 2016

Find month:
SunMonTueWedThuFriSat
1st
2nd

SQLServerCentral Newsletter

  • Forcing SQL Agent Jobs to Fail When Remote Procedures Timeout
  • Getting started with Azure SQL Data Warehouse
  • Announcing BIML Academy
  • Buzzword Bingo
  • Brute Force data search tool
3rd

SQLServerCentral Newsletter

  • GUI Enhancement on Instant File Initialization (IFI) in SQL Server 201
  • Execute Dynamic SQL commands in SQL Server
  • What Does a DBA Do?
  • Restore script for Ola Hallengren backup
4th

SQLServerCentral Newsletter

  • STRING_SPLIT() in SQL Server 2016 : Follow-Up #1
  • Free eBook: SQL Server Internals: In-Memory OLTP
  • Data Mining Part 39: Azure Machine Learning vs Microsoft Data Mining
  • What’s in a name?
  • DBCC CHECKDB to a table
5th

SQLServerCentral Newsletter

  • Understanding OPENJSON and FOR JSON in Azure and SQL 2016
  • ASP.NET Core: A More Realistic Starter Kit
  • Promoting Engineers
  • Get Space on SQL hardrive
6th

SQLServerCentral Newsletter

  • Unique Indexes Are Code; Non-Unique Indexes Are Data
  • Announcing BIML Academy
  • SQL Server Reporting Services CountDistinct and Previous Functions
  • Work to Live
  • Agent Job Schedule Description
7th

Database Weekly

    8th
    9th

    SQLServerCentral Newsletter

    • RANDom traps for the unwary
    • Big Data Architecture
    • Announcing BIML Academy
    • Don’t Miss Out on an Opportunity to Connect
    • Execute SQL Script against Multiple Servers by PowerShell
    10th

    SQLServerCentral Newsletter

    • Data Mining Part 40: Big Data and Microsoft Data Mining
    • SQL Server Security Audit Basics
    • A Lifetime of Software
    • sp_spaceused rewritten as one query (no cursors)
    11th

    SQLServerCentral Newsletter

    • Step By Step SQL Server Log Shipping
    • Stairway to Server Management Objects (SMO) Level 1: Concepts and Basics
    • Free eBook: SQL Server Transaction Log Management
    • Use Tools
    • Collecting SQL Server 2000/2005/2008 baseline
    12th

    SQLServerCentral Newsletter

    • Adding PK Exceptions to SQLCop Tests
    • Performance Surprises and Assumptions : DATEADD()
    • Solving Tempdb Issues
    • Aggregrating varchar columns
    13th

    SQLServerCentral Newsletter

    • Join Operations – Hash Match
    • The SQL Server 2016 Query Store: Analyzing Query Store Performance
    • The Proliferation of Roles
    • Compare two tables for structure and layout
    14th

    Database Weekly

      15th
      16th

      SQLServerCentral Newsletter

      • Dynamic Data Masking
      • Implementing SQL Server In-Memory OLTP
      • Software Maturity with Release Management
      • Query to get Database Size and Growth Report
      17th

      SQLServerCentral Newsletter

      • Row Level Security with SQL Server 2016: Part 2 - Blocking Updates at the Row Level
      • 3 Things I Wish I Knew When I Started Using Entity Framework
      • Half Baked Features
      • Test Your Linked Server Connections
      18th

      SQLServerCentral Newsletter

      • Differences between Delete and Truncate in SQL Server
      • Stairway to Database Source Control Level 5: Working with Others (Distributed Repository)
      • Free eBook: Troubleshooting SQL Server: A Guide for the Accidental DBA
      • SQL Server 2012 Build List
      • Byte Me: SOS
      • Split string using multiple delimiters
      19th

      SQLServerCentral Newsletter

      • Redgate DLM Demo (with TFS, TeamCity, Octopus Deploy)
      • Comparing Networking Options in Azure
      • A Comparison of JDBC Drivers for MySQL
      • The Complexity of Branches
      • Server Config Script (2005/2008/2008R2)
      20th

      SQLServerCentral Newsletter

      • Considerations around validation errors 41305 and 41325 on memory optimized tables with foreign keys
      • Natively Compiled Stored Procedures: What they are all about
      • What's Your Test Plan?
      • Unused Procedure lists - Easiest way
      21st
      22nd
      23rd

      Database Weekly

      • Boundless Opportunities

      SQLServerCentral Newsletter

      • Redgate DLM Demo (with TFS, TeamCity, Octopus Deploy)
      • Database Hardware and Infrastructure Trends
      • Sharing on-premises SQL Server Data Analyses in the Cloud with Power BI
      • The Politics of SQL Security
      • Generate script to rebuild indexes in a database
      24th

      SQLServerCentral Newsletter

      • Unified Approach to Generating Documentation for PowerShell Cmdlets
      • How to deploy and execute an SSIS package from the SSISDB catalog
      • Inside-SQL Conference: SQL Server Deep Dives in London
      • The Clustered Index is not the Primary Key
      • Execute All .SQL Script easily
      25th

      SQLServerCentral Newsletter

      • Stairway to SQL Server Extended Events Level 3: Working with the Extended Events UI
      • Free eBook: Performance Tuning with SQL Server Dynamic Management Views
      • Implementing Azure SQL Database Elastic Database Jobs
      • Byte Me: Forget It
      • Defragmentation and update statistics for all online databases
      26th

      SQLServerCentral Newsletter

      • Diagnosing parallelism-related latching
      • A tour through tool improvements in SQL Server 2016
      • Should I Stay or Go?
      • Report Alerts from SQL ErrorLog
      27th

      SQLServerCentral Newsletter

      • Automatically Creating UML Database Diagrams for SQL Server
      • Dynamically Query a 100 Million Row Table-Efficiently
      • Bias, the Serial Killer of Diversity
      • Testing all Linked Servers in all SQL SERVER servers with Powershell
      28th

      Database Weekly

        29th
        30th
        31st
        Previous month