A Fine Slice Of SQL Server
In this video, we will take a look at two KPIs for measuring avidity. We will also show off how to use ranking window functions to order groups of customers.
Click through for the video. There are far too many measures of avidity for me to do a good job explaining them all, and so many of them are closely tied to the specific nature of the business, but hopefully this at least gives you ideas of how the business side may look at user avidity or stickiness.
Comments closedIn this video, we will take a look at several useful KPIs for measuring sales. We will also demonstrate the utility of the APPLY operator, the WINDOW clause, and the APPROX_PERCENTILE_CONT() function.
I enjoyed putting this one together, because I enjoy it any time I have a chance to talk about the APPLY operator.
Comments closedIn this video, we will take a look at several useful KPIs for measuring customer growth. We will also demonstrate the utility of DATETRUNC(), calendar tables, and the LAG() and LEAD() window functions.
The calendar table (or date dimension) interlude may seem a little bit weird at first, but I firmly believe that calendar tables absolutely belong on basically every SQL Server instance, even if only in a utility database.
Comments closedIn this video, we will dive into three of the most common financial key performance indicators: revenue, cost, and profit. We’ll also take a look at several T-SQL techniques, including aggregation, window functions, and common table expressions.
Click through for the video. This is the first video in the series in which I really dig into specific KPIs and SQL techniques.
Comments closedI’ve started a new video series:
In this video, I provide a primer on the concept of key performance indicators. Along the way, we’ll talk about common warehousing terminology such as facts, measures, grain, and additivity.
This is all based on a talk I don’t get to give very often, so instead I’m turning it into a five-part video series.
Comments closedIn this video, I show you what’s changed with Azure ML Designer model deployment and how you can work around a new error. I also show how to deploy an Automated ML model.
Click through for the video. This video is based on a mildly annoying change in the Azure ML Studio website.
Comments closedIn this video, I demonstrate how much information we can gain from one sample of a distribution.
Some aspect of this is “that’s a neat parlor trick” but it does speak to the marginal information gain of a small amount of data.
Comments closedIn this video, we will learn how to use Minion Backup to automate backup operations, including setting backup frequency, dynamic backup tuning, and scripting out database restorations.
This video wraps up a series on backup and recovery in SQL Server. Now I have to come up with some new videos.
Comments closedIn this video, I show how to back up and restore SQL Server databases in piecemeal form, using filegroups to manage read-only versus read-write data, and bringing the most important data back online sooner in a recovery scenario.
I found the process to be a bit trickier than I had first expected, so I’m hoping this video has enough legs to prevent others from running into some of the problems I experienced.
Comments closedIn this video, I cover several configuration options for tuning SQL Server backup operations. I’ll talk about what options are available and which ones are important.
This is another long video (at least for YouTube), but I cover a lot of useful information, if I say so myself.
Comments closed