by bobtaylor29708 | Apr 10, 2020 | boB 'The Tool Man' Taylor, SQL Server Tools, SQL Snacks™
Recently my team needed to generate large databases for performance testing purposes of a tool. We were concerned with processing times, but not with statistics etc. NOTE: This is not a statistically interesting database. It is NOT for testing query performance!!! As...
by bobtaylor29708 | Feb 15, 2020 | boB 'The Tool Man' Taylor, SQL Server Tools, Tools
While revising some training I was trying to get a current list of the DMVs in SQL 2019. Our documentation no longer provides the jumping off point page to see them. So the Toolman grabbed his circular saw, tape measure and here you go! [sql] — put in the...
by bobtaylor29708 | Jan 23, 2020 | Azure SQL Database, boB 'The Tool Man' Taylor, DevOps, OSS DBs, SQL Meals™, SQL Snacks™
Its a new year, and time to fire up the blog machine again. With the current emphasis on Open Source Software and DevOps, I will be starting several series of SQL Snacks™. One series will focus on the tools and techniques that are used to migrate Open Source Software...
by bobtaylor29708 | Jul 1, 2019 | boB 'The Tool Man' Taylor, Kusto Query Language, SQL Meals™, SQL Snacks™
In our final SQL Snacks™ for KQL, we will cover the charting capabilities that exist in the Kusto Query Language. Remember you can always export your KQL query as an M Query and use Power BI visualizations! NOTE: You can obtain all the sample code at my GitHub repo...
by bobtaylor29708 | Jun 24, 2019 | boB 'The Tool Man' Taylor, Kusto Query Language, Power BI, SQL Meals™, SQL Snacks™
In this SQL Snacks™ I will examine the User Analytics family of plug-ins. I will demonstrate a few of them but they all operate in a similar manner. One exception is the funnel_sequence which allows us to visualize causation. I will demonstrate how to execute the...
by bobtaylor29708 | Jun 17, 2019 | boB 'The Tool Man' Taylor, Kusto Query Language, SQL Meals™, SQL Snacks™
In this SQL Snacks™ I will examine the plugins that implement several basic machine learning algorithms, namely autocluster, basket, diffpatterns, and the reduce operator....
Recent Comments