By George V. Hulme – The impact of the Slammer worm subsided Monday as companies scrambled to patch systems and block the worm’s ability to spread. Slammer is being touted as the worst attack on the Internet since the summer of 2001, when a worm called Code Red attacked hundreds of thousands of syst

By Itzik Ben-Gan – You can use date and time manipulations for calculating call costs across different rate periods as long as you stick to the basics.

By Mitch Wagner – A new worm attacking Microsoft SQL Server 2000 systems slowed Internet traffic to a crawl early Saturday.Security companies are warning about the worm, named W32/SQL Slammer or Sapphire, which uses a buffer overflow in SQL Server to take over the system and send out a flood

mssqlXpress is the latest full-featured integrated development environment (IDE) for MS SQL. mssqlXpress enables you to develop your databases using one powerful application. If you are an MS SQL developer, your life could be a lot easier from now on! The Problem MS SQL develope

By Vyas Kondreddi – This is the only book available, that covers SQL-DMO for SQL Server 2000 (and SQL Server 7.0 as well). It is filled with code samples and sample applications. Authors take real world scenarios from their own experiences and show you how to accomplish those specific tasks using SQ

Learn to plan, build, and optimize Web search applications that use Microsoft SQL Server 2000 Full-Text Search.

By Shahid Saleem – Some times we need to store the data in encryped form, for example when we use our own application for simple password check, we can write our own algo but will take lot of time or we can use cryptography API for the purpose but the simples way to get the objective that we can use

This article discusses certain basic troubleshooting techniques that you can use to diagnose and resolve most SQL Mail problems. Typically, the errors you receive when you start a SQL Mail session or when you send mail from SQL Mail with a Microsoft Exchange Server fall into two categories:

By Jan Stafford – Do you ever lock the front door and leave the back door wide open? That kind of half-safe security practice is all too common among database administrators, said database security expert Aaron C. Newman. In many cases, DBAs get lucky and hackers overlook their oversights. Too often

By Michael Otey – None of SQL Server’s upcoming programming-productivity enhancements will have more impact on DBAs than the .NET Common Language Runtime (CLR). This new capability begs the question, “Which .NET language should DBAs learn?”