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 2013

Find month: Show current month
SunMonTueWedThuFriSat
1st

SQLServerCentral Newsletter

  • SQL Server CREATE TABLE syntax diagrams
  • xp_cmdshell for Non-System Admin Individuals
  • Log Shipping Lite with PowerShell
  • Give
  • To remove the specified Characters in the Given String
2nd

SQLServerCentral Newsletter

  • A New Look
  • SQL Saturday #214 Louisville KY
  • Change the Maintenance Plan Owner
  • Performance Tuning in the Age of Big Data
  • The Intrusion of Life
  • Free space for all database files
3rd

SQLServerCentral Newsletter

  • Stairway to Database Design Level 1: Data Elements
  • SQL Server Central Webinar Series #24: Prepare for When Disaster Strikes
  • Comparing Data Warehouse Design Methodologies for Microsoft SQL Server
  • Who's Got Your Data?
  • FileNameSplitter
4th

SQLServerCentral Newsletter

  • Don Knuth and the Art of Computer Programming: The Interview
  • Why SQL Server 2012 needs Windows Server 2012
  • Independence Day 2013
  • Huge varbinary or image to hex string
5th

SQLServerCentral Newsletter

  • SQL Saturday #230 Rheinland
  • Column Order in an Index
  • SQL Server 2012 Integration Services - Leveraging PowerShell in Package Deployment Model
  • SQL Server Trace Flags
  • A Better Conference
  • Job and Step Run Checker
6th

Database Weekly

    7th
    8th

    SQLServerCentral Newsletter

    • A simple trick for “Block Comment” syntax in SSMS
    • New SQL Monitor Custom Metric: Untrusted Check Constraints
    • Exploring In-memory OLTP Engine (Hekaton) in SQL Server 2014 CTP1
    • Your Frame of Reference
    • Changing database mail account SMTP servers
    9th

    SQLServerCentral Newsletter

    • Using a Recursive CTE to Generate a List
    • Identify and Correct SQL Server Forwarded Records
    • SQL Saturday #230 Rheinland
    • Reporting on Data
    • usp_addcolumns
    10th

    SQLServerCentral Newsletter

    • An Automated Process to Archive Big Tables
    • Understanding SQL Server Query Optimization Statistics
    • Programming
    • Get all fields names for all tables in SQL
    11th

    SQLServerCentral Newsletter

    • SQL Server: How Important Are Index Statistics
    • How to Post Performance Problems
    • Dynamically Truncate a Partitioned Table
    • Hiring Guitarists
    • Show Database and Log sizes, free space and location
    12th

    SQLServerCentral Newsletter

    • Security for SQL Server User Defined Data Types
    • Sending E-Mail from SQL 2008 Express
    • The Vacation Struggle
    • Simple and efficient way to split string with seperator
    13th

    Database Weekly

      14th
      15th

      SQLServerCentral Newsletter

      • Parameter Sniffing and Sniffing Memory
      • Using DAX to retrieve tabular data
      • The Desktop
      • List orphaned users from all databases
      16th

      SQLServerCentral Newsletter

      • SQL Saturday #231 Cocoa Beach
      • Orphaned Distribution Transactions
      • SQL Server Central Webinar Series #24: Prepare for When Disaster Strikes
      • Encrypting and Decrypting SQL Server Stored Procedures, Views and User-Defined Functions
      • Hack Resistant?
      • Long Running Jobs Monitor
      17th

      SQLServerCentral Newsletter

      • SQL Saturday #222
      • Biml Workshop presented by Varigence and Linchpin People
      • Free eBook: Understanding SQL Server Concurrency
      • SQL Server Transactions and Locking – Part 2
      • What is Biml? - Level 1
      • Data Philanthropy
      • The Automated DBA: Space Usage Snapshotter (sysadmin; central DB)
      18th

      SQLServerCentral Newsletter

      • Resolving Errors While Connecting to SSIS
      • How To Document Your PowerShell Library
      • SQL in the City Seminar Sacramento 2013
      • SQL Saturday #239 East Iowa
      • Password Ninjas
      • Quick view of User database and server roles
      19th

      SQLServerCentral Newsletter

      • New Resource: LearnSomeSQL.com
      • Formatting Dates with 3 Character Months (SQL Spackle)
      • SQL Saturday #234 Baton Rouge, LA
      • Telemetry basics and troubleshooting
      • Disaster Recovery Tip #4 - Learn about partial restores!
      • DR Failovers
      • Find Default Data and Log File Paths
      20th

      Database Weekly

        21st
        22nd

        SQLServerCentral Newsletter

        • SQL Server 2012 Analysis Services XMLA
        • Tables and Clustered Indexes Part 2
        • SQL Monitor Custom Metric: Top Buffer Cache Object
        • Hiring Heterogeneously
        • View Deadlock Graphs
        23rd

        SQLServerCentral Newsletter

        • SQL Server Central Webinar Series #24: Prepare for When Disaster Strikes
        • What’s going on, on my server, right now?
        • Are my actual worker threads exceeding the sp_configure 'max worker threads' value?
        • Survey: Understanding SQL Code
        • The Agile Cult
        • Virtual tally table function
        24th

        SQLServerCentral Newsletter

        • SQL Saturday #236 St Louis, MO
        • Stairway to Server-side Tracing - Level 3: Creating a SQL Trace Using SQL Server Profiler
        • Rendering images from a database on SSRS reports
        • Free eBook: SQL Server Hardware
        • Moving to the Heartland
        • Find unused jobs
        25th

        SQLServerCentral Newsletter

        • SQLServerCentral.com Users Survey 2013
        • Finding lost or forgotten SQL Servers
        • AlwaysOn in SQL Server 2014 CTP1
        • Disaster Recovery Tip #6 - Monitor Your Systems
        • Data Farming
        • Monitor database size with dbcc showfilestats
        26th

        SQLServerCentral Newsletter

        • Configuring Database Mirroring
        • PowerShell the SQL Server Way
        • Could You Live Like a DBA?
        • The Ultimate Index Width Stats Reporter
        27th
        28th

        Database Weekly

          29th

          SQLServerCentral Newsletter

          • Using Lookup Function to Bridge Datasets in Report Builder
          • VMware High Availability in SQL Server
          • How to understand NoSQL Databases
          • Convert Row to Column without using any other column for Pivot
          • Convert Row to Column without using any other column for Pivot
          30th

          SQLServerCentral Newsletter

          • SQL Saturday #236 St Louis, MO
          • Free eBook: SQL Server Execution Plans, Second Edition
          • Enable/Disable a table to be read only on the fly
          • Baselining with SQL Server Dynamic Management Views
          • Flying high on the Big Data hot-air
          • Finding Objects on Your SQL Instance
          31st

          SQLServerCentral Newsletter

          • Biml Workshop presented by Varigence and Linchpin People
          • Biml Basics - Level 2
          • SQL Saturday #234 Baton Rouge, LA
          • Less QA?
          • Views created per table
          Previous month