Human Power
It's incredible what humans can accomplish when they work on a problem with passion. This editorial was originally published on Mar 20, 2008. It is being re-run as Steve is on vacation.
SSD Lifetimes
This week Steve Jones looks at the expected lifetimes of SSDs and finds one that might be a nice upgrade for your system.
Create SQL Server Analysis Services Partitions using AMO
When you have SSAS cubes with millions of rows of data, it is very helpful to create partitions. If you have a few cubes you could probably do this manually, but if there are many or if you want to automate this process you should look for smarter solutions such as programming the creation of partitions dynamically.
SQL Saturday #179 - Kharkov, Ukraine
SQL Saturday in the Ukraine. If you want a free day of training, sign up and attend.
Day 7 of The OLAP Sprint
The final day of Simon's journey to improve his OLAP knowledge and build a prototype cube.
Generating SubTotals using GROUPING
This article explains how to use the GROUPING clause to generate subtotals for rows in a very easy fashion.
The Cost of Storage
As DBAs we constantly need more storage, but do we know what the impact or cost of this storage is to our employers? Answer this week's poll.
SQL Saturday #168 - Tampa BI Edition
A free day of SQL Server Business Intelligence sessions in Tampa, FL tomorrow.
SQL Server 2012 AlwaysOn: Multisite Failover Cluster Instance
SQL Server Failover Clustering, which includes support for both local and multisite failover configurations, is part of the SQL Server 2012 AlwaysOn implementation suite, designed to provide high availability and disaster recovery for SQL Server. The multisite failover clustering technology has been enhanced significantly in SQL Server 2012. The multisite failover cluster architecture, enhancements in SQL Server 2012 to the technology, and some best practices to help with deployment of the technology are the primary focus of this paper.
Blogs
“We love to debate minutiae”
By Brian Kelley
I am guilty as charged. The quote was in reference to how people argue...
Advice I Like: Knots
By Steve Jones
Learn how to tie a bowline knot. Practice in the dark. With one hand....
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...
Forums
Windows logins for users migrated from DomainA to DomainB
Hi, I have a SQL Server instance where users connect to via Windows Authentication,...
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...
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