(Darren Fuller) In part 2 Darren Fuller examined an automated approach to database change management and outlined the essential elements of an automated methodology. In this third article of a 4 part series, he lists the requirements to implement an automated approach and highlights some of the bene

You can set a column in a DataTable to be an auto-incrementing primary key in order to ensure a unique value for each row in the table. However, you may have multiple clients for your application, and each of those clients can be working with a separate instance of the DataTable. In this case, y

(Chris Kempster) The following article shows, through code, how to enable SQL Agent alerts and using a simple stored procedure and DLL, send emails via an SMTP server rather than using SQL Mail. We will cover these items: SQL Agent Event Alerts SQL Agent Tokens Calling DLL’s via sp_OA method

(William Pearson) In this article, we will venture away from the functionally specific focuses of recent sessions, and concentrate on a basic consideration that can save us a great deal of time in our work within reporting services. As most of us who have worked with enterprise reporting packages ha

(Scott) In our previous article we examined authentication with MSDE. In this article we will take a close look at authorization. Specifically, we will see how to use and manage database roles, and how to grant, revoke, and deny permissions to database objects and statements. If you need to inst

(Christian Kleinerman) All Microsoft SQL Server data access application programming interfaces (APIs) provide an abstraction to represent sessions and requests within those sessions. SQL Server 2000 and earlier restricted the programming model such that at any point in time there would be at most on

(Sara Cushman) Though plenty of people have already caught a glimpse of SQL Server 2005, and some companies are even using Beta 2 in production environments, most enterprises won’t be seeing the latest release of Microsoft’s DBMS until it ships early next year. But attendees at 2004 PASS Community S

(Leo Peysakhovich) SQL Server alerts provide an elegant administrative tool to automatically notify pre-designated operators of server event occurrences. Organizations benefit quickly, as alerts make their DBAs more proactive to conditions requiring their attention. You can enable automation of

(Danny Lesandrini) When I heard that Peter Blackburn and Bill Vaughn were writing another Hitchhiker book, I fired off an email to him, asking for the first right of review. At the time of my request, the book, Hitchhiker’s Guide to SQL Server 2000 Reporting Services was not yet in publication, but

(Kalen Delaney) Last month, in “Mixed Extent Usage,” I discussed the algorithm that SQL Server 2000 and 7.0 use to allocate space to a table or index. I also introduced the undocumented DBCC EXTENTINFO command. This command can show you which extents SQL Server has allocated to an object as uniform