Distributed Computing Principles and SQL-on-Hadoop Systems
Introduction In a recent SQL-on-Hadoop article on Hive ( SQL-On-Hadoop: Hive-Part I), I was asked the question « Now that Polybase is part of SQL Server, why wouldn’t you connect directly to Hadoop from SQL Server? » My simple answer will be « Because of …
FAQs: Windows Server 1709; Fixing Windows Store on WIndows 10; DHCP Scopes
Three times a week (Monday/Wednesday/Friday), John Savill tackles your most pressing IT questions. Read through the FAQ archives, or send him your questions via email.
SQL Server 2017 CU1 is Available
On October 24, 2017, Microsoft released SQL Server 2017 Cumulative Update 1, which is Build 14.0.3006.16. This CU has 68 hot fixes by my count, which is a fairly high count. This shows that Microsoft has been busy fixing issues that have shown up since …
Improved parentheses formatting in SQL Prompt 8.1
The SQL Prompt team have made some improvements to parentheses formatting in the latest version of the tool – here are the details of what’s changed and why.
Stairway to Database Design Level 5: Procedures
Joe Celko tackles the subject of the Stored Procedure and its place in database design. What he writes is food for thought, even for experienced database developers.
Learn PowerBI and Advanced Analytics – Instructor-Led and Self Paced Training
If you are reading this blog, you must be aware that I focus on relational database and also in particular for SQL Server Performance Tuning. I always believed that any system in the world can use more performance. Well, while I focused on relational d …
First Responder Kit Release: Precon Precogs
This release comes to you from a hotel room in Chicago: The land of fiscal insolvency and one shooting per hour. It’s pretty nice, otherwise. This release is to get the pre-precon important stuff in. As much as I’d like to push all the rece …
Learning SQL Server is painful.
Blogs are free, but they’re bite-sized. They’re great when you’ve only got a few minutes, and you wanna learn a single small thing. But they’re not organized in any kind of flow at all – you’re jumping around al …
How to determine SQL Server database transaction log usage
One crucial aspect of all databases is the transaction log. The transaction log is used to write all transactions prior to committing the data to the data file. In some circumstances the transaction logs can get quite large and not knowing what is in t …
Parameter Sniffing In Action
This article will demonstrate what is parameter sniffing and how can it can kill performance
SQL SERVER – Compatibility Level 80 and Table Hint Behavior
It has been a while since I worked with SQL Server 2000. However, as an independent consultant, SQL Server never stops to surprise us. Recently, during one Comprehensive Database Performance Health Check, I found a very interesting situation which …
SQL Server 2016/2017 Internals and Tuning is Online!
I am presenting my entire SQL Server Internals training online, an hour at a time, though DB Best. Check my blog there regularly for follow-up information including the slides and scripts, a link to the recordings, and solutions to homework exercises. …
9 New Features with SQL Server 2017
Microsoft has added a ton of new features in SQL Server 2017, including expanded operating system support, Graph database capability, Python support, and more. Join Greg Larsen as he explores nine of these new features.
How Redgate use SQL Clone internally to provision databases
A common thread behind the software Redgate develop is a problem or issue they’ve come across in the software development process. They then adopt the software themselves, which gives us a real understanding of the features that need to be develo …
Azure DWH part 19: Backup and Restore SSAS
In the part 18, we created a Cube based on the Azure Data Warehouse. In this new chapter, we will work with the cube, create backups and show some tips to restore.