Latest Blog Posts
In this module you will learn how to use the Sankey Power BI Custom Visual. The Sankey is a type of diagram that visualizes the flow of data between a source and destination.
Module 28 – Sankey
In-Memory OLTP (A.K.A. Hekaton) is a specialized, memory-optimized relational data management engine and native stored procedure compiler, integrated into SQL Server.
Microsoft designed In-Memory OLTP to handle the most demanding OLTP workloads. To accomplish this, In-Memory OLTP introduces two fundamentally new concepts: memory-optimized tables and natively compiled stored procedures.
Data… Read more
Today I released a new version of the sp_WhatsupQueryStore stored procedure. sp_WhatsupQueryStore returns many configuration and performance metrics that are stored inside the SQL Server Query Store through an easy to use stored procedure.
In version 1.1 many new optional parameters are added that influence the output of the stored… Read more
“Wow! A family, a marathon, and two businesses! So how do you keep up with it all?” asked Twitter. “Work-life balance,” she replied, glancing furtively at her sparsely populated blog. Fin (P.S. The latest blog on MinionWare.net, at least, is What Really Causes Performance Problems?)
For my final blog post in the #gettingstarted, #iwanttohelp series, I decided to curate a set of presentations from the PASS Virtual Chapters. This content is available online. It’s free. Most importantly for the person just getting started as a SQL Server data pro,… Read more
Being disruptive is a powerful way to conduct business. Steve Jobs and Bill Gates insisted that computers belonged not just in business offices but in the homes of regular joes, and built businesses around a need that had not fully manifested itself. Twitter disrupted the social media space by bringing… Read more
So far I’ve worked on simple analytical techniques using one or two variables in a dataset. This article is a sort of a summary – about various techniques we can use for such datasets, depending on the type of variable in question. The techniques include – how to get summary… Read more
You are the DBA your company makes you. Aren’t you?
SQL Server has such a wide range of features that no DBA role will implement all of them. So, you use a certain subset in each role that you occupy throughout your career. What those features are depends on the… Read more
I work on a few projects and have a bunch of demos setup, but I don’t work on them all every week. Being only semi-creative like many of you, I end up with some similar projects with similar names. When I wanted to determine which project was linked to which… Read more
VIEW SERVER STATE permission was denied on object 'server', database 'master'. (Microsoft SQL Server, Error: 300)
More dbatools experimentation for me. This is a great set of Powershell cmdlets that solve simple, handy problems. In this post, I want to look at Copy-SqlJob, which will allow me to easily move jobs from one instance to another.
The Job Subsystem
Jobs in SQL Server are part… Read more
People who have been working for a while with Integration Services probably know the legendary blog post by SQL Server MVP Jamie Thomson: Suggested Best Practises and naming conventions. The blog post served as a guidance point for many SSIS projects regarding naming conventions of the various tasks and… Read more
Another week almost over so here’s a random selection of articles that I’ve been reading…
Changing the SQL Server port on Linux
Denis Gobo goes through the process of changing the port that an instance of SQL Server running on Linux is listening on