SQL Server Show Available on the Site Now SelectViews – SQL Server 2008 Features, Upcoming Events, SQL Server Job Tips and More. Get the 60 second tip of the day, find out about SQL Server 2008 and what it could mean for DBAs and much more in the show this week. > Watch Here Featured Article(s) Moving to DB2 9: […]
Search Results for "kevin kline"
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
Built-in facility to encrypt column data
(Kevin Kline) Is there any built-in facility to encrypt a column data in SQL Server? Find out more in this article. (R)
How to set up an event forwarding server
(Kevin Kline) In part one of this series, I described why and how I use event forwarding to implement a cheap and effective monitoring feature for my large SQL Server environment. Here I’ll describe how to set up a central server and highlight issues you should be aware of at the central point of co
Free SQL Server monitoring with Event Forwarding
(Kevin Kline) I’ve worked with a lot of database platforms over the years — everything from Oracle to DB2 UDB, MySQL to PostgreSQL, Sybase to SQL Server. One of the things I’ve always enjoyed about SQL Server is the genuine ease of administration that Microsoft has built into its native toolkit.
Tuning SQL Statements on Microsoft SQL Server 2000
(Kevin Kline and Claudia Fernandez) This paper covers the basic techniques used to tune SELECT statements on Microsoft’s SQL Server 2000 relational database management system. We discuss the techniques available using Microsoft’s graphical user interfaces provided in Microsoft SQL Enterprise Manage
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
SQL Server: Transaction and Locking Architecture
(Kevin Kline and Baya Pavliashvili) Transactions are an inherent part of any application that collects or manipulates data. SQL Server has to ensure the data integrity. This means that no two users should modify the same piece of data at the same time. Nor should they read “dirty” data—modified but
Translating Procedural Statements Between Oracle and SQL Server
(Kevin Kline) This white paper is intended to give you a QUICK but thorough overview of the issues you may encounter when translating procedural code, such as stored procedures or user-defined functions, between Oracle’s PL/SQL and Microsoft SQL Server’s Transact-SQL procedural extensions to the ANS
Take Advantage of Powerful System-Supplied UDFs in SQL Server 2000
Baya Pavliashvili and Kevin Kline explore a set of SQL Server user-defined functions from Microsoft that are related to traces.