Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 

Stay up to date!

Are these newsletters useful? Register to stay up to date with the latest news, articles, scripts and forum posts.

Email address:  

Subscribing to our newsletters gets you:

  • ALL of our content (thousands of articles, scripts, and forum postings)
  • A daily newsletter (example)
  • A weekly news round up in our Database Weekly newsletter (example)
  • The opportunity to ask and answer questions in our forums
  • A daily Question of the Day to test and help you increase your knowledge of SQL Server.

Steve Jones
Editor, SQLServerCentral.com

Newsletter Archive: October 2013

Find month: Show current month
SunMonTueWedThuFriSat
1st

SQLServerCentral Newsletter

  • SQL in the City Atlanta 2013
  • SQL Monitor Performance Metric: SQL Server: Plan Cache: Cache Pages Total
  • Data Mining Introduction Part 7: Microsoft Association
  • Database Backup and Recovery in the Age of Big Data
  • The Need for Tape
  • Permission scripting over all databases
2nd

SQLServerCentral Newsletter

  • Get CPU and Cores for SQL Server 2012 Licensing
  • Stairway to MDX - Level 1: Getting Started with MDX
  • SQL in the City Charlotte 2013
  • Secure Programming
  • The Ultimate Index Lister (Non-Pivoted)
3rd

SQLServerCentral Newsletter

  • Lab Ops 2–The Lee-Robinson Script
  • Replication: Distribution Agent Monitoring
  • The Challenges of Being Safe
  • Find Top 5 expensive Queries from a Write IO perspective
4th

SQLServerCentral Newsletter

  • Group Islands of Contiguous Dates (SQL Spackle)
  • SQL Saturday #227 - Charleston
  • RD Licensing Configuration on Windows Server 2012
  • The Ratio
  • Date and Time dimension creation and population T-SQL
5th

Database Weekly

    6th
    7th

    SQLServerCentral Newsletter

    • How to implement SHA-2 in SQL Server 2005 or 2008 with a CLR assembly
    • SQLServerCentral Changes - Oct 2013
    • DAX Statistical Functions
    • Beginner, Expert, or Both?
    • List long running SQL Agent Jobs
    8th

    SQLServerCentral Newsletter

    • Simple way to create a SQL Server Job Using T-SQL
    • Removing Duplicates
    • SQL Saturday #238 - Minnesota
    • The 2013 SQL in the City Tour
    • Find Top 5 executed queries ordered by execution count
    9th

    SQLServerCentral Newsletter

    • SSRS Reports as a Data Source in Excel 2013
    • Stairway to PowerPivot and DAX - Level 3: The DAX DISTINCT() Function and Basic Distinct Counts
    • Letting People Go Securely
    • Object Search
    10th

    SQLServerCentral Newsletter

    • SQL Saturday #237 - Charlotte
    • When SQL Server Nonclustered Indexes Are Faster Than Clustered Indexes
    • Day 327: From Prototype to Production
    • Manners
    • copy/paste multiple columns
    11th

    SQLServerCentral Newsletter

    • Red Gate to respond instantly to user requests at SQL in the City Charlotte and PASS 2013
    • Execute As
    • Getting Started with Columnstore Index in SQL Server 2014 – Part 1
    • Union Benefits
    • SQL Server Agent Jobs Statistics
    12th

    Database Weekly

      13th
      14th

      SQLServerCentral Newsletter

      • 32 bit SSIS in 64 bit environment
      • Introduction to SQL Server 2014 CTP1 Memory-Optimized Tables
      • The Case of the Lost Card
      • SQL Server System Report
      15th

      SQLServerCentral Newsletter

      • SQL Monitor Performance Metric: Buffer Cache Used Per Database in MB
      • SQL Server Integration Services Connection Manager Tips and Tricks
      • Using a column name in a COUNT function
      • The Cloud of Destiny
      • Find the size of all Indexes in a database
      16th

      SQLServerCentral Newsletter

      • Error during installation of an SQL server Failover Cluster Instance
      • Stairway to Database Design Level 4: Building a Schema
      • Four Years Later
      • SQL Powershell Script to get the Database Details remotely
      17th

      SQLServerCentral Newsletter

      • Reporting Services Disaster Recovery
      • How to Post Performance Problems
      • Replicating A Volume Of Large Data via Transactional Replication
      • Open Arms
      • Unique Identifier as Clustered index
      18th

      SQLServerCentral Newsletter

      • SQL Server 2014 CTP 2 is available
      • How to hot-add a vCPU to a virtual SQL Server
      • Slowly Changing Facts
      • Grow Your Family
      • Function to format a datetime variable by a mask
      19th

      Database Weekly

        20th
        21st

        SQLServerCentral Newsletter

        • SQL Relay 2013R2
        • When the reporting team needs an assist...
        • SQL Server Storage Internals 101
        • Database Queries and Scalability
        • SQL Powershell Script to get the list of Server's Local Admins
        22nd

        SQLServerCentral Newsletter

        • Talend vs. SSIS: A Simple Performance Comparison
        • Identifying Incompatibility Issues When Migrating SQL Server Database to Windows Azure
        • Minor Problems
        • Insert Update Stored Procedure for a table
        23rd

        SQLServerCentral Newsletter

        • Steps to rollback database changes without impacting SQL Server Log Shipping
        • Stairway to SQL PowerShell Level 3: Input and Output with PowerShell
        • Free eBook: Understanding SQL Server Concurrency
        • Recharge and Relax
        • Get record count for a specific database
        24th

        SQLServerCentral Newsletter

        • SQL Server Reporting Services Advanced Charting
        • SQL Saturday #255 Dallas
        • Managing MaxMemory Values on an Active-Active Two Node Cluster
        • Up Your Value
        • List all permission in all databases
        25th

        SQLServerCentral Newsletter

        • Disk Is Cheap! ORLY?
        • Migrate to Natively Compiled SQL Server Stored Procedures for Hekaton
        • Image is Everything
        • Database size trending with powershell
        26th

        Database Weekly

          27th
          28th

          SQLServerCentral Newsletter

          • SSIS Basics: Using the Merge Join Transformation
          • SQL Saturday #263 Manila, Phillipines
          • Performance of the SQL MERGE vs. INSERT/UPDATE
          • What's in a Name?
          • SQL Powershell Script To Check the Memory Utilization
          29th

          SQLServerCentral Newsletter

          • Using Views to Expose Encrypted Data in SQL Server
          • Exporting Execution Plans - SQL Spackle
          • SQL Saturday #248 Tampa
          • SQL Server Knockoffs
          • List all Usernames, Roles for all the databases.
          30th

          SQLServerCentral Newsletter

          • Stairway to Transaction Log Management in SQL Server, Level 1: Transaction Log Overview
          • The ETL from Hell - Diagnosing Batch System Performance Issues
          • SQL Relay 2013R2
          • Free eBook: SQL Server Hardware
          • Risky Backups
          • PivotByDate clr stored procedure
          31st

          SQLServerCentral Newsletter

          • Improving SSIS Update Performance
          • SQL in the City Seminar Portland 2013 –Deployment Stairway
          • Tuning Distributed Applications to Access Big Data
          • Becoming an MVP
          • Performance Testing Script
          Previous month