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

Newsletter Archive: July 2016

Find month:
SunMonTueWedThuFriSat
1st

SQLServerCentral Newsletter

  • Mutating Table Error In Oracle: Why It Happens And What You Can Do About It
  • SSIS Design Pattern - Staging Delimited Flat Files
  • The cmdlets Are Coming! The cmdlets Are Coming!
  • An example of how networking netted a new job
  • Procedure to Find Candidate Keys
2nd

Database Weekly

    3rd
    4th

    SQLServerCentral Newsletter

    • Difference between SQL Server Unique Indexes and Unique Constraints
    • Stairway to SQL Server Virtualization Level 1: What is Virtualization?
    • Independence Day II
    • Quick table size information
    5th

    SQLServerCentral Newsletter

    • 3 Built-In Technologies for Centralizing SQL Server Administration
    • Power BI to Azure SQL and Google Analytics
    • The Bad Data Shutdown
    • Script to Generate Foreign Keys
    6th

    SQLServerCentral Newsletter

    • Introduction to the Azure SQL Database Advisor
    • Free eBook: SQL Server Internals: In-Memory OLTP
    • Stairway to U-SQL Level 3: Processing Multiple Files With U-SQL
    • Byte Me: DeleteDeleteDelete
    • Get Blocking Details
    7th

    SQLServerCentral Newsletter

    • Stairway to DLM Dashboard Level 1: An Introduction
    • What's "Actually" going on with that Seek?
    • Changing Linked Server Properties
    • Fuzzy Processing
    • Kill Connections for a specific database
    8th

    SQLServerCentral Newsletter

    • 5 Monitoring Queries for SQL Server
    • Finding and Eliminating Duplicate or Overlapping Indexes
    • The Need for Database Intelligence Software
    • Database Snapshot Creat/Drop/Restore SQL Script.
    9th

    Database Weekly

      10th
      11th

      SQLServerCentral Newsletter

      • Importing Blobs from a MySQL Database and Export Them
      • Dynamic Images in SQL Server Reporting Services
      • Going On-Prem?
      • SQL Server Backup, Integrity Check, Index and Statistics Maintenance
      12th

      SQLServerCentral Newsletter

      • SQL Server 2014 Service Pack 2 is Available
      • Calculating MySQL Database, Table, and Column Sizes
      • The COUNT Function in T-SQL
      • Baby Steps to DevOps
      • Get earliest and latest date values in a database
      13th

      SQLServerCentral Newsletter

      • Different Options for Importing Data into SQL Server
      • Stairway to Server Management Objects (SMO) Level 2: Connections and Creating Server Inventories
      • Free eBook: SQL Server Transaction Log Management
      • Losing Rows
      • Find Missing Backups and send the report
      14th

      SQLServerCentral Newsletter

      • Introduction to Row Level Security in SQL 2016
      • Stairway to DLM Dashboard Level 2: Setting up DLM Dashboard
      • The New Data Warehouse Choice
      • Find Free Space by Database
      15th

      SQLServerCentral Newsletter

      • SQL Server 2016 Temporal Table Query Plan Behaviour
      • A Happy Birthday Present from Minionware
      • Stairway to T-SQL: Beyond The Basics Level 8: Coding Shortcuts using += and -= Operators
      • The Remote DBA
      • Find Orphan users for each database in a given SQL Instance
      16th

      Database Weekly

        17th
        18th

        SQLServerCentral Newsletter

        • SQL Server 2016 - what's changed in the SQL Toolbelt?
        • SQL Authentication Via AD Groups Part III: What About Orphaned Users?
        • Encrypting and Decrypting SQL Server Stored Procedures, Views and User-Defined Functions
        • Security is Getting Serious
        • Replication Monitor
        19th

        SQLServerCentral Newsletter

        • Planning for a Successful Database Lifecycle
        • Databases in Azure: Copy and Exports
        • Scary Deployments
        • Capture Linux Drive Space data with Powershell
        20th

        SQLServerCentral Newsletter

        • Number of Rows Read / Actual Rows Read warnings in Plan Explorer
        • Stairway to U-SQL Level 4: U-SQL and Data Lake Tooling with Visual Studio
        • Free eBook: Troubleshooting SQL Server: A Guide for the Accidental DBA
        • The Relentless Cloud
        • Using Powershell to run queries on remote server .
        21st

        SQLServerCentral Newsletter

        • Using SQL Compare with Dynamic Data Masking
        • Target Recovery Interval and Indirect Checkpoint
        • SQL Server differences of char, nchar, varchar and nvarchar data types
        • Byte Me: Supervirus
        • Missing Index Script with Create Statement
        22nd

        SQLServerCentral Newsletter

        • PowerShell Desired State Configuration: Automating and Monitoring Pull mode
        • Stairway to T-SQL: Beyond The Basics Level 4: Using Views to Simplify Your Query
        • How do you know when it is time to leave a job?
        • Random Lottery Number Generator
        23rd

        Database Weekly

          24th
          25th

          SQLServerCentral Newsletter

          • The IT Manager's perspective: People as an Asset
          • Additional Data Files and Proportional Fill
          • Where's the Unit Testing?
          • Alert for low identities available
          26th

          SQLServerCentral Newsletter

          • Azure SQL Limitations compared with a SQL Server Enterprise
          • What's "Actually" going on with that Seek?
          • Redgate’s 2016 Roadmap
          • A Buggy Release
          • Fibonacci Series in TSQL
          27th
          28th
          29th
          30th
          31st
          Previous month