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

Find month: Show current month
SunMonTueWedThuFriSat
1st

SQLServerCentral Newsletter

  • SQL Server 2014 Has Been Released
  • Limited Time Offer: Licensing by Scale for SQL Server
  • Native C# in Stored Procedures
  • Telepresence
  • Script out passwords
2nd

SQLServerCentral Newsletter

  • DEVintersection: Developers, ITHeros, Industry-experts Intersect Here!
  • Free eBook: SQL Server Execution Plans, Second Edition
  • The Girl with the Backup Tattoo
  • Stairway to T-SQL: Beyond The Basics Level 5: Storing Data in Temporary Tables
  • Byte Me: Programming Language
  • Get the all user and their server role
3rd

SQLServerCentral Newsletter

  • How to recover a suspect msdb database in SQL Server
  • SQL Server 2012 AlwaysOn Groups and FCIs Part 3
  • Data Science Laboratory System - Distributed File Databases
  • The Internet of Things
  • IndexInformation
4th

SQLServerCentral Newsletter

  • Getting Started in SQL Server
  • SQL Monitor Custom Metric: Server principals with default database offline
  • High Performance Relational Division in SQL Server
  • Team Reputation
  • Quick snapshot
5th

Database Weekly

    6th
    7th

    SQLServerCentral Newsletter

    • Load Testing in a Big Data Environment
    • Improving Performance for Some LIKE “%string%” Searches (SQL Spackle)
    • Data Security Policies
    • Identify Column Data Types
    8th

    SQLServerCentral Newsletter

    • Divide and Conquer - Performance Tuning
    • SQL Saturday #289 - Orange County, CA
    • 14 SQL Server Indexing Questions You Were Too Shy To Ask
    • Lobbying for Change
    • Generate script to rebuild indexes in a database
    9th

    SQLServerCentral Newsletter

    • How much overhead does encryption add to a SQL Server query
    • Stairway to T-SQL: Beyond The Basics Level 6: Using the CASE Expression and IIF Function
    • Free eBook: Understanding SQL Server Concurrency
    • Problems with Big Data
    • Find dependencies between field and sp/function
    10th

    SQLServerCentral Newsletter

    • Managing SQL Server Services with PowerShell
    • How to create an SSIS conditional data flow task
    • Write for SQLServerCentral
    • If or When?
    • Get the Column level difference for 2 database
    11th

    SQLServerCentral Newsletter

    • The DBA Detective: Disturbing Developments
    • SQL Saturday #285 Atlanta
    • Paging Doctor Powershell
    • How Long Before You Upgrade?
    • Index Breakdown
    12th

    Database Weekly

      13th
      14th

      SQLServerCentral Newsletter

      • SQL Server Reporting Services Embedding .NET Code for Report Formatting and Error Handling
      • SQL Server 2014 Key Features and Enhancements
      • Big Data - Cost of acquiring skills
      • Insert Generator - Stored Procedure
      15th

      SQLServerCentral Newsletter

      • SQL Server Backup Crib Sheet
      • SQL Monitor Custom Metric: Table size (MB)
      • Why every SQL Server installation should be a cluster
      • Doing What It Takes To Get The Job Done
      • Script move of DB files from one location to another
      16th

      SQLServerCentral Newsletter

      • Stairway to SQL Server Agent - Level 9: Understanding Jobs and Security
      • Free eBook: SQL Server Hardware
      • SQL Server 2014 In-Memory OLTP Dynamic Management Views
      • Byte Me: For Every Lock
      • Search objects in Database
      17th

      SQLServerCentral Newsletter

      • Explaining the Calculations of Probability and Importance for Complex Association Rules in SSAS
      • Call for participants in deployment process research
      • XML Schema validation in SQL Server
      • One Database to Rule Them All
      • Dynamic table unpivot
      18th

      SQLServerCentral Newsletter

      • SQL Saturday #305: Dallas, BA Edition
      • Unexpected View Performance
      • SQL Server Performance Tuning Using Wait Statistics: A Beginner's Guide
      • Advice for Newcomers
      • Get the defination of all table type in database
      19th

      Database Weekly

        20th
        21st

        SQLServerCentral Newsletter

        • Monitoring SQL Server: An Interview with David Bick
        • SQL Saturday #308 - Houston, TX
        • Automating Database Restores
        • Consolidation Matters
        • backup, differental and transactions
        22nd

        SQLServerCentral Newsletter

        • Partitioning Data in a Multi-tenant Data Warehouse Solution
        • Microsoft Azure SQL Database Security - Firewall Configuration
        • Open Call for Editorials
        • Due Diligence
        • The dynamic unpivoter.
        23rd

        SQLServerCentral Newsletter

        • Database Normalization Basics
        • Stairway to Database Source Control Level 1: Setting Up For Database Source Control
        • Free eBook: Troubleshooting SQL Server: A Guide for the Accidental DBA
        • Open Source the MCM
        • Restore script genrator for moving dbs
        24th

        SQLServerCentral Newsletter

        • XML Workshop : Utilizing Relational Data In XML Files
        • Prevent multiple users from running the same SQL Server stored procedure at the same time
        • Good Practices for Software Development
        • Count all records the tables
        25th

        SQLServerCentral Newsletter

        • PowerShell One-Liners: Help, Syntax, Display and Files
        • Oiling the gears for the data dictionary
        • The Reading Poll
        • Script to Generate Table to Stored Procedure Cross References
        26th

        Database Weekly

          27th
          28th

          SQLServerCentral Newsletter

          • SQL Saturday #308 - Houston, TX
          • Big Data Quality Metrics
          • Percentile calculations in DAX
          • The Danger of Algorithms
          • Exporting data with header using Powershell
          29th

          SQLServerCentral Newsletter

          • Duplicate Detection and Management
          • Moving from Practice to Production with Test-Driven Development
          • The Subtle Push to the Cloud
          • Format decimal value to fraction using a tally table.
          30th

          SQLServerCentral Newsletter

          • Options to Move a Big SQL Server Database to a New Drive with Minimal Downtime
          • Free eBook: Fundamentals of SQL Server 2012 Replication
          • Stairway to SQL PowerShell Level 6: PowerShell Modules
          • Byte Me: Cubical Life
          • SQL Server Backup, Integrity Check, Index and Statistics Maintenance
          Previous month