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: August 2012

Find month: Show current month
SunMonTueWedThuFriSat
1st

SQLServerCentral Newsletter

  • PowerShell SMO: Just Writing Things Once
  • Utilize SQL Server Storage Effectively
  • SQL Saturday #161 - East Iowa
  • How to Make Scalar UDFs Run Faster (SQL Spackle)
  • Out of the Frying Pan Into the Fire
  • Create_sp_help_revlogin_DB
2nd

SQLServerCentral Newsletter

  • Issues Determining an Individual SQL Server User's Permissions
  • An Alternative (Better?) Method to UNPIVOT (SQL Spackle)
  • The 2012 SQLServerCentral/Exceptional DBA Awards Party at the PASS Summit
  • No Limits
  • Padding function
3rd

SQLServerCentral Newsletter

  • RegexClean Transformation
  • Targeted Index Performance Improvements
  • The Copy Cat Poll
  • BackUp_DBs.sql
4th
5th

Database Weekly

    6th

    SQLServerCentral Newsletter

    • How to Audit Login Changes on a SQL Server
    • Pushing SQL Alerts to Remote Server using PowerShell 2 and T-SQL
    • SQL Saturday #154 | St.Louis, MO
    • Code Reviews Must Be Brutally Honest
    7th

    SQLServerCentral Newsletter

    • Optimizing tempdb configuration with SQL Server 2012 Extended Events
    • Display data by fiscal year instead of calendar year
    • Utilize SQL Server Storage Effectively
    • SQL Saturday #162 - Cambridge, UK
    • Stupid Interviewer Tricks
    • Count of Objects by Database on a Server
    8th

    SQLServerCentral Newsletter

    • SQL Saturday #164 - Cleveland
    • Working with SSIS Data Types
    • Stairway to SQL PowerShell Level 1: SQL PowerShell Basics
    • The 2012 SQLServerCentral/Exceptional DBA Awards Party at the PASS Summit
    • Wiggle Room
    • Calculate alphabetic sequence
    9th

    SQLServerCentral Newsletter

    • SQL Server 2012’s Information on Parallel Thread Usage
    • SQL Saturday #167 - Columbus, GA
    • Removing the SQL Server Management Data Warehouse
    • A Data Hub
    • 2008 Index Rebuild using DMV
    10th

    SQLServerCentral Newsletter

    • Regular Expression Transformation
    • TDE Setup and Administration Scripts
    • Separate Accounts
    • Print The Calendar 2
    11th
    12th

    Database Weekly

      13th

      SQLServerCentral Newsletter

      • Tell Us What You Think
      • Using DELETE CASCADE Option for Foreign Keys
      • SQL Saturday #156 - Providence, RI
      • Using the Konesans File Watcher Task in SSIS to Process Data Files
      • No Limits
      • List of objects from particular schemas
      14th

      SQLServerCentral Newsletter

      • 11 Tips to Backup databases with SMO, VB, C# Powershell, Command lines
      • Utilize SQL Server Storage Effectively
      • Getting Started with Master Data Services (MDS) In SQL Server 2012
      • SQL Saturday #170 - Munich, Germany
      • Milk
      • Script to get an ordered list of all stored procedures with parameters
      15th

      SQLServerCentral Newsletter

      • Stairway to SQL PowerShell Level 2: SQL PowerShell Setup and Config
      • PASS Data Architecture VC presents Louis Davidson on Designing for Common Problems in SQL Server
      • Red Gate’s new custom metrics site - with a little help from our friends
      • Implement Continuous Integration In Your Software Project
      • SQL Saturday #157 - San Diego
      • Learning C
      • Unattended Install with PowerShell
      16th

      SQLServerCentral Newsletter

      • TDE and SQL Server Databases
      • SQL Server 2012 Integration Services - Using dtexec.exe to Run File System-based Packages
      • Marketing Data is Exploding
      • Trim Left Char (for single words)
      17th

      SQLServerCentral Newsletter

      • Row Count Plus Transformation
      • REPLACE Multiple Spaces with One
      • Tell Us What You Think
      • The Influence of the Cloud
      • Defragment all indexes on Database
      18th
      19th

      Database Weekly

        20th

        SQLServerCentral Newsletter

        • Enforce business rules with indexed views and a two-row table
        • SQL Saturday #155 - Lima
        • SSIS Basics: Introducing Variables
        • The 2012 SQLServerCentral/Exceptional DBA Awards Party at the PASS Summit
        • Time Off
        • Display Names and Locations of SQL Database Files and DB Owners
        21st

        SQLServerCentral Newsletter

        • SQL Saturday #169 - Denver
        • Red Gate Software announces speaker line up for US SQL in the City tour
        • How To Support Multiple SQL Server Package Configurations in SSIS
        • Hierarchies in SQL, Part II, the Sequel
        • Big Data Jobs
        • Identify Unique Columns
        22nd

        SQLServerCentral Newsletter

        • Stairway to T-SQL DML Level 8: Using the ROLLUP, CUBE and GROUPING SET operator in a GROUP BY Clause
        • SQLSaturday #160 - Kalamazoo
        • Row Number Transformation
        • Make a Backup First
        • Calculate Easter Date
        23rd

        SQLServerCentral Newsletter

        • Working with SQL Agent Durations
        • Provisioning a New SQL Server Instance – Part Two
        • SQL in the City - New York 2012
        • Being Exceptional
        • Drop a table and views
        24th

        SQLServerCentral Newsletter

        • Stairway to MDX - Level 2: The Ordinal Function
        • Solving the SQL Server Multiple Cascade Path Issue with a Trigger
        • SQL in Boston -- Red Gate Style
        • Fix v. Create
        • Get dependant Objects
        25th

        Database Weekly

          26th
          27th

          SQLServerCentral Newsletter

          • SQL Saturday #162 - Cambridge, UK
          • Stairway to Database Design Level 1: Data Elements
          • Practical PowerShell for SQL Server Developers and DBAs – Part 1
          • SQL in the City - Austin 2012
          • Ten Million Lines of Code
          • SSRS Execution Log Queries
          28th

          SQLServerCentral Newsletter

          • AlwaysOn Availability Groups in SQL Server 2012
          • SQL Saturday #167 - Columbus, GA
          • Export images from a SQL Server Table to a Folder with SSIS
          • Shadow IT
          • A simple way to find some arguments
          29th

          SQLServerCentral Newsletter

          • Stairway to SQL PowerShell Level 3: Input and Output with PowerShell
          • SQL in the City - San Francisco 2012
          • The Seven Sins against T-SQL Performance
          • Watch Your Mouth
          • How to calculate the check digit for a UCC/EAN code
          30th

          SQLServerCentral Newsletter

          • Using nmap to scan for SQL Servers on a network
          • Creating a heat map in Reporting Services
          • SQL in the City - Chicago 2012
          • The Personal Checksum
          • Insertion Query Creation of a Table in Milliseconds
          31st

          SQLServerCentral Newsletter

          • Why is my transaction log full?
          • AlwaysOn Architecture Guide: Building a High Availability and Disaster Recovery Solution by Using AlwaysOn Availability Groups
          • SQL in the City - Boston 2012
          • Finding a Balance
          • Job Running time/Interval precentage
          Previous month