(James Travis) The book flows quite well and has a nice reference quality to it. It is well laid out into Parts and Chapters which are broken down into nice encompassing topics. There are many exercises in the book that help test your knowledge of what you just read. I, however, did not like that th

Microsoft SQL Server is built in such a way that it can be managed by Database Administrators (DBA) with a wide range of skills and experience. SQL Server masks the complexity of managing a Relational Database Management System (RDBMS) to make it more appealing to administrators with various skill s

(Muthusamy Anantha Kumar) It is imperative to have monitoring tools to monitor the services running in a windows operating system based server. However, small shops do not have that kind of budget to get tools for monitoring. Data Base Administrators should be notified as soon as one of the SQL Serv

(William Zack) The excited chatter about SQL Server 2005’s Common Language Runtime (CLR) integration and other new features has all but eclipsed another very powerful component: SQL Server Service Broker. Service Broker, a database-application framework that lets internal or external database-relate

(Brian Knight) Securing your SQL Server can be an arduous task, but very rewarding. Nothing makes me personally prouder than running a penetration test on a server that we just secured and not seeing any hot spots. This article will focus on the ways to easily secure your SQL Server. Although this t

Memory usage increases for a client process that repeatedly queries Microsoft SQL Server 2000 Analysis Services, and the memory is not released after you disconnect from the Analysis server computer. This memory leak occurs when any Microsoft Visual Basic for Applications (VBA) function is used in a

(Steven Warren) In my last article, 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 article, we will discuss how to configure and

(Mike Ruthruff) As Microsoft SQL Server 2000 maintains indexes to reflect updates to their underlying tables, these indexes can become fragmented. Depending on workload characteristics, this fragmentation can adversely affect workload performance. This white paper provides information to help yo

(William Pearson) This article focuses on a topic that is related to an earlier group of articles we have published, all of which dealt with the use of “SQL specific” or “direct SQL” within MS Access. As many of us are aware, MS Access can play many varied roles in client / server architecture, and

(Benoyraj B.) This article explains step by step dynamic creation of a SQL Server database, tables and stored procedure using Visual Studio codename Whidbey and VB.NET. Same procedure works for C# as well.