Automatic Query Performance Tuning in SQL Server Database
In this article Anoop Kumar discusses Automatic Tuning, a new database feature that helps improve SQL Server query performance automatically.
Dealing with Disparate Goals
Grant talks about the lessons of history when the goals of different groups don't align.
Installing SSDT and creating your first SSIS Package
SQL Server Data Tools (SSDT) is a toolset which provides an environment for you to carry out all your database design work in SQL Server. It can be used to build to build SQL Server relational databases.
Azure and Windows PowerShell: Getting Information
In the second part of his series, Nicolas Prigent describes in detail how to automate the login process using PowerShell and Azure CLI. Nicolas also explains how to retrieve information about your Azure subscription.
Auto-suggesting foreign keys and data model archaeology
If you can understand the data model then you can understand the intent of the application developers.
Who Likes NULL?
The use of NULL values in a database can be controversial. Today Steve talks about his views on this concept.
How to Fix sp_BlitzIndex Aggressive Indexes Warnings
Either you've got too many indexes, or not enough. Here's how to tell.
Creating Compound Interest Calculations in SQL
This is the first article in a short series of SQL Server query challenges to test and expand your SQL Server querying skills
Blogs
T-SQL Tuesday #196 – Two risky career decisions I made
By DataOnWheels
The T-SQL Tuesday topic this month comes James Serra. What career risks have you...
T-SQL Tuesday #192: What career risks have you taken?
This T-SQL Tuesday is hosted by the one and only James Serra – literally...
T-SQL Tuesday #196: Taking Risks
By Steve Jones
This month we have a new host, James Serra. I’ve been trying to find...
Forums
XACT_ABORT being set to ON by web services
We have two "identical" instances of an ASP.NET web service (or so I have...
OPENQUERY Flexibility
Comments posted to this topic are about the item OPENQUERY Flexibility
A Full Shutdown
Comments posted to this topic are about the item A Full Shutdown
Question of the Day
OPENQUERY Flexibility
Which of these are valid OPENQUERY() uses?
See possible answers