A primary objective of any analytic architecture is business enablement - the ability to provide business users with access to quality information that can be used to drive decision-making.
This article series features a demo app affectionately named Something Not Entirely Unlike Access, which employs a variety of methods to obfuscate the "Accessian" features.
The sixth installment of the XML Workshop for SQL Server shows how the XML Schemas fit into the XML subsystem. Regular author Jacob Sebastian brings structure to your XML documents with a few schema examples.
Part 6 of "Microsoft Windows PowerShell and SQL Server 2005 SMO" illustrates how to use PowerShell and PowerShell script to backup databases.
BI Architect Bill Pearson begins a three-part sub-series on Caching Options within Reporting Services 2005. In this article, we focus upon Report Session Caching.
Reporting Services makes building rich reports easy, including images and fancy layouts, with a nice wizard. But adding in background images is a little more complex and Andy Warren brings us a quick tutorial for SQL Server 2005's Reporting Services
Get the details, including the room (607) for our party in Denver on September 18th, 2007. And by the way, there's a conference immediately following.
SQL Service Broker, an asynchronous queuing and messaging system for SQL Server 2005, is set to change the way we design and run distributed applications. Adam Machanic makes it all seem so easy
A patch to your SQL Server system can cause problems, but an unpatched SQL Server is unprotected. Learn the pros and cons of SQL Server patches.
Continuing with his series on Alias Data Types, Yakov Shlafman shows us how to work wtih ADTs when constriaints are involved.
By HeyMo0sh
As a DevOps practitioner, I’ve always focused on performance, scalability, and automation. But as...
By Brian Kelley
On Patch Tuesday, in addition to OS and Office security patches, Microsoft also released...
When mirroring was first released for Azure SQL Database, it used Change Data Capture...
Comments posted to this topic are about the item Multiple Deployment Processes
Comments posted to this topic are about the item How to Use sqlpackage to...
Comments posted to this topic are about the item Upgrading Admin Queries
I have a query from a former DBA that we run on SQL Server 2025 to check on database metadata. This query references sys.sysaltfiles. I want to refactor this code to be more modern. Which DMV should I reference instead?
See possible answers