SQL Saturday will be in Iowa City on July 27, 2013. This free day of SQL Server Training and Networking will also have pay-for pre-conference sessions presented by Bill Pearson, Louis Davidson and Tim Mitchell.

Data Philanthropy

by Steve Jones

SQLServerCentral.com

Editorial

The idea of giving back to the world some of your success has been something many successful businesses have done forever. Steve Jones thinks they should consider giving more than physical resources, but also give data.

SQL Saturday #222

by Press Release

SQLServerCentral.com

SQL Saturday

SQL Saturday is coming to Sacramento on July 27, 2013. Join us for a free day of SQL Server training and networking. This SQL Saturday also features a paid-for full day pre-con session with Kalen Delaney

SQL Server Transactions and Locking – Part 2

by Additional Articles

SQL Server Performance

Isolation Levels

This article looks at SQL Server locking and transaction isolation levels, how to set the transaction isolation level, and how some isolation levels use locking, while others use row versioning. It also explains what type of locks data update requires.

Hack Resistant?

by Steve Jones

SQLServerCentral.com

Editorial

Can we make a hack resistant database? A vendor claims this, but Steve Jones thinks it's not really a good claim to make and that we ought to make it our job to secure databases.

Orphaned Distribution Transactions

by Shashank Srivastava

SQLServerCentral.com

Administration

Learn about orphaned distribution transactions in SQL Server and how you can clear them.

Encrypting and Decrypting SQL Server Stored Procedures, Views and User-Defined Functions

by Additional Articles

MSSQLTips.com

Stored Procedures

Some companies put business or application logic in SQL Server using stored procedures, views and functions to return values to the calling applications or perform tasks. This is not unusual in companies that use the SQL Server layer to perform business tasks, such as finance operations, or incorporate application functionality into the programmability layer. Here's a tip to preserve secrecy on some procedures, views or functions in order to maintain security.