Using Extended Properties To Keep Everyone Informed
Use CMS and Extended Properties to store information about multiple servers, including the stakeholders who should know about any maintenance you are planning.
SQL Server Optimizer – Under the Hood Part 1
In this series of short articles, we lift the hood of the SQL Server Optimizer to examine a few of the many clever tricks used to optimize query performance. In Part I, we look at partial aggregate operators – an extremely clever way of downsizing certain large joins into much smaller (and faster) joins.
2013 in Review
Steve Jones looks back at 2013, starting with his predictions on Jan 1 and looking at how data and SQL Server impacted our community.
Set Up And Schedule a Server Side Trace
How to use Profiler to generate TSQL scripts that can be modified and automated to run as a server-side trace
The DBA's Big Data Holiday Wish List
Big data is now a standard part of information technology architecture for most large organizations. As a database administrator, with the holiday season upon us, I have the following items and notions on my holiday wish list. Here's hoping that I am gifted one or more of these; each one gives me something that I want or need.
Creating templates for use in BIDS (SQL Spackle)
Learn how to create and use templates in BIDS in this short SQL Spackle article.
Mining for Quitters
Google is trying to figure out who might quit the company, using their own custom application. Steve Jones thinks this is a great idea and wishes more companies would do it.
The Ultimate Tool List
This week Steve Jones looks at a few tools that can help your productivity and links to a few more.
Migrating SQL Server Database to Windows Azure - Deploying SQL Database
There are a few challenges associated with deployments of data services in Windows Azure, focusing in particular on SQL Database. In this article we turn our attention to an actual deployment and migration of locally stored data to SQL Database.
Blogs
The Book of Redgate:A Prehistory
By Steve Jones
I’ve covered the values in a number of previous posts on the Book of...
Evidence-bound: what AgentDBA will and won’t link
By Arun Sirpal
When the evidence names the database, it says so. When it doesn’t, it stops....
Prep data for AI vs. Fabric Data Agent Instructions: What Goes Where?
By James Serra
Making Data AI-Ready, Part 3 (This is the final article in a three-part series...
Forums
Four Rules for Adding AI Without Breaking What Already Works
Comments posted to this topic are about the item Four Rules for Adding AI...
SQL Server 2025 section missing?
Hello, the title says it all. Is the SQL Server 2025 section missing?
A design question in a parent child relationship
I am not sure which is the best way to proceed. I have parent...
Question of the Day
Hyperscale Replicas III
In an Azure SQL Database Hyperscale Edition, how many named replicas can be configured?
See possible answers