(Hector J. Correa) This article describes some of the advantages that Wiki Web sites provide and how you can use ASP.NET and SQL Server to create your own Wiki. You’ll learn how to write powerful parsers using the .NET regular expressions class and you’ll discover how to add sophisticated search fun

(Jeffrey Yao) There are lots of articles about how to do auditing, but there are few discussions about how to use the auditing results in a real time environment, for example, an employee salary table has a delete operation during non-working hours, a responsible DBA should be notified for this unus

(Marcin Policht) Access to SQL Server resources is controlled by two separate mechanisms. The first one is authentication, which determines the identity of a user attempting to connect, based on a verifiable identifier. The second one is authorization, which establishes the level of privileges grant

(Danny Lesandrini) My first real production experience with SQL Server came when I upsized a popular event management system written in Access 97. Since Access Data Projects (ADPs) had not been released yet, we had to use Enterprise Manager and SQL Query Analyzer to maintain the database schema. Wit

When you run a query that contains a UNION ALL operator, a TOP clause, and an ORDER BY clause to retrieve data from a SQL Server database, you may notice that the data that is returned in the result is not consistent. The result you receive when the query is run the first time differs from the resul

(Navneeth Diwaker Naik) Triggers are special types of Stored Procedures that are defined to execute automatically in place of or after data modifications. They can be executed automatically on the INSERT, DELETE and UPDATE triggering actions. There are two different types of triggers in Microsoft

(Doug Carpenter) Views have been available throughout the history of Microsoft SQL Server. However, using views that return very large result sets can lead to poor performance, as the result set is not indexed and the entire result must be table scanned if the view is used in a join or a subquery of

(Yoram Levin) You might think that financial reporting should be a straightforward implementation of the OLAP model. Almost every vendor that offers a product in the business intelligence (BI) arena touts financial reporting as one of the primary implementations of its tool. But if you’re going to u

(Sanket Naik) Normalization is an art; it is the best thing that can happen to databases .But it modularizes the data which means that we are not having all the data in the same table. This indirectly means that, suppose I want a receipt and for constructing that receipt I need data that is scattere

(Steven Warren) In the age of catastrophes, which include disk failures, power failures, fires and floods, disasters can take their toll on any business and stop the flow of information. With each minute of lost data translating into unrecoverable revenues, downtime is being taken seriously. As