What’s new in SQL Server 2017 presentation
I just uploaded a new presentation called “What’s new in SQL Server 2017”. It covers all the new features in...
2017-10-06
741 reads
Blog Posts
Compound FKs with SQL Data Generator
This is a series on SQL Data Generator, covering some interesting scenarios I’ve run into. If you’ve never tried it,...
2017-10-05
1,322 reads
dbatools Badge Ribbons at PASS Summit
One of the (many) fun things to do at PASS Summit is to check out the ribbons people have attached to their badges. Some are witty or goofy, others...
2017-10-05
5 reads
Ebook: Putting Your Head in the Cloud: An Introduction to Cloud Computing and Azure SQL Database
David is delivering his Microsoft Azure for the SQL DBA talk this weekend in SQL Saturday Denmark. Go and see...
2017-10-05
496 reads
girls + data is coming to SQL Saturday Charlotte
I am so excited to be part of the organizing team for SQL Saturday Charlotte again this year, the CBIG...
2017-10-05
368 reads
How Far Has My Update Got? Finding Out How Many Rows Your Long Running Insert, Update or Delete Has Actually Modified So Far
I’m pretty sure that we’ve all found ourselves in the situation where we’ve run an INSERT, UPDATE or DELETE script...
2017-10-05
181 reads
Just Check ALL the Boxes
Today I ran into something on a client server I unfortunately see too often. The DBA goes through the trouble...
2017-10-05 (first published: 2017-09-27)
1,661 reads
SQL Server Features Comparison at IaaS vs PaaS vs On Premise
Hello friends, Please find the link for my blog here – https://social.technet.microsoft.com/wiki/contents/articles/40295.sql-server-features-and-basic-comparison-at-iaas-vs-paas-vs-on-premise.aspx
2017-10-05
524 reads
Visual Studio 2017 Irritants From the SSIS Developer View
I was among the many Integration Services (SSIS)/Database (DB) developers out there that cheered when Microsoft finally announced support for...
2017-10-05
805 reads
Azure SQL Database Data Integrity Checks
If you remember last month I wrote about DBCC CHECKDB and Azure SQL Database, more specifically whose responsibility (Microsoft’s) it...
2017-10-04
525 reads
Blogs
Walking Through a Planned Failover: SQL Server Availability Groups on Kubernetes
When building the sql-on-k8s-operator, I wanted to make sure it could handle both planned...
Reading SQL Server File Headers with DBCC FILEHEADER
I’ve been doing a deep dive into SQL Server on-disk structures lately, and one...
T-SQL Tuesday #197 – An impactful session or two from a conference – RECAP
By DataOnWheels
Thanks to everyone who joined the blog party this month. I noticed three themes...
Forums
The Vector Data Type
Comments posted to this topic are about the item The Vector Data Type
What Power BI DirectQuery does to your SQL Server (and how to fix it)
Comments posted to this topic are about the item What Power BI DirectQuery does...
The New OS Wars
Comments posted to this topic are about the item The New OS Wars
Question of the Day
The Vector Data Type
What is the vector data type in SQL Server?
See possible answers