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

Newsletter Archive: June 2016

Find month:
SunMonTueWedThuFriSat
1st

SQLServerCentral Newsletter

  • CU#6 for SQL Server 2014 SP1 Updated
  • How to Identify Useful SQL Server Table Statistics
  • Free eBook: Defensive Database Programming
  • Stairway to Database Design Level 2: Domains, Constraints and Defaults
  • The Coffee Routine
  • Translate function for SQL Server
2nd

SQLServerCentral Newsletter

  • The Enterprise DBA Mindset as a Practical Problem-solving Approach
  • SQL Prompt 7.2 – Now With Execution Warnings!
  • Consuming JSON Formatted API Data in 2016
  • Another Re-Release
  • Export table to file with bcp chunk
3rd

SQLServerCentral Newsletter

  • The End of Big Data
  • OmniCompare: How do your SQL Servers differ?
  • Using LAST_VALUE
  • Accept Failure
  • List instances hosting similarly named databases
4th

Database Weekly

    5th
    6th

    SQLServerCentral Newsletter

    • Adding Time Intelligence to a Power BI Data Model
    • How to Query Comma Seperated Value Columns in SQL
    • A New Sample Database
    • Replication-Quick way to determine the articles
    7th

    SQLServerCentral Newsletter

    • Be the first to try Redgate SQL Compare 12
    • Nasty Fast PERCENT_RANK
    • Looking at VIEWs, Close Up
    • Abstraction
    • Table Comparison Procedure
    8th

    SQLServerCentral Newsletter

    • Free eBook: SQL Server Backup and Restore
    • Continuous Integration with Microsoft SQL Server
    • SQL Server AlwaysOn Endpoint Encryption Algorithm Compatibility Error
    • Byte Me: Coins Only
    • Space monitor on SQL Server
    9th

    SQLServerCentral Newsletter

    • STRING_SPLIT() in SQL Server 2016 : Follow-Up #2
    • Come to InsideSQL on June 14
    • How Long Before Your Database Runs Out of Space?
    • More and More Data Growth
    • Log and report on table growth for trending
    10th

    SQLServerCentral Newsletter

    • Using APPLY to make your queries DRYer
    • In-Memory OLTP - Row Structure and Indexes
    • Good Stories
    • PatExclude8K
    11th

    Database Weekly

      12th
      13th

      SQLServerCentral Newsletter

      • PowerShell Desired State Configuration: Pull Mode
      • Using IronPython to talk to SQL Server
      • The Penalty for a Data Breach
      • Data Sample Scripter
      14th

      SQLServerCentral Newsletter

      • The PoSh DBA: Accessing SQL Server from PowerShell
      • Azure Machine Learning - Your first experiment
      • The Internals of WITH ENCRYPTION
      • We Manage Algorithms
      • Write to File
      15th

      SQLServerCentral Newsletter

      • Free eBook: SQL Server Hardware
      • Sairway to U-SQL Level 1: Introduction to U-SQL and Azure Data Lakes
      • Row Level Security Part 3 – Disabling Row Level Security for DBAs and Database Owners
      • Stretch Pricing
      • PatReplace8K
      16th

      SQLServerCentral Newsletter

      • Master Data Management (MDM): Help or Hindrance?
      • Databases in Azure… Where to begin? Create a Database and log in!
      • What's Your Area of Expertise?
      • Query to find tables with Forwarded Records
      17th

      SQLServerCentral Newsletter

      • What SQL Statements Are Currently Using The Transaction Logs?
      • How to version a SQL Server Master Data Services model
      • SQL Server 2016 is Just Faster
      • Database checkout alert when SQL Starts
      18th

      Database Weekly

        19th
        20th

        SQLServerCentral Newsletter

        • Be the first to try Redgate SQL Compare 12
        • A SQL Server Date Handling Issue
        • Improved Support for Parallel Statistics Rebuilds
        • Updates During Outages
        • Script to Find String in Database object
        21st

        SQLServerCentral Newsletter

        • Taking Azure SQL Data Warehouse for a Test-Drive
        • Migrating SSIS Projects and Parameters, Part 1
        • A Beautiful Google Mind
        • Database autogrowth and initail size setup.
        22nd

        SQLServerCentral Newsletter

        • Sairway to U-SQL Level 2: Breakdown of a U-SQL Statement
        • Altering an Existing Table to Support Temporal Data
        • Free eBook: Fundamentals of SQL Server 2012 Replication
        • Byte Me: Behind Times
        • New T-SQL Fixed Width "Splitter"
        23rd

        SQLServerCentral Newsletter

        • Nasty Fast N-Grams (Part 1): Character-Level Unigrams
        • Custom Solution to Measure SQL Server Query Performance Improvements
        • Why Use R Services?
        • DigitsOnlyEE and AlphaNumericOnly
        24th

        SQLServerCentral Newsletter

        • Practical Uses for Synonyms in SQL Server
        • Persistent PowerShell: The PowerShell Profile
        • Have You Designed a Database from Scratch?
        • Send Email to recipients with Attachment using PowerShell
        25th

        Database Weekly

          26th
          27th

          SQLServerCentral Newsletter

          • Configuring geo-replication for an Azure SQL Database
          • The Plain Simple Password Page Not So Simple Anymore
          • DevOps and Security
          • Function for Getting Interval Dates by days,months,years.
          28th

          SQLServerCentral Newsletter

          • SQL Server Sargability - Queries on an Indexed Table Sometimes have Slow Performance
          • The Bleeding Edge Versus N Minus One
          • Could you help with some research for Redgate's website?
          • Democratic Data Science
          • Getting LEAD and LAG values manually
          29th

          SQLServerCentral Newsletter

          • Free eBook: SQL Server Execution Plans, Second Edition
          • Stairway to Dynamic Data Masking Level 4: Permissions and Security
          • PowerShell Interview Questions for SQL Server DBAs
          • Email or Username
          • Index and Column Configuration
          30th
          Previous month