Steve Jones notes that a data breach resulted in a lawsuit. How long before that's a common practice, and should we be preparing as data professionals.

San Jose, CA - SQL in the City Seminar - Deployment Stairway

by Press Release

SQL in the City

Events

The day before SQL Saturday Silicon Valley, SQL Server MVP Steve Jones will be hosting a free seminar in San Jose on March 14 2014. Join fellow database professionals to learn best practices and practical tips for SQL Server version control, continuous integration and deployment.

Using hash values in SSIS to determine when to insert or update rows

by Additional Articles

MSSQLTips.com

hash

A common method to detect if a row has changed is to compare hashes. Integration Services itself doesn’t have a hash implementation, so in this tip I’ll show how you can implement a hash detection mechanism using a script component, as an alternative to the pure T-SQL solution.

A Quick Tour of sp_ExecuteSQL

by Jonathan Allen

SQLServerCentral.com

T-SQL

sp_ExecuteSQL can be used to dynamically execute T-SQL code. Learn how to use it and how to add parameters to control what code is executed.

Auditing Matters

by Steve Jones

SQLServerCentral.com

Editorial

We might not be able to stop hacks, attacks, or issues with our databases, but knowing that they've occurred is important. Steve Jones notes that we might need auditing more than security.

Risks and Bets

by Steve Jones

SQLServerCentral.com

Editorial

Steve Jones looks back at the T-SQL Tuesday topic this week.

Guerrilla Project Management for DBAs

by Additional Articles

SimpleTalk

TribalSQL

All DBAs need to engage in a little project management to help make sure everything runs smoothly. In this extract from the book Tribal SQL, David Tate explains his system for managing workload, colleagues, and projects, and how not to be just "the guy who says no".

SQL Saturday # 276 - Silicon Valley, CA

by Press Release

SQL Saturday

Events

March 15, SQLServerCentral's Steve Jones and many others (including Kalen Delaney, Kevin Boles, and Karen Lopez) will be presenting at SQL Saturday Silicon Valley. This is a free, one-day learning event about SQL Server, Microsoft Business Intelligence, and Big Data. Register soon while spots are available.