SQL Server 2016 FK operator bug?
I recently read an a blog on MSDN that covered new features for the query optimizer in SQL Server 2016....
2016-07-29 (first published: 2016-07-25)
2,032 reads
Blog Posts
Why I like SQL Sentry Plan Explorer
Why I like SQL Sentry Plan Explorer. I am going to be honest here, before attending SQLSKILLS Immersion training I...
2016-07-29
643 reads
600 Miles, Limits, Fears, and Possibilities for SQLSaturday
Last week PASS published some new guidance for SQLSaturday that sets a 600 mile rule (has since been updated, still...
2016-07-28
1,348 reads
Learn About SQL Server Master Data Services 2016
SQL Server 2016 comes up with the new release of Master Data Services (MDS). In it, some new features have...
2016-07-28 (first published: 2016-07-25)
2,474 reads
Monitor Query Performance
Blog post #7 in support of Tim Ford’s (b|t) #iwanttohelp, #entrylevel. Read about it here.
Sooner or later when you’re working...
2016-07-28 (first published: 2016-07-25)
2,628 reads
Quick Scalar Tables–#SQLNewBlogger
Another post for me that is simple and hopefully serves as an example for people trying to get blogging as...
2016-07-28
936 reads
Using Context To Traverse Hierarchies In DAX
My friend and coworker Melissa Coates (aka @sqlchick) messaged me the other day to see if I could help with a...
2016-07-28
801 reads
Webinar – What’s new in SSIS 2016
I’ll be giving a webinar on the new features of Integration Services 2016.
When? August 11, 2016
Where? On the MSSQLTips.com website. You...
2016-07-28
823 reads
An update on AutoAdjustBufferSize in SSIS 2016
This week SQL Server 2016 Cumulative Update 1 was released and it contains a lot of updates/fixes for SSIS, SSAS,...
2016-07-27
2,966 reads
Bug fixes in SQL Server
SQL Server 2016 CU1 has been released and one thing I noticed was: –
FIX: Canceling a backup task crashes SQL...
2016-07-27
852 reads
Blogs
Exploring DiskANN: Part I: Understanding the Algorithm before the disk
How I used AI for this postChatGPT to generate images based on info specifically...
Learning Tool – Deepstash
By Brian Kelley
A few months ago I started using Deepstash. Deepstash breaks books into the key...
New article – migrating from a named instance
By Brian Kelley
Do you have a case where you have a named instance you'd like to...
Forums
Understanding Temp Tables and Table Variables in SQL Server
Comments posted to this topic are about the item Understanding Temp Tables and Table...
The Data API Builder MCP Server Tools
Comments posted to this topic are about the item The Data API Builder MCP...
Collecting Data Is Hard
Comments posted to this topic are about the item Collecting Data Is Hard
Question of the Day
The Data API Builder MCP Server Tools
The Data API Builder MCP Server, v2.x, includes a number of tools. What actions can these tools perform in your database?
See possible answers