When Things Go Wrong in Azure
Things go wrong in IT, it is no different with the cloud. When I say cloud I am thinking quite...
2017-10-12
463 reads
Blog Posts
Automate Parameterising SSIS Connection Managers
Hello!
Back when SQL Server 2012 was known as Denali, one of the new and exciting features released was that all...
2017-10-11 (first published: 2017-10-06)
2,403 reads
Identity_Cache feature introduced in SQL Server 2017
Hello friends, Please find the full article at this link – https://social.technet.microsoft.com/wiki/contents/articles/40666.sql-server-identity-cache-feature-in-sql-server-2017.aspx
2017-10-11
469 reads
Setting a Processor Affinity in SQL Server – the (unwanted) Side-Effects
(Be sure to checkout the FREE SQLpassion Performance Tuning Training Plan - you get a weekly email packed with all the...
2017-10-11 (first published: 2017-10-02)
2,347 reads
sys.objects VS helper functions (OBJECT_ID, OBJECT_NAME, etc)
I’ve you’ve done much work with the system views (DMVs for example) then you’ve had to translate an object_id into...
2017-10-11
428 reads
Use cases of various products for a big data cloud solution
There are a tremendous amount of Microsoft products that are cloud-based for building big data solutions. It’s great that there...
2017-10-11
2,412 reads
WAITFOR isn’t a function–#SQLNewBlogger
Another post for me that is simple and hopefully serves as an example for people trying to get blogging as...
2017-10-11
1,111 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
182 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
24 reads
Why I Go to Summit Each Year?
This year will be my 6thPASS Summit that I will have attended. Some people have asked me why I still...
2017-10-11
317 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