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 2013

Find month: Show current month
SunMonTueWedThuFriSat
1st

SQLServerCentral Newsletter

  • Throttle a Query in Mid-Execution
  • TSQL Pivot Rotations using only REPLACE
  • Mo-SQL
  • Google Glass Your Database
  • Create Table with T-SQL
2nd

SQLServerCentral Newsletter

  • Blocking SQL Server db_datareader, db_datawriter, and db_owner Permissions
  • Low Profile Architecture
  • SQL Saturday #203 - Boston
  • Salaries in 2013
  • Who has accessed my 2005 server?
3rd

SQLServerCentral Newsletter

  • Join Reordering and Bushy Plans
  • Expand Your Skills at the PASS Business Analytics Conference
  • A Hazard of Using the SQL Merge Statement
  • Data Darwinism
  • Copy Table
4th

SQLServerCentral Newsletter

  • SQL Server 2012 Window Function Basics
  • Error logging with Bulk Insert
  • SQL Saturday #211 - Chicago
  • Development, Operations, or Accounting
  • How To Check SQL SERVER Uptime Through T-SQL
5th

SQLServerCentral Newsletter

  • Generating Sequence Numbers Using the Sequence Object
  • Stairway to SQL Server Indexes: Level 1, Introduction to Indexes
  • New Custom Metric: Long Running Job
  • Insensitivity: A Good Technique?
  • Automate Test Database Restoration
6th

Database Weekly

    7th
    8th

    SQLServerCentral Newsletter

    • A Simple Formula to Calculate the ISO Week Number
    • SQL Saturday #189 - Costa Rica
    • SQL Server JOIN Hints
    • Double Compliance
    • Rename Foreign Key Constraints
    9th

    SQLServerCentral Newsletter

    • Automating SQL Server Database Deployments: A Worked Example
    • Tune SQL Server 2012 Databases Using Database Engine Tuning Advisor
    • Driving Value
    • Scripting SQL Agents Jobs using Powershell
    10th

    SQLServerCentral Newsletter

    • Using Policy Based Management for checking SQL Server database file extensions
    • New and Basic Result-set Paging functionality in SQL 2012 Version.
    • SSIS Deployments
    • The IT Employee Benchmark
    • Run SQL code on each database
    11th

    SQLServerCentral Newsletter

    • SSIS Deployments
    • Partitioning in SQL Server: Managing Sliding Window Scenario
    • Tracking Business Metrics
    • Don't Accept Defaults
    • Retrieve SQL Instance Connect Info
    12th

    SQLServerCentral Newsletter

    • dbWarden - A Free SQL Server Monitoring Package
    • Comparing Multiple Rows Insert vs Single Row Insert with Three Data Load Methods
    • Do you regularly run queries and scripts in SSMS?
    • The DBA Office
    • Find the position of all occurrences of an expression within a string
    13th
    14th

    Database Weekly

      15th

      SQLServerCentral Newsletter

      • Data mining introduction part 4: the Naïve Bayes algorithm
      • Managing SQL Server Statistics
      • Modeling the Earth
      • Search for an object across multiple databases on a server.
      16th

      SQLServerCentral Newsletter

      • SQL Server Central Webinar Series #23: Safeguard your data offsite with SQL Backup Pro
      • T-SQL Coding Style
      • The Cascading (CROSS) APPLY
      • Don't Be a Ghost
      • Restore Latest Backup with Powershell
      17th

      SQLServerCentral Newsletter

      • Stairway to Transaction Log Management in SQL Server Level, 8: Optimizing Log Throughput
      • Configure SQL Server 2012 AlwaysOn Availability Groups Read-Only Routing using PowerShell
      • The Patch Wild, Wild West
      • Generate N numbers
      18th

      SQLServerCentral Newsletter

      • The Elusive Conditional WHERE Clause
      • Disaster Recovery in the Enterprise – Paying the Price to Avoid Extra Costs
      • SQL Server 2012 Build List
      • Asking for Interview Questions
      • Get Database Backup Details on SQL Server
      19th

      SQLServerCentral Newsletter

      • SQL Server Central Webinar Series #23: Safeguard your data offsite with SQL Backup Pro
      • Comparison of Queries Written in T-SQL and SQL Server MDX
      • SQL Server 2008 R2 Build List
      • Using Regular Expressions to Convert PL/SQL code to T-SQL
      • Upgrading to 2012
      • Script to find the total used size of all database inside SQL Server
      20th
      21st

      Database Weekly

        22nd

        SQLServerCentral Newsletter

        • Diagnosing Common Database Ails
        • Stay Backed Up by Monitoring Your Backup Process
        • A Billion Transactions
        • fnArabToEnglish(from Arabian number to english)
        23rd

        SQLServerCentral Newsletter

        • Using FULL JOINs to Compare Datasets
        • SQL Server Trace Flags
        • SQL Server Central Webinar Series #23: Safeguard your data offsite with SQL Backup Pro
        • Accelerating Your Career
        • Check Candidate Columns for FOREIGN KEY Constraints
        24th

        SQLServerCentral Newsletter

        • Custom Metrics for Monitoring Database Mirroring
        • Stairway to Transaction Log Management in SQL Server, Level 9: Monitoring the Transaction Log
        • Natural Data
        • List of Stored Procedures modified in past 7 days
        25th

        SQLServerCentral Newsletter

        • Solving Complex T-SQL Problems, Step-By-Step
        • Find the Currently Running Scheduled Job
        • Flight Data
        • String Character Count
        26th

        SQLServerCentral Newsletter

        • Registration is open for SQL Relay
        • A Check and Foreign Key Constraint Improves Query Performance
        • Unpack an Integer with SQL Server Recursion
        • The Vacation Dilemma
        • Change DB Owner to sa for multiple DB's
        27th
        28th

        Database Weekly

          29th

          SQLServerCentral Newsletter

          • SQL Server 2012 Integration Services - Using PowerShell to Configure Package Execution Parameters
          • SQL Saturday #209 - Rochester
          • Parallel Processing Using Jobs
          • Factivism
          • Script to find username and corresponding loginname for all user DB
          30th

          SQLServerCentral Newsletter

          • Managing the SQL Server Transaction Log: Dealing with Explosive Log Growth
          • Ordered Loading of Databases Tables Using SSIS
          • Most important DBA Skill?
          • PowerShell to Pre-Create domain objects for SQL Server Cluster
          Previous month