Latest Blog Posts
Welcome back to another episode of This Week In Data! If you missed our previous episodes, you can watch them here. In this week’s episode, we discuss why companies are deciding to move to SQL Server.
In our industry, we often hear people talking about being on or migrating to… Read more
Next week is the 2016 version of SQL in the City and you can register now to attend. It’s free and doesn’t require any travel. You can watch the event live from the comfort of your office chair.
In the many years that we’ve run SQL in the City, we’ve… Read more
In this final part of my series on SQL Server & Containers I’ll detail an option to run earlier versions of SQL Server in containers.
This post follows on from Part Three in which we uploaded a custom image to the docker repository.
The three previous posts have all been… Read more
Trying to pull data from Oracle view using linked server and getting below error. It was only when I try with particular Oracle instance, when I try to pull data from other instance using the same view it is working fine.
I got a link recently from Microsoft on building apps easily for SQL Server. At the top of the page, they ask you to pick a language and OS. Since I’ve done a little Python and I used Windows, I chose that option.
The page looks to walk… Read more
I think I just encountered my first Right join
a rare Right Join has appeared!
You use ON. It's super effective!
how often do you see them?
I've used RIGHT join maybe twice in 10 years.
No. Wait. Sorry, that was last time. This time I want to hear about backup and recovery.
Backups are one of the most common… Read more
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