A Fine Slice Of SQL Server
Chad Callihan tries out schema comparison in Azure Data Studio:
Do you need a tool for comparing database schemas? Azure Data Studio can be your answer. Let’s walk through using Azure Data Studio’s Schema Compare extension.
Read on for an overview of the product.
Comments closedKoen Verbeeck does a bit of installation:
For those of you that have been working on an older version of SSIS/SQL Server (2014-2016, something like that), the BI components (SSIS/SSAS/SSRS) are now extensions in Visual Studio. SQL Server Data Tools (SSDT) is no longer available as a separate download.
So you’ll need a full-blown version of Visual Studio (make sure you only install the workflows you actually need). The good news is that you can use the community edition of VS if you’re just using it for BI development. Anyway, install VS 2022 on your machine and download the SSIS extension here.
Read on for the full installation process and a couple of warnings.
Comments closedMike Cornell announces MLflow 2.0:
Today, we are thrilled to announce the availability of MLflow 2.0. Building upon MLflow’s strong platform foundation, MLflow 2.0 incorporates extensive user feedback to simplify data science workflows and deliver innovative, first-class tools for MLOps. Features and improvements include extensions to MLflow Recipes (formerly MLflow Pipelines) such as AutoML, hyperparameter tuning, and classification support, as well modernized integrations with the ML ecosystem, a streamlined MLflow Tracking UI, a refresh of core APIs across MLflow’s platform components, and much more.
I like a lot of what MLflow does; it’ll be interesting to see how quickly different products adopt 2.0.
Comments closedLukas Vileikis continues a series on MySQL backup options:
There are many tools we can use to back up our MySQL databases. Some are well-known and used by the best technology companies out there (
mysqldumpcomes to mind), and some are a little less famous, but still have their place in the MySQL world. Entermydumper– the tool is built by the engineering team over at Percona and it‘s supposedly created to address performance issues caused bymysqldump.
Read on to see what it is and how it works.
Comments closedJason Cockington makes several recommendations of external tools for Power BI Desktop:
The External Tools ribbon is a feature that has been available in Power BI Desktop since the July 2020 release. This feature should be considered essential to anyone who is regularly working in the Power BI space. In this article I recommend my top five External Tools, that I consider essential to any Power BI developer.
Read on for the recommendations. I regularly use two of the five but these do look good.
Comments closedYochanan Rachamim explains why you might see different information between tools:
When using Performance Dashboard on Azure SQL Managed Instance you may find that percent of CPU usage is different (lower) than reported by Azure Portal for your Managed Instance.
You may wonder which is the correct value.
Click through for the answer.
Comments closedChad Callihan emulates George Jetson:
I recently saw a comment about building SQL scripts with Excel. While I haven’t gone that route before, the comment did remind me of a quick and dirty way of generating SQL statements with Notepad++ and macros. It can be helpful when you have the right set of data and repetitive steps to take.
Let’s look at an example.
Read on to save time.
Comments closedCosima Meyer explains how debugging works in R with RStudio:
Three basic commands in RStudio let you do the debugging:
debug(function_name),browser(), andundebug(function_name).With
debug(function_name)you start the debugging of your function – it’s basically like a mole that digs in. When you’re in debug mode, you can also call the objects in your function.
Read the whole thing to learn the power of debugging beyond the print() statement. H/T R-Bloggers.
Matt Allington reviews a tool:
This week I am sharing a brand new third party Power BI external tool called Measure Killer created by Gregor Brunner. At this writing, the tool is still in beta, so make sure you backup your Power BI workbooks before using this tool. In fact, that is good advice for all Power BI authoring, regardless of what you are doing.
Read on for Matt’s review of the product as well.
Comments closedOver the past month (plus or minus a couple days), I’ve shown you in a series of quick posts how I use different SQL Server Community Tools that are free and open source to troubleshoot SQL Server issues.
There’s a lot of great content from Erik here; if you haven’t already been following along.
Comments closed