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

Newsletter Archive: September 2016

Find month:
SunMonTueWedThuFriSat
1st

SQLServerCentral Newsletter

  • Get-SqlLogin and Remove-SqlLogin Are Here
  • New Drop If Exists Syntax in SQL Server 2016
  • Time Off
  • Unused Procedure lists - Easiest way
2nd

SQLServerCentral Newsletter

  • Comprehensive Baseline Collector Solution (Updated)
  • Master Data Management (MDM) Using SQL Server
  • The Copy Cat Poll
  • Stupid Coding Tricks: The T-SQL Mandelbrot
3rd

Database Weekly

    4th
    5th

    SQLServerCentral Newsletter

    • The Exploratory Testing Chrome Plugin
    • Generate two-dimensional QR Code® bar codes in an SSRS report
    • NCAs and NDAs
    • Magic 8 Ball
    6th

    SQLServerCentral Newsletter

    • Minimizing impact of widening an IDENTITY column – part 4
    • Resolving an Error When Creating an Availability Group Listener
    • Does Log Data Belong in a Table or a File?
    • Finding Data Islands
    7th

    SQLServerCentral Newsletter

    • Free eBook: SQL Server Execution Plans, Second Edition
    • Stairway to Exploring Database Metadata Level 2: Using the Dynamic Online Catalog to Solve Problems
    • Introduction to SQL Server Stretch Database
    • Practicing Deployments
    • Investigate Report Server Security
    8th

    SQLServerCentral Newsletter

    • Azure SQL Database – How to Choose the Right Service Tier
    • Bones of SQL - The Calendar Table
    • You know what we really need? Better interpersonal communication
    • Date-based table purge
    9th

    SQLServerCentral Newsletter

    • How to tell what SQL Server version you are running
    • A Case FOR Cursors...
    • Impressive Accomplishments
    • Convert integers/numbers into binary format - viceversa
    10th
    11th

    Database Weekly

      12th

      SQLServerCentral Newsletter

      • Creating Partition on Existing tables and Rolling Partitions
      • Real-time Operational Analytics in SQL Server 2016 - Part 1
      • Ignoring Database Version Control
      • Read all trace file data and print the action performed
      13th

      SQLServerCentral Newsletter

      • Direct Query with Power BI
      • Restore Gene Version 6 - User Guide
      • Encryption Keys Matter
      • Calculate distance between 2 coordinates/latlong
      14th

      SQLServerCentral Newsletter

      • Free eBook: SQL Server Internals: In-Memory OLTP
      • Best Practices For Building Alerts for Using APIs with SQL Server
      • Stairway to U-SQL Level 8: Joining Tables in U-SQL
      • Down Tools Week 2016
      • Split string using multiple delimiters - version 2

      SQLServerCentral Newsletter

      • Stairway to U-SQL Level 8: Joining Tables in U-SQL
      • Best Practices For Building Alerts for Using APIs with SQL Server
      • Free eBook: SQL Server Internals: In-Memory OLTP
      • Down Tools Week 2016
      • Split string using multiple delimiters - version 2
      15th

      SQLServerCentral Newsletter

      • Using SQL Compare with Row Level Security
      • Free Webinar: Redgate DLM Demo
      • Introduction to Microsoft R Services in SQL Server 2016
      • Data Science Education
      • Checking All Date Columns in a Table(s)
      16th

      SQLServerCentral Newsletter

      • Creating PowerShell Stacks and Expression Evaluators
      • Indexing Foreign Keys
      • The Danger of xp_cmdshell
      • Querying deadlock graph from SQL Extended Events
      17th

      Database Weekly

        18th
        19th

        SQLServerCentral Newsletter

        • The Bones of SQL - The Holiday Table
        • An Introduction to In-Memory OLTP Database Objects
        • The 10X Programmer
        • Restore of database
        20th

        SQLServerCentral Newsletter

        • Rounding Tips and Tricks
        • Reading the SQL Server log files using TSQL
        • Free Webinar: Redgate DLM Demo
        • Are You a Tech Company?
        • Quick check server space and DB size
        21st

        SQLServerCentral Newsletter

        • Free eBook: SQL Server Transaction Log Management
        • Stairway to DAX and Power BI - Level 11: Function / Iterator Function Pairs: The DAX Concatenate() and ConcatenateX() Functions
        • Free-Con Pre-Con at the Pass Summit 2016
        • Byte Me: JavaScripting
        • Backup History for all databases
        22nd

        SQLServerCentral Newsletter

        • Monitor up-time and connectivity with Powershell
        • AT TIME ZONE – a new favourite feature in SQL Server 2016
        • Code completion, formatting and refactoring for SQL Server
        • Capture the Flag
        • CPU Utilization by database and SQL Query.
        23rd

        SQLServerCentral Newsletter

        • Stairway to Advanced T-SQL Level 5: Turning Data On Its Side Using PIVOT Operator
        • Querying Multiple MySQL Tables
        • Audit and Compliance Survey
        • What Helps You Learn?
        • Romanian Number Humanizer in SQL Server
        24th

        Database Weekly

          25th
          26th
          27th
          28th
          29th
          30th
          Previous month