(Brian Moran) Last month, in “SQL Server Profiler: For Developers, Too” (http://www.winnetmag.com/article/articleid/43268/43268.html ), I encouraged you to integrate SQL Server Profiler into your unit-testing process. IT professionals typically think of Profiler as a DBA tool, but in my article, I o

(Anthony Wilko) When a host decides to offer Microsoft SQL Server databases as a feature, customers need a way to access their databases. Usually it is through one of several ways.

(Kevin O’Donovan) Having just read Santveer Singh’s article Which databases are being backed up (another look), I thought the following might add something to it. Our situation is slightly more complex. We develop software applications that make use of replicated databases. Our users are distrib

(Allan Mitchell) In the newsgroups we have been asked on a number of occasions how to execute a stored procedure once for every row of input data. There’s currently no really good way of doing this but in SQL Server 2005 DTS that is about to change. This article is going to show you how to take valu

(Muthusamy Anantha Kumar) In a large organization, it can be difficult to find active and inactive machines as well as machines that are not used anymore. This article provides a basic guideline to query the Active Directory and ping all the machines on the network, in order to find all active and i

(William Sheldon) When defining your security implementation, your primary goal is to protect your organization’s data. SQL Server, as the data store, becomes the center of your security universe. To secure your data, you’ve run the Microsoft Baseline Security Analyzer (MBSA), limited database commu

(Desiree Harris) While SQL Server has a very mature set of tools, one thing that is lacking is the ability to send a simple email alert based on a pre-defined set of rules. At first glace, it appears that email notifications exist but what becomes a problem to many people is the requirement for

(Twan Van Beers) That title’s quite a mouthful, huh! Let’s start by explaining what we’re actually trying to achieve here. Actually, before we start, let’s just say that this paper shows you how I implemented protocol transition and constrained delegation with SQL Server and IIS, and it is not inten

(Denny Figuerres) While random blocking of ports by ISP’s could lead to a severely crippled Internet I do not believe that it is in the best interests of most users (private or business) to leave all ports open to all users. As an example of this lets take a look at the “MSBlast” worm and the damage

(Ron Talmage) SQL Server uses isolation levels to govern the tradeoff between consistency of transactions and concurrency of multiple users. As you raise a transaction’s isolation level, you also increase the chances that a transaction’s reads may block and deadlock with other transactions. Even