Why Be an MCP?
With Steve Jones on vacation, we reprint on of his more popular editorials from the past. This was originally published on Feb 14, 2005.
A High Level Comparison Between Oracle and SQL Server - Part III
Part III of the Oracle / SQL Server comparison looks at the configuration options for each database, their storage options as well as the startup and shutdown procedures.
Why UniqueIdentifier is a Bad Choice for a Clustered Index in SQL Server
I had a question today about why it was “bad” to use a UniqueIdentifier as the data type for a...
How to Evaluate Policies on Multiple Instances
This article describes how to Evaluate Policies on Multiple Instances using EPM and PowerShell.
Space in the Clouds
Spatial support is coming to SQL Azure soon, and Steve Jones thinks about how the service could improve this support.
An Un-CATCHable Error?
I've been using the scripting tools in SSIS for some time, but I came across something today that I can't...
SQL Server Column Considerations and Column Placement
Determining which columns to select for your indexes is critical. Having a little knowledge of how your application is using your database columns and how SQL Server processes indexes helps you make good decisions when you create your indexes.
Hunting and Gathering
A guest editorial from Rodney Landrum looks at how we get advice from others in the wild, wild world of the Internet.
SQL Server 2008 T-SQL Enhancements Part - IV
In the fourth installment that looks at T-SQL changes for SQL Server 2008, Ashad Ali examines how the Filestream data type works.
A High Level Comparison Between Oracle and SQL Server - Part II
Part II or the Oracle / SQL Server comparison dives deeper into databases by exploring the architectural differences.
Blogs
Advice I Like: Rewards from Work
By Steve Jones
The greatest rewards come from working on something that nobody has words for. If...
Overcoming Challenges: Navigating Common Pitfalls in FinOps Adoption
By HeyMo0sh
Working in DevOps, I’ve seen FinOps do amazing things for cloud cost control, but...
Why your data still can’t answer a simple question
Every organization I talk to has the same problem dressed up in different clothes....
Forums
The day-to-day pressures of a DBA team, and how we can work smarter with automation and AI
Comments posted to this topic are about the item The day-to-day pressures of a...
Analysis Services Model w/ Direct Query and (Default Veritpaq)
Analysis Services (either the integrated workspace in Power BI or on a SQL Server)...
Question of the Day
Identities and Sequences IV
When thinking about the identity property and sequence objects, which of these can be used with numeric and decimal data types?
See possible answers