Power BI and The Matrix: A Challenge
In this article, I will show an example to demonstrate some interesting techniques using the Matrix visual. This was inspired by a friend, Albert Herd, who asked for some help in our Malta user group to solve a problem. The data used in the example is …
The BI Journey: The Expert’s Advice – Part 2
The series so far: The BI Journey: The Analyst The BI Journey: The Expert’s Advice – Part 1 The BI Journey: The Expert’s Advice – Part 2 Ruthie, the intern at the AdventureWorks sales department was in her final stages of buildi …
Blog Relocated
My blog here has moved to sql.kiwi Please update your bookmarks and other links….(read more)
SQL SERVER – Difference Between Azure Data Studio and SQL Server Management Studio
Earlier I blogged about SQL SERVER – Getting Started with Azure Data Studio. After reading the blog post, I receive an email from a reader asking about the primary difference between Azure Data Studio (ADS) and SQL Server Management Studio (SSMS) …
Canine Corgi Completion Contest
At our recent SQL in the City Streamed, Kendra had this wonderful quote during one of our ad hoc, group discussions: “There is an urgent message in the bathroom at Redgate…” We eventually got to learn what the message was, but I thou …
Service Broker Part 1: Service Broker Basics
Part 1: Service Broker Basics Microsoft first introduced Service Broker as part of the relational engine of SQL Server 2005. Service Broker is an asynchronous messaging framework with which you can implement scalable, distributed, high available, relia …
4 Top Tips for starting your database DevOps journey
The post 4 Top Tips for starting your database DevOps journey appeared first on SQLServerCentral.
Does ARITHABORT Setting Negatively Impact SQL Server Performance? – Interview Question of the Week #220
Question: Does ARITHABORT Setting Negatively Impact SQL Server Performance?Answer: Yes.Let us understand the answer a bit more in detail. When the ARITHABORT is set to ON in your logon sessions, you are in safe hand but due to any reasons, if you turn …
Intel Optane Technology and SQL Server
You may have heard of Intel Optane Technology, but perhaps you aren’t quite sure what that term actually refers to, and whether it is relevant for SQL Server. Unfortunately, Intel Optane is an overloaded marketing term that covers several differe …
SQL SERVER – Getting Started with Azure Data Studio
Do you still use SQL Server Management Studio or do you use Azure Data Studio? I was recently asked during my recent Comprehensive Database Performance Health Check, Well, the answer is I am still using SQL Server Management Studio (SSMS) as I find it …
Logistic Step 1: Connecting Via SQL Slack for Server Performance Tuning Practical Workshop for EVERYONE
It is just 12 days before we have a SQL Server Performance Tuning Practical Workshop for EVERYONE. If you have ever attended any of my previous SQL Sessions, you know that the session will be extremely interactive. Many of you have asked me how wi …
Manage SQL Server Agent History More Effectively
The post Manage SQL Server Agent History More Effectively appeared first on SQLServerCentral.
SQL Server Diagnostic Information Queries for April 2019
This month, I have just made some minor improvements to most of the query sets, mainly in the comments and documentation. I have been trying to fix the broken links to many Microsoft blog posts that resulted from Microsoft’s recent massive web si …
Finding Froid’s Limits: Testing Inlined User-Defined Functions
This week, I’ve been writing about how SQL Server 2019’s bringing a few new features to mitigate parameter sniffing, but they’re more complex than they appear at first glance: adaptive memory grants, air_quote_actual plans, and adapti …
SQL SERVER – FIX: Install Error: A Network-Related or Instance-Specific Error Occurred While Establishing a Connection to SQL Server
One of the most common connectivity errors which I have heard about it is “A network-related or instance-specific error occurred while establishing a connection to SQL Server.” In this blog, we would learn about how to fix this error if it …