Search Results for "kevin kline"

Community

Maintenance checks for SQL Server

(Kevin Kline and Baya Pavliashvili) SQL Server has become more self-maintaining with each new release, but the principle “better safe than sorry” still stands: Solid database administration involves performing regular maintenance on system and user databases so that you fix problems before your user

Community

SQL Server: Blocking Problems

(Kevin Kline and Baya Pavliashvili) SQL Server transactions are extremely powerful—they provide a way to incorporate business rules into your applications and protect data integrity. Behind the scenes, the transactions are implemented through the SQL Server’s locking mechanism, which we discussed in