Data About Execution Plans
If you look at the Properties for the first operator of a graphical execution plan, you get all sorts of great...
2017-01-23
525 reads
The Scary DBA
Scheduling Statistics Maintenance in Azure SQL Data Warehouse
The power and capabilities of Azure SQL Data Warehouse are pretty amazing. However, it’s still basically SQL Server under the...
2017-01-25 (first published: 2017-01-18)
1,100 reads
Query Optimizer and Data Definition Language Queries
Data Definition Language queries don’t go through the optimizer, right? While normally, my short answer to this question in the past would...
2017-01-10
584 reads
Database Configuration
It’s amazing just how much the landscape changed with the release of SQL Server 2016 SP1. For example, I just...
2016-12-20
452 reads
PASS Board: Year-End Wrap-Up
This month concludes my second full year on the PASS Board of Directors and my first full year on the...
2016-12-19
403 reads
OPTIMIZE FOR Hints When Parameter Sniffing is Turned Off
While presenting recently and talking about dealing with bad Parameter Sniffing, I got the question; what happens to OPTIMIZE FOR...
2016-12-12
609 reads
Presentations for SQL Server Beginners
Tired from all those blog postsFor my final blog post in the #gettingstarted, #iwanttohelp series, I decided to curate a...
2016-12-23 (first published: 2016-12-05)
3,275 reads
Database Clone
There are a bunch of ways you could create a database clone. Backup and restore is one method. Export/Import is...
2016-12-19 (first published: 2016-11-28)
2,544 reads
PowerShell to Test a Query
So you want to do some tuning, but you’re not sure how to test a query on it’s performance. Not...
2016-11-23
1,335 reads
SQL Server on Linux: Boring
As a concept, SQL Server on Linux is thrilling. Due to this, the OS doesn’t stand in the way of...
2016-11-22
628 reads
Blogs
Advice I Like: Experience and Aptitude
By Steve Jones
Experience is overrated. Most breakthrough accomplishments were done by people doing them for the...
Plan Time for Self-Development
By Brian Kelley
As you begin the new year, if you don't already have time set aside...
BK’s Bookshelf: Never Split the Difference
By Brian Kelley
I picked up Never Split the Difference: Negotiating As If Your Life Depended On...
Forums
The Rise of Data Centers
Comments posted to this topic are about the item The Rise of Data Centers
Data API Builder APIs
Comments posted to this topic are about the item Data API Builder APIs
Why you should avoid Implicit Measures in your Power BI model
Comments posted to this topic are about the item Why you should avoid Implicit...
Question of the Day
Data API Builder APIs
What formats of API endpoints can the Data API Builder present to clients when exposing the database?
See possible answers