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: November 2013

Find month: Show current month
SunMonTueWedThuFriSat
1st

SQLServerCentral Newsletter

  • Normalizing-Denormalized Tables
  • Calculating Values within a Rolling Window in Transact SQL
  • The T-SQL Paradigm
  • An easy way to track the growth of your database
2nd

Database Weekly

  • Going over their heads: IT Decisions
3rd
4th

SQLServerCentral Newsletter

  • Fundamentals of Vendor Management
  • Database Restore Automation
  • Free eBook: 45 Database Performance Tips for Developers
  • Encrypting SQL Code
  • Security Queries: Database-level
5th

SQLServerCentral Newsletter

  • How to Design, Build and Test a Dynamic Search Stored Procedure
  • SQL Server 2008 R2 Build List
  • Different Ways to Restore a SQL Server Database
  • Interfaces
  • Security Queries: Server-level
6th

SQLServerCentral Newsletter

  • Free eBook: SQL Server Execution Plans, Second Edition
  • Stairway to PowerPivot and DAX - Level 4: The DAX BLANK() Function
  • Getting Started with Columnstored Index in SQL Server 2014 – Part 2
  • Project Hekaton
  • Capture_Login_Auths
7th

SQLServerCentral Newsletter

  • Building Real-World Microsoft BI Dashboards Today
  • SSIS Distributed Transactions
  • Effectiveness
  • Convert int to Excel column name
8th

SQLServerCentral Newsletter

  • SQL Server SQLCMD Basics
  • Blocking Users by IP
  • What Do You Want to Learn?
  • Right or Wrong, Dynamic SQL AND a Cursor
9th

Database Weekly

    10th
    11th

    SQLServerCentral Newsletter

    • The PoSh DBA – Getting Airborne with PowerShell
    • Turbocharge Your Database Maintenance With Service Broker: Part 2
    • New SQL Monitor Metric: Principals with Sysadmin Login
    • Cyberwar
    • SQL Data File Information
    12th

    SQLServerCentral Newsletter

    • SQL in the City Seminar Portland 2013 –Deployment Stairway
    • Outer Join – What am I missing (SQL Spackle)
    • Using the SQL Server Distributed Replay feature
    • Test Coverage
    • Script All Logins / Users / and Roles
    13th

    SQLServerCentral Newsletter

    • Overview of the Different In-Memory OLTP Index Types
    • Free eBook: Troubleshooting SQL Server: A Guide for the Accidental DBA
    • Stairway to SQL Server Replication: Level 2 - The Role of the Distributor
    • Runtime Code
    • Script to determine if two instances are on the same node
    14th

    SQLServerCentral Newsletter

    • Window Functions in SQL
    • What is your default database set to?
    • Time for Learning
    • Generate row constructors for existing data
    15th

    SQLServerCentral Newsletter

    • Explanation of SQL Server IO and Latches
    • Using Indexes to Reduce Blocking in Concurrent Transactions
    • Dream Jobs
    • Search Table And Field In All Database And Return Field Value
    • Search Table And Field In All Database And Return Field Value
    16th

    Database Weekly

      17th
      18th

      SQLServerCentral Newsletter

      • Locking, Blocking and Deadlocking
      • SQL in the City Seminar Washington DC 2013 –Deployment Stairway
      • Windows Azure SQL Database (WASD) Primer
      • Who Inspires You?
      • Compare Current IDENTITY Value to DataType's Boundary
      19th

      SQLServerCentral Newsletter

      • SQL CLR Multi-Threaded File Copy
      • SQL Server Index Properties in Management Studio
      • Testing Skills
      • Powershell script to interactively move cluster resources
      20th

      SQLServerCentral Newsletter

      • Free eBook: SQL Server Transaction Log Management
      • Microsoft's Log Parser Utility: Swell ETL
      • Stairway to SQL Server Replication: Level 3 - Transactional Replication – The Publisher
      • It Starts with Version Control
      • Capture User Auths For Database
      21st

      SQLServerCentral Newsletter

      • SQL Saturday #233 - Washington DC
      • Big Data for SQL folks: The Technologies (Part II)
      • Migrating SQL Server Database to Windows Azure - Resolving Incompatibility Issues
      • What is SQL Server not good at?
      • Split and concatenate function
      22nd

      SQLServerCentral Newsletter

      • Script to Set the SQL Server Database Default Schema For All Users
      • Trading in xp_cmdshell for SQLCLR (Part 1) - List Directory Contents
      • Core T-SQL
      • Automate Data Purity Investigation
      23rd
      24th

      Database Weekly

        25th

        SQLServerCentral Newsletter

        • SQL Server Operations from Set Theory
        • MCSA 70-462 Training Kit Preparation: Hyper-V Lab Environment Setup
        • Vendor Value
        • Use HASHBYTES to identify changes
        26th

        SQLServerCentral Newsletter

        • Prevent overlapping of time events with an indexed view
        • Understanding Microsoft Power BI – Self Service Solutions
        • Introducing the Red Gate SSMS Ecosystem
        • Checking Up on Developers
        • Script Login Differences
        27th

        SQLServerCentral Newsletter

        • Microsoft's Log Parser Utility: Swell ETL
        • Free eBook: Performance Tuning with SQL Server Dynamic Management Views
        • Stairway to SQL Server Indexes: Level 11, Index Fragmentation
        • Visitor Parking
        • Create tables and indexes with a Store Procedure
        28th

        SQLServerCentral Newsletter

        • SQL Saturday #264 - Ancona, Italy
        • T-SQL Best Practices - Don't Use Scalar Value Functions in Column List or WHERE Clauses
        • Test-Driven Development of T-SQL Code
        • Happy Thanksgiving 2013
        • String Search
        29th

        SQLServerCentral Newsletter

        • Workaround for lack of support for constraints on SQL Server Memory-Optimized Tables
        • More Tips for New (and old) DBAs
        • The Abstract DBA
        • Create Mirror Alerts for All Mirrored Databases
        30th

        Database Weekly

          Previous month