SQL Saturday #214 Louisville KY

Join us for a free day of SQL Server training and networking in Louisville Kentucky on July 13.

This SQL Saturday event also has 2 paid pre-con all day sessions on July 12 presented by Dave Fackler and Bill Pearson.

Log Shipping Lite with PowerShell

A PowerShell driver that performs incremental restores on a standby server, a lite weight log shipping solution.

SQL Server CREATE TABLE syntax diagrams

Many of us have seen, on MSDN, the heading 'Syntax', followed by a rash of nested brackets and keywords, enough to put off the most resolute of code-cutters. However, there is a goldmine of information there, and Phil had an ambition to get at it, and share the gold. The result is this article, full of railroad diagrams.

xp_cmdshell for Non-System Admin Individuals

There may be times when you want to allow non-System Admin logins to be able to execute the xp_cmdshell extended stored procedure. In this articleGreg Larson will show you how to setup xp_cmdshell so non-System Admins can use this extended stored procedure.

Automating SQL Server Database Deployments: Scripting Details

To wrap up the series on Database Deployment Challenges, Alexander takes a dive into the details of how he scripted a solution and comes up with several practical tips for getting the most out of any automated database deployment framework.

SQLServerCentral Runs sp_Blitz - Informational Items

The sixth article in our series that looks at the results of the sp_Blitz™ script run against the SQLServerCentral servers.

Export to XML Using SSIS

Exporting data to XML format using SSIS initially seems like it should be straight forward – just dump it in a flat file and give it a name xml type, however SSIS has no XML destination just an XML source. I had no luck dumping the XML in flat file. My solution was to use a script task which worked well.

Free eBook - Control Your Transaction Log so it Doesn't Control You

Download your free copy of SQL Server Transaction Log Management and see why understanding how log files work can make all the difference in a crisis.

New SQL Monitor Custom Metric: Database Autogrowth

This metric for Red Gate SQL Monitor measures the number of database autogrowth events (data file or log file) in the last hour. Too many autogrowth events causes disk fragmentation which requires a change in the autogrowth settings of a database.

Painless management of a logging table in SQL Server

Tables that log a record of what happens in an application can get very large, easpecially if they're growing by half a billion rows a day. You'll very soon need to devise a scheduled routine to remove old records, but the DELETE statement just isn't a realistic option with that volume of data. Hugo Kornelis explains a pain-free technique for SQL Server.