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: May 2015

Find month:
SunMonTueWedThuFriSat
1st

SQLServerCentral Newsletter

  • Automated database deployment workshops
  • The new Analytic functions in SQL Server 2012
  • CONCAT and STUFF Functions in SQL Server 2012
  • Finding Problem Code
  • Find the most executed stored procedure(s)
2nd

Database Weekly

    3rd
    4th

    SQLServerCentral Newsletter

    • How to FTP a Dynamically Named Flat File
    • MongoDB vs. Azure DocumentDB
    • Complete Definitions
    • Create a Comma Delimited CSV File from Any Table/View with Debugging
    5th

    SQLServerCentral Newsletter

    • Time Slots - An Essential Extension to Calendar Tables
    • How do you work with databases?
    • DDL Auditing using the Default trace
    • Can Auditing Fail?
    • Delete All Database User Accounts for a Given Server Login
    6th

    SQLServerCentral Newsletter

    • SQL Monitor Custom Metric: Plan Cache; Cache Pages Total
    • Stairway to Advanced T-SQL Level 4: Record Level Processing Using Transact-SQL Cursors
    • Generating A Password in SQL Server with T-SQL from Random Characters
    • Idempotent
    • Capture current queries when cpu is above certain threshold
    7th

    SQLServerCentral Newsletter

    • Alan Cooper: Geek of the Week
    • Tips to Optimize Your SQL Statements - Part 2
    • vNext 2016
    • Check SQL Error Logs using Powershell
    8th

    SQLServerCentral Newsletter

    • How do you work with databases?
    • Temporary Stored Procedures
    • RESTful SignalR Service
    • How Virtualized?
    • Passively detect attempts to guess passwords
    9th

    Database Weekly

      10th
      11th

      SQLServerCentral Newsletter

      • Database Source Control Workshop: Philadelphia, PA
      • How to run SSIS Project as a SQL Job
      • Making Data Analytics Simpler: SQL Server and R
      • The Service Pack Fiasco
      • Script to change auto growth settings for all databases in SQL Server
      12th

      SQLServerCentral Newsletter

      • How To Calculate Behavioral Streaks in SQL Server Data
      • How do you work with databases?
      • The Case for Scalar-valued, User-defined Functions in T-SQL
      • Opening Up Data
      • Find the position of all occurrences of an expression within a string
      13th

      SQLServerCentral Newsletter

      • The Ideal SQL Server Virtual Machine Architecture - Level 2 of the Stairway to SQL Server Virtualization
      • How to Get SQL Server Security Horribly Wrong
      • Free eBook: SQL Server Internals: In-Memory OLTP
      • Byte Me: The Nectar of Life
      • Backup all SSAS databases using TSQL
      14th

      SQLServerCentral Newsletter

      • T-SQL Programming Part 14 - Using the TOP Clause with UPDATE, INSERT and DELETE Statements
      • SQL Saturday #379 - South Florida
      • Column Store vs Row Store Indexes
      • Documenting with Tests
      • Dynamic Table Name on Select Into
      15th

      SQLServerCentral Newsletter

      • Automating Day-to-Day PowerShell Admin Tasks - Jobs and Workflow
      • Automated Database Deployment Workshop: Belfast, Northern Ireland
      • Usage of CTE - Trick with Dates
      • Searching for Plans
      • List CLR Objects in Database
      16th

      Database Weekly

        17th
        18th

        SQLServerCentral Newsletter

        • Testing Simple Calculations and UDFs with tSQLt
        • Documenting your SQL Server Database
        • SQL Saturday #407 - Vancouver
        • Boring or Scripting
        • Taking Backup Of All DBs
        19th

        SQLServerCentral Newsletter

        • A Complex Database Project in Visual Studio SSDT
        • Testing SQL Server Backup Performance with Trace Flag 3042
        • Database Source Control Workshop - London, UK
        • VMs are not VMs
        • Script to document SQL Instance Details
        20th

        SQLServerCentral Newsletter

        • DevOps and the DBA
        • Building the Ideal VMware-based SQL Server Virtual Machine - Level 3 of the Stairway to SQL Server Virtualization
        • Free Guide: Eight Steps to Effective SQL Server Monitoring
        • Controlling Alerts
        • Delete all files from a folder using xp_cmdshell
        21st

        SQLServerCentral Newsletter

        • Interactive Parameter Selection with Reporting Services
        • Webinar: How to safely manage application and database changes with continuous delivery
        • PCI Best Practices Guide for SQL Server DBAs
        • Naming Confusion
        • Dynamic sql for convert table to flat file using bcp
        22nd

        SQLServerCentral Newsletter

        • Database Continuous Integration Workshop - London, UK
        • Big Data for SQL folks: The Technologies (Part I)
        • Developer-Tester Relationships
        • Native Audits
        • Keyboard shortcut to select top 1000
        23rd

        Database Weekly

          24th
          25th

          SQLServerCentral Newsletter

          • Optimizing Batch Process in SQL Server
          • The Cascading (CROSS) APPLY
          • Memorial Day 2015
          • Standardize Object Names
          26th

          SQLServerCentral Newsletter

          • Storing a Binary File in a Database
          • Webinar: How to safely manage application and database changes with continuous delivery
          • Take our SQLServerCentral Users Survey
          • SQL Monitor Custom metric: Average I/O stalls
          • Hack Us
          • Query to find size of each disk file in a location
          27th

          SQLServerCentral Newsletter

          • Free eBook: Troubleshooting SQL Server: A Guide for the Accidental DBA
          • Using the T-SQL PERCENTILE Analytic Functions in SQL Server 2000, 2005 and 2008
          • Stairway to Advanced T-SQL Level 5: Turning Data On Its Side Using PIVOT Operator
          • Byte Me: State Of Flow
          • Detach & Attach Procedure
          28th

          SQLServerCentral Newsletter

          • Take our SQLServerCentral Users Survey
          • Converting and Using Text Dates as SQL Server Dates
          • Retrieving a Binary File from Your Database
          • The Hidden Patterns in Data
          • Dynamic sql for convert SQL statement to txt/csv file
          29th

          SQLServerCentral Newsletter

          • Big Data for SQL folks: The Technologies (Part II)
          • A Plethora of PowerShell Pitfalls: Part 2
          • Statistical Analysis
          • Store a file & Retrive it in Sql Server
          30th

          Database Weekly

            31st
            Previous month