Performance Tuning in the Age of Big Data

Database Administrators must now deal with large volumes of data and new forms of high-speed data analysis. If your responsibility includes performance tuning, here are the areas to focus on that will become more and more important in the age of Big Data.

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.

Achieve Better Performance

This week Steve Jones talks performance and a few things you might want to do that can help your career and employer.

Give

The world is bigger than you, and when you help others, you realize that. Making that change might also make you happier, and more successful, in your career.

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.

SQL in the City 2013

Steve Jones looks back at the 2013 tour kickoff for SQL in the City in London.

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.

Better Technical Interviews

Technical interviews don't work great, but are they dead? Is there a better way? Steve Jones comments today.