A Fine Slice Of SQL Server
Erik Darling has a new stored procedure:
A comprehensive SQL Server performance diagnostic tool that quickly identifies configuration issues, capacity problems, and performance bottlenecks at both server and database levels.
Erik also has an introduction video on the topic.
Comments closedJeff Iannucci announces a new stored procedure:
Most database folks might know the tempdb database in SQL Server is used for temporary tables, but many folks don’t realize all the other things that use this critical system database.
It’s also used by table variables, cursors, aggregations, joins, and sorts. And by memory spills when you don’t have enough memory. And by integrity checks that you run regularly to check for corruption. And more.
Optimal performance of tempdb is vital, as it is involved constantly with all your database queries. So…is your tempdb configured and running optimally? And if it isn’t, can you tell why?
Click through to see how it works and where you can get a free copy.
Comments closedIn general, the process to build and manage both models and reports in Power BI can be simplified to a few sequential steps that describe the “lifecycle” of this content. You can see this depicted below, as well as some examples of the various tools that you might use to support each of these steps. Shameless plug, Bravo, Vertipaq Analyzer, and Analyze in Excel were created by SQLBI, and SQLBI is involved in the development of DAX Studio, DAX Optimizer, and Tabular Editor.
Click through for an interesting table showing what fits where. If all you’re using is Power BI Desktop, there’s a whole world of additional functionality you’re missing out on.
Comments closedYohann Mansiaux steps through the code:
We are going to see how to use these functions in VSCode, as well as introducing “breakpoints”. Breakpoints are markers that you can set in your code to pause execution at a specific line. This allows you to inspect the state of your code at that point and step through it line by line. They are very close to the
browser()function. They can also be used in RStudio IDE, but I have to admit that I never used them.
Read on to see how VSCode fills the need when it comes to debugging code. H/T R-Bloggers.
Comments closedErik Darling announces a tool.
If you’ve given Erik money in the past (which I can confirm is an easy enough task). If you’ve used sp_WhoIsActive to write to a table, you’ve got an idea of how it will work. But this looks quite a bit easier than setting it all up yourself.
And the next time you run into Josh Darnell, say thank you.
Comments closedDavid Seis looks at a powerful cmdlet in dbatools:
In this blog post, we will audit the dbatools command Invoke-DbaQuery. I will test, review, and evaluate the script based on a series of identical steps. Our goal is to provide insights, warnings, and recommendations to help you use this script effectively and safely. Invoke-DbaQuery is the Swiss army knife of all dbatools commands as you can execute almost any T-SQL script you can think of via PowerShell.
Click through for an overview of what the cmdlet does, some tips on proper usage, and an important note around possible misuse.
Comments closedMaria Zakourdaev compares technologies:
Public cloud blob storage has been a standard for data lakes for the last 10 years. Blob storage, at first, came to solve data warehouse storage limitations. It is very cheap and has unlimited capacity. You can store any data format (structured, semi-structured, or unstructured) in the data lake located on a blob storage, and keep any amount of raw data for an unlimited time. When considering Apache Iceberg vs Delta Lake, both can manage data efficiently. Depending on the access frequency, data can be stored on cold or warm types of cloud storage, saving even more costs.
Read on to see how the two techniques compare along several dimensions, as well as some general guidance at the end on which to choose.
Comments closedAndreas Bergstedt shows off a new tool:
In today’s ever-changing analytics landscape it can be difficult to plan out your next project or your enterprise analytics roadmap.
Designed to optimize data infrastructure planning, the Microsoft Fabric SKU Estimator helps customers and partners to accurately estimate capacity requirements and select the most suitable SKU for their workloads, protecting users from under-provisioning and overcommitment.
Click through for a few scenarios of translating your existing warehousing and analytical systems into expected Microsoft Fabric needs.
Comments closedGilbert Quevauvilliers makes use of a Gerhard Brueckl extension:
The default option to rebind a Power BI report is to use the Power BI REST API.
This works well, but for a lot of people this can be quite intimidating.
Fortunately, Gerhard Brueckl, has created the amazing Power BI Studio, which is a Visual Studio Code Extension.
Click through to see how to install it and how to use this extension to rebind an existing Power BI report to a different semantic model, whether in the same workspace or even a different one.
Comments closedSunitha Muthukrishna announces a new trio of VS Code extensions:
Microsoft Fabric is changing how we handle data engineering and data science. To make things easier, Microsoft added some cool extensions for Visual Studio Code (VS Code) that help you manage Fabric artifacts and build analytical applications.
By adding these Microsoft Fabric extensions to VS Code, developers can quickly create Fabric solutions and manage their data setups right from their coding environments. Here, we’ll look at these extensions and show why they’re useful.
Click through for notes on the three extensions that are available. Note that two of them are still in preview.
Comments closed