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

Newsletter Archive: August 2016

Find month:
SunMonTueWedThuFriSat
1st

SQLServerCentral Newsletter

  • Introduction to Azure SQL Database Temporal Tables
  • How to Run Scheduled Jobs in Azure SQL Databases
  • Passwords Under Pressure
  • Show running queries
2nd

SQLServerCentral Newsletter

  • Changing Replication Passwords
  • Strengthening the Foundations of Software Architecture
  • Moving Fast at Redgate
  • Calendar Table Function
3rd

SQLServerCentral Newsletter

  • Create a SQL Server Reporting Services Report from an Analysis Services Tabular Database
  • Free eBook: Performance Tuning with SQL Server Dynamic Management Views
  • Stairway to Exploring Database Metadata Level 1: Why Should You Care About the Dynamic Online Catalog?
  • Byte Me: Earning in the Grave
  • Quick SQL Server Configuration Summary Report
4th

SQLServerCentral Newsletter

  • Proper Storage and Handling of Personal Names
  • SQL Server 2016 Temporal Table Query Plan Behaviour
  • Defensive Programming
  • What's running now?
5th

SQLServerCentral Newsletter

  • Database Lifecycle Management: Deployment and Release
  • SELECT INTO vs INSERT INTO on Columnstore
  • Adding Slicers to a Reporting Services Report
  • Failover
  • Real World: SQL Server Quick Quality Check
6th

Database Weekly

    7th
    8th

    SQLServerCentral Newsletter

    • Backup Strategy in Azure SQL?
    • Clone, Sweet Clone: Database Provisioning Made Easy?
    • Making Complex Table Changes
    • DynamicDateRangeGenerator
    9th

    SQLServerCentral Newsletter

    • Reclaiming Space After Column Data Type Change
    • Steps to change the server name for a SQL Server machine
    • Data Overload
    10th

    SQLServerCentral Newsletter

    • Stretch Database in SQL Server 2016 RTM
    • Free eBook: Defensive Database Programming
    • Stairway to U-SQL Level 6: U-SQL Indexes and Partition Schemes
    • Keyboard Hardlines
    • Script to document SQL Instance Details
    11th

    SQLServerCentral Newsletter

    • Executing Multiple Threads to Create a Load
    • SSIS in SSDT: The Basics
    • DBA Salary Survey
    • An object lesson about what is really important
    • Productivity Keyboard Shortcuts 2
    12th

    SQLServerCentral Newsletter

    • SQL Server Stored Procedure to Compress Non Partitioned Tables
    • Writing Better T-SQL: Top-Down Design May Not be the Best Choice
    • Biml Academy 2 - Importing, Staging, and Loading Data
    • Call for Articles
    • A Visit to Microsoft and SQL Server 2016
    • Function to calculate and return age in text to closest minute between
    13th

    Database Weekly

      14th
      15th

      SQLServerCentral Newsletter

      • Paying Attention to Estimates
      • Bash for ETL pre-processing
      • To Infinity and Beyond
      • Delete SQL Instance name from default backup location
      16th

      SQLServerCentral Newsletter

      • Call for Articles
      • SQL Server 2016: built-in JSON Use case scenarios
      • Crossing the Site Domain with JavaScript
      • A Slower Job
      • SQL Database Migration: Lower to Higher Version
      17th

      SQLServerCentral Newsletter

      • Simple T-SQL Code Comparison With PowerShell
      • Free eBook: SQL Server Backup and Restore
      • Stairway to SQL Server Extended Events Level 4: Extended Events Engine - Essential Concepts
      • Byte Me: Let's Cook
      • Alter database owner to SA from any user details on all user databases
      18th

      SQLServerCentral Newsletter

      • Beyond prediction with R & SQL Server
      • Why Not Just Create Statistics?
      • Designing for the Public
      • Check Up Size Of Each Folder In a Path
      19th

      SQLServerCentral Newsletter

      • Windows Containers and Docker
      • Call for Articles
      • Writing Better T-SQL: Top-Down Design May Not be the Best Choice – Part II
      • What's Your Smoke Test?
      • Standardize Object Names
      20th

      Database Weekly

        21st
        22nd

        SQLServerCentral Newsletter

        • Software Animism
        • A Tutorial With the Azure CLI (Command-Line Interface) and Azure SQL Database
        • Is Rollback Feasible for Database Changes?
        • Dynamic sql for convert table to flat file using bcp
        23rd

        SQLServerCentral Newsletter

        • What is the impact of setting SET ANSI_WARNINGS OFF?
        • Trace Flag 2389 and the new Cardinality Estimator
        • Security Leaks from Websites
        • List CLR Objects in Database
        24th

        SQLServerCentral Newsletter

        • Free eBook: Inside the SQL Server Query Optimizer
        • Installing Master Data Services in an AlwaysOn Environment
        • Stairway to U-SQL Level 7: More Partition Schemes
        • The Future for Database Administrators
        • Query to find the Job Output file location at each job step
        25th

        SQLServerCentral Newsletter

        • Using Microsoft R in Enterprise Environments
        • SQL Server Access Control: The Basics
        • Better Coding
        • A script to answer: Should I use SPARSE?
        26th
        27th
        28th
        29th
        30th
        31st
        Previous month