Failure Lessons
Steve Jones would like to see more disclosure about what works and doesn't work when deploying new systems and software.
Hierarchies on Steroids #2: A Replacement for Nested Sets Calculations
In this sequel to his first "Hierarchies on Steroids" article, SQL Server MVP Jeff Moden shows us how to build a pre-aggregated table that will answer most of the questions that you could ask of a typical hierarchy. Any bets on whether Santa is packin’ a Tally Table in his bag or not?
FileStream and FileTable in SQL Server 2012
SQL Server 2012 enhanced the SQL Server 2008 FileStream data type by introducing FileTable, which lets an application integrate its storage and data management components to allow non-transactional access, and provide integrated SQL Server services. Arshad Ali explains how.
Day 5 of The OLAP Sprint
Day 5, the first real day of the Summit. Amir Netz' session and a little cube work.
Stairway to SQL Dialects Level 2: Postgres
Level 2 of this stairway explains how to convert data declaration language (DDL) statements and data manipulation language (DML) statements from Postgres to Microsoft SQL Server.
The Future of DBAs
What's the future for DBAs with cloud services and computing? Steve Jones talks about what might be coming soon.
Prevent Truncation of Dynamically Generated Results in SQL Server Management Studio
While working with the Results to Text option in SSMS, you may come across a situation where the output from dynamically generated data is truncated. In this article I will guide you on how to fix this issue and print all the text for the Results to Text option.
Day 4 of The OLAP Sprint
Day 4 is the halfway point. Another pre-con, this one from Peter Myers that looks at Power View and Matrix reports.
Too Much Data
Are you managing too much data? Lots of data professionals feel that way, but fortunately "Big Data" is in the news and bringing more visibility to the challenges we face on a daily basis.
Designing Databases for Rapid Resilience
As the volume of data increases, DBAs need to plan more actively for rapid restores in the event of failure. For this, the intelligent use of filegroups is important, particularly when the Enterprise Edition of SQL Server offers the hope of online restores. How, though, should you arrange your data on the different filegroups? What happenens if the primary filegroup gets corrupted? Why backup and restore indexes?
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
how to write this query?
Hi everyone I asked this earlier but the desired outcome is a bit different...
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
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