(Joe Webb) From the new graphical management tool that’s integrated into SQL Server Management Studio, to the management API that provides a way to create and manipulate an instance using a .NET programming language, the enhancements brought forth by SQL Server 2005 Notification Services are a welco

(William Pearson) In this, the second half of a two-part article, we continue the examination of Named Calculations we began in Mastering Enterprise BI: Extend the Data Source with Named Calculations, Pt. I. In Part I, by way of introduction, we recalled ways of “extending” the data source tables un

Consider the following scenario. You have an instance of SQL Server 2000 that runs on a multiprocessor computer. Additionally, you set the value of the max degree of parallelism option to a number that differs from 1. You do this to use several processors for parallel plan execution. You run the DBC

Consider the following scenario. An instance of SQL Server 2000 runs on a computer that has more than four processors. You start a trace in the instance. In this scenario, you may experience slow server performance.

(Michelle Gutzait) An experienced DBA understands the meaning of backups. Say a project manager calls you just as you are about to leave the office to spend a nice, quiet evening with your wife or husband. “Help! We just dropped our main table in production. It was a mistake! We need to recover

(Don Schlichting) How to pass parameters (variables) IN, OUT, and RETURN error codes from a Stored Procedure to a Web Page.

(Conor) There are many cases where the database administrator does not control the queries being submitted of the system. As a result, the physical database design is often not tuned as well as it could be. In a number of actual customer cases where we investigated performance issues with them, we

The first step in binding a datareader to a datalist is to import the System.Data.SqlClient namespace and have ASP.NET connect to SQL Server. This gives you access to the classes necessary to retrieve data from a SQL Server database. More on .net datareader performance in this asp.net tutorial

(Hardik Shah) A technique often employed by malicious users for gaining illegal access to remote machines, through the web applications’ vulnerability, is SQL injection. The basic idea behind this technique is to run the SQL query, something not intended by the programmer. SQL injection relies heavi

(Serdar Yegulalp) Among the undocumented SQL Server commands I’ve been covering in the past few weeks, there is one command that helps determine how well SQL Server is managing its memory usage: DBCC MEMUSAGE. Specifically, DBCC MEMUSAGE determines how effectively SQL Server caches data and which ob