boB 'The ToolMan' Taylor
  • HOME
  • PROJECTS
    • Xel2SQL
    • SqlCommandFilters
    • Temporal Data Capture
    • Compression Estimator
  • BLOG
  • CONTACT
Select Page

Next on the menu – advanced aggregation operators

by bobtaylor29708 | May 8, 2019 | boB 'The Tool Man' Taylor, Kusto Query Language, SQL Meals™, SQL Snacks™, Uncategorized

In this longer SQL Snacks™ we will examine some advanced aggregation operators namely: make_set, make_list, mv-expand, percentiles, top-nested, min, max, arg_min, arg_max, dcount, dcountif, countif, sum, sumif, and any() The video is too long so I have created two...

Next on the menu – Where

by bobtaylor29708 | Apr 26, 2019 | SQL Meals™, SQL Snacks™, Uncategorized

In this short SQL Snack™ we examine the where operator and compare and contrast its capabilities to those of the WHERE clause in the SQL Server syntax....

Wait where can I consume Kusto data?

by bobtaylor29708 | Apr 25, 2019 | boB 'The Tool Man' Taylor, Kusto Query Language, SQL Meals™, SQL Snacks™, Uncategorized

In addition to the Kusto Explorer and the sample databases, Microsoft has provided a sample Log Analytics space for you to practice your KQL queries. Log Analytics Demo data

Are we seeing hotspots? Using Extended Events and the histogram target

by bobtaylor29708 | Feb 5, 2019 | Uncategorized

I am working with a customer in a performance and scalability lab. One of the functions they are testing is a home grown type of Change Tracking. They apply triggers, and capture the data to move to another database for analysis. They were experiencing...

An interesting customer question explained

by bobtaylor29708 | Oct 2, 2018 | boB 'The Tool Man' Taylor, Query Data Store, SQL Server Management Studio, SQL Server Tools, Uncategorized

While at a customer today I was given an interesting question. The individual was writing reports and needed to have right-justified, zero padded fields. He was investigating the FORMAT function which was introduced in SQL Server 2012. He had heard some mumblings that...

Thanks to your feedback – SqlCommandFilters has been improved!

by bobtaylor29708 | Jul 12, 2018 | SQL Server 2016, SQL Server 2017, SqlCommandFilter, Tools, Uncategorized

Thanks to reader EricEJ I have added an extension method to SqlCommandFilters which means instead of coding the call like this // Explicit usage SqlCommandFilters.Parameters.Parameterize(ref cmd); // you can now call it like this // Extension method on SqlCommand...
« Older Entries

Recent Posts

  • Last on the Kusto Query Language Menu – charting
  • Next on the menu – User Analytics Plug-ins
  • Next on the menu – Machine Learning Plugins
  • Temporal Data Capture Update
  • Next on the menu – the remaining time series functions

Recent Comments

  • bobtaylor29708 on Coming soon to SQL Snacks – A deep dive series into the Kusto Query Language
  • Darryll Petrancuri on Coming soon to SQL Snacks – A deep dive series into the Kusto Query Language
  • bobtaylor29708 on Coming soon to SQL Snacks – A deep dive series into the Kusto Query Language
  • Darryll D. Petrancuri on Coming soon to SQL Snacks – A deep dive series into the Kusto Query Language
  • boB 'The Tool Man' Taylor on SqlCommandFilters–a tool for every toolbox

Archives

  • July 2019
  • June 2019
  • May 2019
  • April 2019
  • February 2019
  • January 2019
  • October 2018
  • August 2018
  • July 2018
  • June 2018
  • September 2016
  • August 2016
  • March 2016
  • September 2013
  • August 2012
  • July 2012
  • June 2012
  • May 2012
  • April 2012
  • March 2012
  • January 2012
  • December 2011
  • November 2011
  • August 2011
  • May 2011

Categories

  • Always Encrypted
  • Azure SQL Database
  • boB 'The Tool Man' Taylor
  • Connect to SQL Server
  • Extended Events
  • Kusto Query Language
  • Power BI
  • Query Data Store
  • SQL Injection
  • SQL Meals™
  • SQL Security
  • SQL Server 2016
  • SQL Server 2017
  • SQL Server Management Studio
  • SQL Server Tools
  • SQL Snacks™
  • SqlCommandFilter
  • TDC
  • Tools
  • Uncategorized
  • XE Profiler

Meta

  • Log in
  • Entries RSS
  • Comments RSS
  • WordPress.org
  • Twitter

Designed by Elegant Themes | Powered by WordPress