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

Find month: Show current month
SunMonTueWedThuFriSat
1st

Database Weekly

    2nd

    SQLServerCentral Newsletter

    • Using the WMI Event Watcher Task in SSIS to Process Data Files
    • Using a PowerShell Script to delete old files for SQL Server
    • Security and Honesty
    • Make a list of all tables in all data bases with creation date
    3rd

    SQLServerCentral Newsletter

    • Email Job Failures Report to DBA using PowerShell
    • Generating Non-uniform Random Numbers with SQL
    • SQL Server Central Webinar Series #20: Using SQL Storage Compress in the Real World
    • Fix Failures Fast
    • Delete old backup
    4th

    SQLServerCentral Newsletter

    • Indexes, Indexes, Indexes
    • Happy Fourth of July 2012
    • TSQL Challenge 81 - Create a Game schedule generator in TSQL
    • Happy Fourth of July 2012
    • Remove comments from the SQL Code
    5th

    SQLServerCentral Newsletter

    • Steps to clean up orphaned replication settings in SQL Server
    • Advanced SSIS Fuzzy Matching via Record Linkage Methodology
    • SQL Server Central Webinar Series #20: Using SQL Storage Compress in the Real World
    • Clouds, Costs, and Data Analytics
    • Check connect to all linkeds
    6th

    SQLServerCentral Newsletter

    • Trash Destination Adapter
    • Free Webinar: Monitoring your business, not just your servers – Getting the most out of SQL Monitor
    • Introduction to Indexes: Part 2 – The clustered index
    • Starting to Program
    • Create Normalised Databases with Powershell
    7th

    Database Weekly

      8th
      9th

      SQLServerCentral Newsletter

      • Turbocharge Your Database Maintenance With Service Broker: Part 1
      • Software Developer Survey
      • SQL Server 2012 Integration Services- Using Environments in Package Execution
      • The DBA Tax
      • Finding Top N worst performaing queries
      10th

      SQLServerCentral Newsletter

      • Troubleshooting SQL Server with PowerShell - Virtual Chapter Meeting
      • Views and Dependencies
      • Handling Constraint Violations and Errors in SQL Server
      • SQL Server Central Webinar Series #20: Using SQL Storage Compress in the Real World
      • Hard Data v Gut Feel
      • Issue with Current Merge Join algorithm and ways to Improve it
      11th

      SQLServerCentral Newsletter

      • Free Webinar: Monitoring your business, not just your servers – Getting the most out of SQL Monitor
      • Is it time to move from SQL Azure to Amazon RDS SQL Server?
      • SQL Server Report Server 2008 R2 Execution Log Reports
      • Why It's Good To Be Wrong
      • Check Used Table Space for User Defined Tables
      12th

      SQLServerCentral Newsletter

      • The PoSh DBA - The Attributes of Advanced Functions
      • SQL Triggers in a Security Context
      • Do you work with data to support organizational decisions?
      • One Single View
      • TopBlocker
      13th

      SQLServerCentral Newsletter

      • Comparing Two Recordsets Using Powershell
      • File Watcher Task
      • SQL Server 2012 Database Recovery Advisor: Simplified Point in Time Recovery
      • Kill a SPID
      • Set Database to Single user
      14th
      15th

      Database Weekly

        16th

        SQLServerCentral Newsletter

        • Storage - A meeting of minds
        • Provisioning a New SQL Server Instance
        • A Cool Job
        • Function to Split Multivalued Parameter
        17th

        SQLServerCentral Newsletter

        • Implementing SQL Server's Change Data Capture
        • Exploring Recursive CTEs by Example
        • Time Zones
        • Using DDL Trigger
        18th

        SQLServerCentral Newsletter

        • Checksum Transformation
        • Basic SSIS Workflow Management – Level 6 of the Stairway to Integration Services
        • SQL Server 2008 Build List
        • Geeky Books
        • Computer Name from SQL Server
        19th

        SQLServerCentral Newsletter

        • Single User Performance of SQLite v. SQL Server
        • SSIS Basics: Adding Data Flow to Your Package
        • How To Write An Interview Winning Resume
        • Using Technology In New Ways
        • get all values separated by commas
        20th

        SQLServerCentral Newsletter

        • Creating a Custom Report Template in SSRS
        • Free Webinar: Monitoring your business, not just your servers – Getting the most out of SQL Monitor
        • Map IP Address to a Geographical Location
        • Stack Ranking
        • BussinesDaysToCalendarDays
        21st
        22nd

        Database Weekly

          23rd

          SQLServerCentral Newsletter

          • Introduction to Indexes: Part 3 – The nonclustered index
          • Developing Low-Maintenance Databases
          • SQL Saturday #150 - Baton Rouge
          • Security is Improving
          • BusinessDaysToCalendarDays (For Unusual Business Weeks)
          24th

          SQLServerCentral Newsletter

          • Free Webinar: Monitoring your business, not just your servers – Getting the most out of SQL Monitor
          • Process to truncate transaction log of replicated database
          • SQL Saturday #159 - Kansas City
          • Implementing SQL Server's Change Data Capture
          • Leveling the Field
          • Finding Unused Database Roles
          25th

          SQLServerCentral Newsletter

          • Help Red Gate create a new monitoring tool
          • Managing SQL Server Extended Events in Management Studio
          • PASS Data Architecture VC presents Ami Levin on Where Are My (Primary) Keys?
          • Intermediate SSIS Workflow Management – Level 7 of the Stairway to Integration Services
          • A Really Good Job
          • Get String between two delimiters
          26th
          27th

          SQLServerCentral Newsletter

          • Summarizing Imported Data
          • Data Generator Source Adapter
          • Stairway to MDX - Level 1: Getting Started with MDX
          • Performance Data
          • SQL Agent Job schedule details
          28th
          29th

          Database Weekly

            30th

            SQLServerCentral Newsletter

            • Track source dates when loading a data warehouse
            • An Introduction to SQL Server Service Broker
            • Better Bosses Needed
            • any order max, min in simple way
            31st

            SQLServerCentral Newsletter

            • Implement Continuous Integration In Your Software Project
            • Set Up Grouping Intervals for Excel (SQL Spackle)
            • The DBA Database
            • 2005 Online Index Rebuild using DMV
            Previous month