Query Store was first introduced in SQL Server 2016 and it is amazing how far it has come in such a short time. You can already use Management Studio and Azure Data Studio to get detailed resource consumption for all your queries, such as CPU, memory, and I/O, for Query Performance Insight to give you […]
Tag Archives: Microsoft Azure
Shrink the size of your SQL database with SQL Server 2022.
14
Feb
Feb
SQL 2022 is coming and it is time to start preparing. Tempdb for SQL 2022 has some improvements and in order to appreciate them, I start with an overview/history of tempdb.
12
Sep
Sep
Microsoft in the News Today’s installment is all about a not-so-new buzzword(s): Intelligent Edge. The Intelligent Edge refers to a place, like the cutting edge. The Intelligent Edge is where the action is. This can refer to the smart watch on your wrist, a sensor placed in a vineyard, a monitor under the hood […]
05
Sep
Sep
Microsoft in the News Microsoft Canada and the British Columbia Cancer Foundation have partnered to take a radical approach to cancer research. By taking advantage of Microsoft’s AI and Azure, BC cancer researchers hope to accelerate the pace of research into some very complex problems. The BC Cancer Foundation is applying a new approach called […]
29
Aug
Aug
Microsoft in the News Not that long ago, Microsoft deployed three business apps to supplement Microsoft 365 Premium. They are: Listings, Connections, and Invoicing. In case you missed them, here is a brief rundown of what they do: Listings Microsoft Listings is a dashboard that allows you to manage your business information across Facebook, Google, […]
01
Aug
Aug
Microsoft in the News In one of my previous blogs, I talked briefly about the rate of change in our industry and how hard it is to keep up. You really have to pick your battles. There are so many industry changing technologies being developed that you cannot possibly be current in a handful of […]
22
Mar
Mar
In my last blog, we looked at steps 1 and 2 in the following diagram: In this episode of the continuing saga that is data science (the general stuff, not TDSP), we will look at parts 3 and 4. Put the Data in a Table Neither you, nor an AI can work with un-structured data. […]
