Reporting Services was one of the most popular add-ons to SQL Server 2000 and the next version has been greatly improved. Author Kamran Ali brings us a look at some of the new features and enhancements in this platform.
The March issue of the SQL Server Standard is now available for purchase, download, and should arrive in your mailbox any day. Check out the Table of Contents and read the editorial.
Building a highly fault tolerant and available SQL Server is expensive and difficult. This brings about unique challenges for small businesses who often lack the resources of large enterprises. Bilal Ahmed and Shivan Bindal discuss the various ways of building redundancy and the challenges of each.
Do you really understand what happens when you create a stored procedure? What if you have some extra code in your batch? This is an interesting article that shows an interesting effect of creating a stored procedure and where your GO statement is placed.
Now, you can get a free second shot at any Microsoft Learning IT Professional, Developer, or Microsoft Dynamics (formerly Microsoft Business Solutions) exam.
SQL Server 2000's DTS subsystem is a tremendously flexible environment for handling any number of tasks on your SQL Server. Alex Kersha used DTS to implment a task that manages the number of backup files on his server, which is conifgurable with a global variable. Read on and get the code to implement this task on your servers.
This article will acquaint you with aggregate functions such as MIN, MAX, COUNT, and AVG, which easily let you perform tasks that you may have thought needed extensive programming codes to accomplish.
he purpose this lab is to illustrate the benefits of the Distributed System Designers available in Whidbey to application architects, operations teams, and developers. These designers help application architects and developers construct service-oriented applications and prepare them for deployment in a target datacenter modeled by operations.
XML is becoming more and more prevalent in applications and more SQL Server DBAs are learning to work with this data structure. Raj Vasant brings us part 2 of his series on using OPENXML inside SQL Server, looking at passing XML into your stored procedures this time.
This white paper discusses how to integrate and deploy Microsoft SQL Server Express-based applications by using configuration files and the ClickOnce deployment technology in Microsoft Visual Studio.
By Steve Jones
If you’ve wanted a SQL Server MCP server for your databases, it’s available. The...
Introducing azsql-migration-test, a small open-source CLI that validates your Azure SQL Database migrations against...
By DataOnWheels
I have been asked many times about how the name “Data on Wheels” came...
WA CS (08218154392) Jl. GM Situt No.12 B, Pasiran, Kec. Singkawang Bar., Kota Singkawang,...
Comments posted to this topic are about the item Make It Routine
Comments posted to this topic are about the item DBCC CHECKDB Limits III
On SQL Server 2025, does DBCC CHECKDB support Memory-Optimized tables?
See possible answers