Contained Databases
Today's post is in regards a feature that was released with SQL Server 2012, it hasn't gotten the attention or used that it deserves even when it helps solving...
2017-11-02
14 reads
SQLDbaInternals
Contained Databases
Today's post is in regards a feature that was released with SQL Server 2012, it hasn't gotten the attention or...
2017-11-01
505 reads
Configuring a Subscription to an Azure SQL
This is my first post where I utilize an hybrid cloud, item that I personally find very interesting and useful so expect more posts like this to come.Microsoft Azure...
2017-10-25
14 reads
Configuring a Transactional replication
Hello,
This post is intended to show you all the steps you will need to follow when you setup a transactional replication, in fact the first 5 steps are one...
2017-10-25
14 reads
Configuring a Subscription to an Azure SQL
This is my first post where I utilize an hybrid cloud, item that I personally find very interesting and useful...
2017-10-25
844 reads
Configuring a Transactional replication
Hello,This post is intended to show you all the steps you will need to follow when you setup a transactional...
2017-10-25
249 reads
What's new in SQL 2017
SQL Server 2017 became General Availability (GA) on 10/2, I've been sharing through the different social media channels the different features and enhancements included in this new version, however...
2017-10-11
20 reads
What's new in SQL 2017
SQL Server 2017 became General Availability (GA) on 10/2, I've been sharing through the different social media channels the different...
2017-10-11
175 reads
Introduction to SQL Server Always On
Today I'll write with one of the features I like the most and is Always On. There will be two post of this subject, this first one is an...
2017-10-06
18 reads
Introduction to SQL Server Always On
Today I'll write with one of the features I like the most and is Always On. There will be two...
2017-10-06
1,085 reads
Blogs
The PASS Summit on Tour in Dallas
By Steve Jones
The PASS Summit goes on tour this year, with a September stop in Dallas....
SQL Server Auto-settings: The Good, the Bad, and the Ugly
By Kevin3NF
Settings That Could Be Hurting Your Performance If you’ve ever created a new SQL...
Bad Request Error when Running PowerShell Command in Azure Devops
I needed to run a PowerShell cmdlet in an Azure Devops pipeline. The cmdlet...
Forums
How a Legacy Logic Choked SQL Server in a 30-Year-Old Factory
Comments posted to this topic are about the item How a Legacy Logic Choked...
Has the PK been used --
Comments posted to this topic are about the item Has the PK been used...
Has the PK been used --
Comments posted to this topic are about the item Has the PK been used...
Question of the Day
Has the PK been used --
You're analyzing a query execution plan in SQL Server to determine whether the query optimizer chose to use a primary key index. Which Dynamic Management View (DMV) would you use to verify the usage of the primary key in the plan?
See possible answers