Adding Reporting Services to an existing SQL Server installation
In this tip we look at the process of installing Reporting Services on a server that is already running Database Services.
Configuring SQL Server memory settings
Learn about SQL Server memory needs and settings including RAM amounts, how to enable AWE, maximum server memory and the differences of 32- and 64-bit platforms.
It's the Bits
A woman sues Best Buy for $54million. That's absurd, but her laptop is worth more than the hardware.
It's the Bits
A woman sues Best Buy for $54million. That's absurd, but her laptop is worth more than the hardware.
It's the Bits
A woman sues Best Buy for $54million. That's absurd, but her laptop is worth more than the hardware.
Locking Your Disk
How important is disk encryption to you? Do you think about all those replicated or copied databases on laptops? Let us know. This editorial was originally published on Feb 28, 2008. It is being re-run as Steve is on holiday.
Monitoring and Recording DDL changes on SQL 2005 (NARC)
Auditing activities on your database servers becomes more important all the time. But ensuring that schema changes do not occur without your knowledge may be more important for a stable system. James Greaves brings us a great technique using DDL triggers for doing this.
Practical Methods: Naming Conventions
Everyone should establish some sort of naming convention for their SQL Server platform. It helps to ensure that developers and DBAs can easily find objects and communicate with one another. New author Michael Lato brings us the start of a series on organizing your SQL Server code with an article on naming conventions.
Check List for Performance Optimisation in SQL Server Analysis Service 2005
This article is a step-by-step checklist to help ensure that you are obtaining the maximum performance possible from SQL Server Analysis Services.
Enabling Drillthrough in Analysis Services 2005
Discover the new Analysis Services 2005 drillthrough architecture. See how to set up drillthrough in Analysis Services 2005 and get guidance on migrating drillthrough settings from Analysis Services 2000 databases.
Blogs
Shifting Mindsets: Why FinOps is Essential for Cloud Efficiency
By HeyMo0sh
As a DevOps practitioner, I’ve always focused on performance, scalability, and automation. But as...
March 2026 SQL Server Security Updates
By Brian Kelley
On Patch Tuesday, in addition to OS and Office security patches, Microsoft also released...
How Fabric Mirroring Transformed with SQL Server 2025
When mirroring was first released for Azure SQL Database, it used Change Data Capture...
Forums
Multiple Deployment Processes
Comments posted to this topic are about the item Multiple Deployment Processes
How to Use sqlpackage to Detect Schema Drift Between Azure SQL Databases
Comments posted to this topic are about the item How to Use sqlpackage to...
Upgrading Admin Queries
Comments posted to this topic are about the item Upgrading Admin Queries
Question of the Day
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