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: December 2014

Find month:
SunMonTueWedThuFriSat
1st

SQLServerCentral Newsletter

  • Using Stored Procedures to Provide an Application’s Business-Logic Layer
  • sp_msforeachdb: Improving on an Undocumented Stored Procedure
  • Your Best Work
  • Read all trace file data and print the action performed
2nd

SQLServerCentral Newsletter

  • The 2014 Tribal Awards - Nominations Open
  • Runbooks in SQL Azure
  • SQL Server Survey
  • The Value of Code
  • Calculate age - Most easiest way
3rd

SQLServerCentral Newsletter

  • Stairway to SQL Server Security Level 5: Schemas and Security
  • Free eBook: Defensive Database Programming
  • Bitwise Operations in T-SQL
  • Always Canary
  • What's running now
4th

SQLServerCentral Newsletter

  • SQL Server Survey
  • Monitor Database Growth and Usage
  • The Big Database Freeze
  • What Have You Learned Lately?
  • Show Table Parents
5th

SQLServerCentral Newsletter

  • The SQL Scrabble Puzzle
  • Webinar: Performance Tuning .NET & SQL Code Using ANTS Performance Profiler
  • SQL Server Developer tools survey
  • What, When and who? Auditing 101
  • Overcoming Proposal Objections
  • Check Linked Servers Connectivity
6th

Database Weekly

    7th
    8th

    SQLServerCentral Newsletter

    • Scripting SQL Server databases with SMO using EnforceScriptingOptions
    • How to troubleshoot SSL encryption issues in SQL Server
    • We Still Need Human Judgment
    • Generate Roman Numerals
    9th

    SQLServerCentral Newsletter

    • SQL Server Developer tools survey
    • Continuous Delivery for Databases: Microservices, Team Structures, and Conway's Law
    • The 2014 Tribal Awards - Nominations Open
    • SSRS - Report for Stored Procedure with Multiple Values Passed
    • Holiday Struggles
    • Convert integers/numbers into binary format - viceversa
    10th

    SQLServerCentral Newsletter

    • Lead and Lag Functions in SQL Server 2012
    • Level 4: Analyse & Deploy a Windows Server Failover Cluster
    • Free eBook: SQL Server Execution Plans, Second Edition
    • Managerial Moneyball
    • Date-based table purge
    • Date-based table purge
    11th

    SQLServerCentral Newsletter

    • SQL Monitor Custom Metric: Excessive Virtual Log Files in Transaction Log
    • Cloud Identities versus Federated Identities in Office 365
    • A Spectacular Case of 100% CPU Caused by Online Reindexing
    • SQL Server Survey
    • Citizen Programmers
    • dbWarden - Purge old data
    12th

    SQLServerCentral Newsletter

    • Finding SQL Server views with (or without) a certain property
    • What, when and who? Auditing 101 - Part 2
    • The Last Job
    • Ping Linked Servers From Agent Job
    13th

    Database Weekly

      14th
      15th

      SQLServerCentral Newsletter

      • Adding a Query Governor to Dynamic-Search Stored Procedures
      • Debugging Natively-Compiled Stored Procedures Statements
      • Drop and Recreate
      • Investigate Report Server Security
      16th

      SQLServerCentral Newsletter

      • Tribal Awards Finalists
      • What To Do When the Import and Export Wizard Fails - Part II Exports
      • SQL Server Reporting Services Basics: The Visual Controls
      • Go Small
      • Finding Data Islands
      17th

      SQLServerCentral Newsletter

      • Introduction to Azure SQL Database Scalability
      • Free eBook: Understanding SQL Server Concurrency
      • Stairway to Advanced T-SQL Level 1: Introduction to Advanced Transact SQL Stairway and Using the CROSS JOIN Operator
      • Byte Me: Yule Log On
      • Fibonacci Series in TSQL
      18th

      SQLServerCentral Newsletter

      • Questions About T-SQL Transaction Isolation Levels You Were Too Shy to Ask
      • GUIDs GUIDs everywhere, but how is my data unique?
      • Deleting Data
      • Extracting only Deadlock details from ErrorLog.
      19th

      SQLServerCentral Newsletter

      • SQL Server Analysis Services Attribute Relationships
      • What, when and who? Auditing 101 - Part 3
      • The Wish List
      • DB memory/RAM consumption
      20th

      Database Weekly

        21st
        22nd

        SQLServerCentral Newsletter

        • Using the MERGE Statement to Perform an UPSERT
        • Linked lists
        • Kitchen Culture
        • Convert datetime to bigint
        23rd

        SQLServerCentral Newsletter

        • Practical PowerShell Unit-Testing: Mock Objects
        • The Big Database Freeze
        • Dealing with the Evil of FMTONLY from SSRS
        • We Want Maturity, But Is It Fun?
        • PowerShell Query to remove backup folders against multiple servers
        24th

        SQLServerCentral Newsletter

        • Stairway to PowerPivot and DAX - Level 6: The DAX SUM() and SUMX() Functions
        • SQL Server Data Aggregation for Data with Different Sampling Rates
        • Free eBook: SQL Server Hardware
        • ‘Twas the night before the upgrade…
        • Unused Procedure lists - Most easiest way
        25th

        SQLServerCentral Newsletter

        • SQL Brainteasers: Guess the Christmas Carol/Song
        • 15 Quick Short Interview Questions Useful When Hiring SQL Developers
        • Merry Christmas 2014 and Happy Holidays
        • split string between 2 patterns
        26th

        SQLServerCentral Newsletter

        • Parsing HTML to SQL using SQLDOM
        • Getting Started with HDInsight - Part 2 - Introduction to Azure HDInsight PowerShell
        • The Rich Rewards of Tuning SQL
        • PatExclude8K
        27th
        28th
        29th
        30th
        31st
        Previous month