Installing SQL Server vNext on an AWS EC2 RHEL Instance
The steps required to create an Amazon Web Services EC2 instance and install the latest SQL Server version on the EC2.
2017-03-16
987 reads
Articles
How to Find Queries Using an Index (and Queries Using Index Hints)
Sometimes you know a query is out there, but it’s hard to find the exact query. In this post, Kendra Little gives example code to find queries using a specific index, or using an index hint.
2017-03-16
5,858 reads
Enable Trace Flags in SQL Server
Learn how to enable trace flags to change the behavior of your SQL Server instance.
2017-03-15
54,497 reads
Deployment Automation for SQL Server Integration Services (SSIS)
SSIS was not originally designed with automated deployment in mind. However, any database that uses SSIS projects and their packages needs a way of scripting the deployment of them if the database is to be deployed rapidly, or via a build server. Nat Sundar shows a technique that can be extended to manage the scripted deployment of SSIS projects.
2017-03-15
5,823 reads
Adding Years, Months and Days
Adding Years, Months and Days to Years, Months and Days, with Bonus UK Public Holiday calculation.
2017-03-14
3,312 reads
Managing Azure SQL Database Recovery
Azure SQL Database offers several benefits, built into the underlying cloud infrastructure, that leverage resiliency and redundancy. You can take advantage of this functionality to facilitate failover and failback in response to events that affect availability of an Azure region.
2017-03-14
3,555 reads
2017-03-13
1,892 reads
Introducing DevOps to Farm Credit Services of America
Identifying a need for better collaboration between teams is only the first step to introducing DevOps workflows into your organization. You also need to define a common DevOps goal,...
2017-03-13
2,937 reads
Understanding Graphical Execution Plans - Part 1: Explaining the Plan
Understanding execution plans is a good basic skill for all DBA's and SQL developers. Darren White gives us an overview of what execution plans are in SQL Server and how they are used.
2017-03-10 (first published: 2014-02-18)
31,061 reads
TroubleShooting SQL Server Memory Consumption
Satnam Singh walks through the steps he took to troubleshoot a recent issue with memory consumption on a staging server.
2017-03-10
6,023 reads
Blogs
Announcements from the Microsoft Fabric Community Conference — Barcelona 2026
By James Serra
Microsoft shared a broad set of Fabric, Power BI, and SQL updates at FabCon...
Au Revoir for now
By Steve Jones
No, I’m not quitting or retiring. Just going on vacation, but I leave tonight...
Forums
Let's Talk Certifications
Comments posted to this topic are about the item Let's Talk Certifications, which is...
The Hidden Security Risks of Role Combination in SSAS Tabular
Comments posted to this topic are about the item The Hidden Security Risks of...
The Empty Aggregate
Comments posted to this topic are about the item The Empty Aggregate
Question of the Day
The Empty Aggregate
I have this table in a SQL Server 2025 database:
CREATE TABLE [dbo].[CustomerOrder] ( [OrderID] [int] NULL, [CustomerID] [int] NULL, [total] [money] NULL ) ON [PRIMARY] GOWhat is returned from this code? (answers are for the sum and then the count)
SELECT SUM(total) AS sum,
COUNT(total) AS count
FROM dbo.CustomerOrder;
See possible answers