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: January 2015

Find month:
SunMonTueWedThuFriSat
1st

SQLServerCentral Newsletter

  • Getting Started with HDInsight - Part 3 - Creating an HDInsight Cluster in Microsoft Azure Cloud
  • A Beginners Look at Hadoop
  • Byte Me: Out With the Old
  • Calculate Mass/Weight - Most Advanced UOC
2nd

SQLServerCentral Newsletter

  • Creating a heat map in Reporting Services
  • High Availability and Disaster Recovery for Small Businesses
  • Growing Your SQL Server Skills without Breaking the Bank
  • What's Coming True?
  • Calculate Area - Most Advanced UOC
3rd

Database Weekly

    4th
    5th

    SQLServerCentral Newsletter

    • Adding an Article Without a Full Snapshot
    • Salesforce: A Very Straightforward Cloud Development Platform
    • Staying Successful
    • Dynamic Script to Generate RESTORE DATABASE Script
    6th

    SQLServerCentral Newsletter

    • Scrubbing Personally Identifiable Information
    • SQL Monitor Custom Metric: Identity Columns Near Limit
    • Add a linear trendline to a graph in SQL Server Reporting Services
    • Recovering from Bad Deployments
    • Calculate Angle - Most Advanced UOC
    7th

    SQLServerCentral Newsletter

    • Free eBook: Fundamentals of SQL Server 2012 Replication
    • Stairway to PowerPivot and DAX - Level 8: Function / Iterator Function Pairs: The DAX COUNT() and COUNTX() Functions
    • Importance of Statistics and How It Works in SQL Server – Part 1
    • Test Your Situation
    • Calendar Table Function
    8th

    SQLServerCentral Newsletter

    • Installing tSQLt
    • Archiving Hierarchical, Deleted Transaction Using XML
    • Two Days Off
    • Find no of records in each table in database (against Clustered Index)
    9th

    SQLServerCentral Newsletter

    • Backing up your SQL Server to Amazon's Cloud in Three Easy Steps
    • Using EXCEPT to Determine Row Differences
    • Multiple Backup Files
    • Calculate Temperature - Most Advanced UOC
    10th

    Database Weekly

      11th
      12th

      SQLServerCentral Newsletter

      • SQL Prompt Tips #5 - Current Statement Execution
      • SQL Server PCI DSS Security Patching Checklist
      • Top 5 things you MUST know about PowerPivot for Excel
      • Selling Automation to Ops
      • Verify Login SID and Machine SID
      13th

      SQLServerCentral Newsletter

      • Exploring Query Plans in SQL
      • Dynamically Create Tables Based on an Access Table
      • Testing
      • Migrate existing DB Mail Exchange Configuration with New
      14th

      SQLServerCentral Newsletter

      • Stairway to PowerPivot and DAX - Level 9: Function / Iterator Function Pairs: The DAX MAX() and MAXX() Functions
      • Options to Improve SQL Server Bulk Load Performance
      • Free eBook: SQL Server Backup and Restore
      • Hadoop and SQL Server
      • Find Deny permissions on database objects
      15th

      SQLServerCentral Newsletter

      • Data Cleaning in SQL 2012 with Data Quality Services
      • Prevent sp_ Procedures with SQLCop
      • A Little Empathy
      • Automatic restore database to different server from backup file
      16th

      SQLServerCentral Newsletter

      • Improving Performance for Some LIKE “%string%” Searches (SQL Spackle)
      • Returning Sorted Record Sets Using the ORDER BY Clause
      • Debugging SQL Server
      • Function for String Occurences Count
      17th

      Database Weekly

        18th
        19th

        SQLServerCentral Newsletter

        • Questions About Pivoting Data in SQL Server You Were Too Shy to Ask
        • Untrusted Foreign Keys with NOT FOR REPLICATION Option on the Key
        • Taking Care of Things Today
        • Calculate Time - Most Advanced UOC
        20th

        SQLServerCentral Newsletter

        • Move Database Files for a SQL Server Mirrored Database Without Impacting Database Mirroring
        • SQL Prompt Tip #6 - Insert Semicolons
        • A Standard Database Security Script Generator
        • The Cost of Switching
        • Stupid Coding Tricks: The T-SQL Mandelbrot
        21st

        SQLServerCentral Newsletter

        • A Custom Execution Method – Level 19 of the Stairway to Integration Services
        • SQL Server Reporting Services Basics: Deploying Reports
        • Tribal Awards 2014 Winners
        • Free eBook: SQL Server Transaction Log Management
        • R-E-S-P-E-C-T
        • Copy Latest Backups from Backup Path
        22nd

        SQLServerCentral Newsletter

        • SQL Monitor Custom Metric: Percentage of Fragmented Indexes
        • Tracking Database DDL Changes with SQLVer
        • Azure SQL Database Auditing
        • Getting IT Out of the Data Center
        • Real World: SQL Server Quick Quality Check for DBA's.
        23rd

        SQLServerCentral Newsletter

        • Going to Extremes to Release Bug Fixes and New Features
        • Removing Duplicates
        • Webinar: Oracle Exadata & In-Memory Real-World Performance
        • Custom SSMS
        • Calculate Power - Most Advanced UOC
        24th

        Database Weekly

          25th
          26th

          SQLServerCentral Newsletter

          • Selecting from sub-queries as tables
          • SQL Prompt Tip #7 - Begin End Highlighting
          • Discrete and Continuous Data in SQL
          • Deploy the Database First
          • Script to remove Backup Files except Recent One for Same Day
          27th

          SQLServerCentral Newsletter

          • Finding Encrypted Data in a SQL Server Database
          • Data Mining Part 23: Security
          • Grant Fritchey Reviews Minion Reindex
          • Time for Learning
          • Update Statistics for databases where you have access
          28th

          SQLServerCentral Newsletter

          • Stairway to Advanced T-SQL Level 2: Using the APPLY Operator
          • Why Developers Need to Understand Execution Plans
          • Free eBook: Performance Tuning with SQL Server Dynamic Management Views
          • Normal Data
          • Find Null values on every column
          29th

          SQLServerCentral Newsletter

          • Database ownership and TRUSTWORTHY
          • Using T-SQL to Perform Z-Score Column Normalization in SQL Server
          • You Better Learn to Work at Scale
          • Alter database owner to SA from any user details on all user databases
          30th

          SQLServerCentral Newsletter

          • Using a column name in a COUNT function
          • How to get ETL Horribly Wrong
          • Too Large a Workload?
          • Calculate Volume - Most Advanced UOC
          31st

          Database Weekly

            Previous month