(Serhiy Snisarenko) The list of common DBA tasks includes setting up a server performance base line and comparing the performance of two or more servers. We often have to do this urgently when our customer calls and expects us to identify and remove a performance bottleneck right away. The following

(Mike Chapple) SQL Server replication allows database administrators to distribute data to various servers throughout an organization.

(Steven Warren) In Part I of High Availability with SQL Server and Double-Take, we discussed how to configure replication and mirroring of SQL Server data via Double-Take. Once you have properly configured your replication sets, you can configure failover and begin monitoring and testing. In this ar

(William Pearson) As I have discussed in many past articles, ad hoc reporting capabilities are highly valued by information consumers. While we have, up until this article, focused on adding interactive features, such as parameterization, and ad hoc sorting and other conditional formatting features

(Vinod Kumar) As more companies try to embrace the next version of SQL Server they will surely have their hands on SQL Server 2000 servers too. When I first saw this new tool I was amazed to see how this new tool tried to give the best of both the worlds as Query Analyzer and Enterprise manager. Wit

(Boris Baliner) As more DBAs across the planet begin using SQL 2005 Tools, but still manage SQL 2000 servers with them, I suspect there will be lots of muffled moaning as to where all the good old features have gone. Although Management Studio has some very nice long-awaited features, some of the go

(Adam Machanic) As part of Microsoft’s secure computing initiative, many new security features were added to SQL Server 2005. While features like encryption and granular permissions control secure databases within a server, other features are dedicated to securing the “surface area” of the server. T

When a user-defined function is in a high-stress scenario in Microsoft SQL Server 2000, you receive an access violation error message.

(Kevin Beaver) With SQL Server 2005, you can manually configure it to balance security and functionality. However, if you want to ensure you cover all of the security bases and only enable services you absolutely need (thus minimizing the attack "surface"), Microsoft has made it simple for you. I’m

(Jeffrey Juday) Views and stored procedures allow you to modularize and decouple your Transact-SQL (T-SQL) code well, but have you ever wanted to get more out of them? Like using a parameter-driven view or a stored procedure in a SELECT statement? Well, SQL Server has an often-overlooked alternative