Ever have a large batch of scripts you need to run? It takes a while if you have to open each one in Query Analyzer and execute it. One of our readers proposed an alternative - take a look the small app Andy Warren wrote to make doing this task a breeze.
A new security alert affecting SQL Server was released on June 12, 2001
Data Quality is as important as data integrity for most every application. This article examines how data quality can be improved in a data warehouse through the use of Meta Data.
In this article by Brian Knight, he explores how to install Service Pack 1 for SQL Server 2000 and some of the catches. This service pack is one of the largest in SQL Server history. Learn what was fixed here.
In software, clonation can sometimes turn out to be an extremely helpful technique. More often than not, in fact, you catch yourself duplicating instances of running objects to produce nearly identical objects to be managed codewise in a fairly independent way.
First introduced in SQL Server version 7, Index Intersection gives you new options for creating indexes on tables to maximize performance.
On the surface, the goal of performance tuning a query seems simple enough. Essentially, we want our queries to run faster. This article looks at how the STATISTICS IO and STATISTICS TIME options can help us tune queries.
By Steve Jones
An interesting AI experiment here with Copilot from GitHub in handling some code I...
SQL is essential for modern businesses and applications that rely on data. It's a...
By Patrick
SQL Server Audit is an efficient way to track and log events that occur...
Comments posted to this topic are about the item 7 sept, scheduled book
Comments posted to this topic are about the item 7 sept, schedlued article
Comments posted to this topic are about the item 6 sept, published book
Azure Data Lake Storage Gen 2 is built on ...?
See possible answers