(Adnan Masood) Business Intelligence is a thriving discipline in the marvelous era of computing we live in. It’s the process of analyzing and exploring the information, trends and patterns hidden in data. BI escalates the business roadmap and facilitates business users to deliver better strategic so

(Anthony Wilko) In the web hosting world there’s rarely a “Holy Grail” in software. With all the choices available these days the software starts to blend together and it gets hard to discern which software is really better than the rest. Is MyLittleAdmin the tool that can make a difference in a

(Jasper Smith) With the lack of an equivalent in SQL2005 for the SQL Server Service Manager that comes with SQL2000, I’ve decided to write one myself using C# and SMO. The download in this article is the first beta of SQL2005 Service Manager. There are a number of known issues with it currently

The actual data in your table is stored in Pages, except BLOB data. If a column contain BLOB data then a 16 byte pointer is used to reference the BLOB page. The Page is the smallest unit of data storage in Microsoft SQL Server. A page contains the data in the rows. A row can only reside in one pag

(Robert Westervelt) Microsoft developers working on the next version of SQL Server are beginning to feel the squeeze from competitive pressures, as they race to release the next version of the DBMS. (R)

(Andy Warren) These code samples illustrate how to enable and disable all triggers in a database at one time – a task not easily done otherwise! If you haven’t use DMO before, I’ve posted two articles that you may find informative – Introduction to SQL-DMO and More DMO. (R)

(David Clark) Though it’s not as common a combination as PHP and MySQL, PHP and Microsoft SQL Server can be a powerful team. You can query SQL Server databases easily and effectively using the PEAR database abstraction layer, just as you would a MySQL database. But once you start trying to use one o

(Muthusamy Anantha Kumar) Part of Database Administrator’s job is to monitor blocking in SQL Server. By taking advantage of the Microsoft Knowledge Base article 271509, we can monitor the blocking and capture the SQL statements that are involved in the blocking to a file. This can be accomplished by

(Thiru Thangarathinam) One of the excellent features provided by SQL Server 2005 (code named Yukon) is its integration with the .NET CLR which makes it possible for us to author triggers, stored procedures, user defined functions, and create other database objects using a managed language such as VB

(William Pearson, III) In this article, we will introduce the concept of distinct counts, discussing why they are useful (and often required) within the design of any robust analysis effort. Throughout this article, we will describe some of the challenges that are inherent in distinct counts, and th