A Fine Slice Of SQL Server
Reitse Eskens is on a quest for the funny:
This month, I hosted the Tsql2sday where I asked you to write about the most funny things you did with T-Sql. I’ll happily admit it was a bit of a cheesy subject but you came out in numbers to write! Thanks for that.
Click through for seven entries this month.
Comments closedPostgreSQL has a separate command-line tool that’s been available for decades and is included with any installation of PostgreSQL. Many long-term PostgreSQL users, developers, and administrators rely on
psqlto help them quickly connect to databases, examine the schema, and execute SQL queries.Knowing how to install and use basic
psqlcommands is an essential skill to have for anyone that will connect to PostgreSQL.
Most of the article covers installation and starting up, but before you can write queries, you’ve got to connect to the server and database.
Comments closedMarco Russo and Alberto Ferrari shave of fractions of a cent:
The first reason to choose a data type is the range of numbers supported and the precision. However, the result of a mathematical operation may produce a number that cannot be represented in the chosen data type, which requires a rounding operation. Therefore, the result of one same sequence of operations can produce different results depending on the data type and the order of execution. In this article, we discuss the typical rounding behavior for each data type and how to avoid possible issues in your DAX formulas because of any differences from the results you may have expected.
Read on to learn what granularity limits exist for integers, fixed decimal numbers, and floating point operations.
Comments closedKyle Teegarden has me wondering:
Power BI is a widely used, interactive visualization tool capable of querying a variety of SQL-powered back ends. To accelerate these queries, and provide an even more responsive Power BI user experience, we’ve developed Redis SQL ODBC.
Redis SQL ODBC is a native ODBC driver that lets you seamlessly integrate Azure Cache for Redis Enterprise and Enterprise Flash tiers with Power BI. This may dramatically improve your Power BI query response times.
Knowing that the intent of Redis is individual point lookups, this was a bit surprising. Doing the queries over secondary indexes does help square that circle, however.
Comments closedHolger von Jouanne-Diedrich gives us a quick primer on R:
R is a powerful programming language and environment for statistical computing and graphics. In this post, we will provide a quick introduction to R using the famous iris dataset.
We will cover loading data, exploring the dataset, basic data manipulation, and plotting. By the end, you should have a good understanding of how to get started with R, so read on!
Click through for the intro.
Comments closedA year or two ago I built a small game prototype that featured a boss fight with a crab monster that was powered by a finite state machine. This monster waited for the player to enter its arena, then descended from the ceiling, roared a challenge, and began fighting the player.
The monster was only damageable after it finished descending. Taking enough damage would make the monster react in pain before it could attack again. Hurting the monster enough caused it to die.
Read on to see how you can model this information in a finite state machine and, from there, how to visualize it with the Mermaid library. I have used Mermaid in the past and can certainly recommend it if you need to generate diagrams programmatically.
Comments closedMark Kromer puts us in disarray:
ADF and Synapse data flows gave a Flatten transformation to make it easy to unroll an array as part of your data transformation pipelines. We’ve updated the Flatten transformation to now allow for multiple arrays that can be unrolled in a single transformation step. This will make your ETL jobs much simpler with fewer transformation steps.
Click through for screenshots showing how to use this feature.
Comments closedMeagan Longoria shows off a new preview feature:
The April 2023 release of Power BI desktop introduced a new preview feature called dynamic format strings for measures. This allows us to return values with different formats from the same measure. Previously, we needed to create calculation groups (usually by using Tabular Editor) to accomplish this. But now it is built in to Power BI Desktop.
Read on to learn good use cases for this feature, as well as a few important notes on operation and limitations.
Comments closedChris Webb gives us the why and the how:
If you’re about to put a big Power BI project into production, have you planned to do any load testing? If not, stop whatever you’re doing and read this!
In my job on the Power BI CAT team at Microsoft it’s common for us to be called in to deal with poorly performing reports. Often, these performance problems only become apparent after the reports have gone live: performance was fine when it was just one developer testing it, but as soon as multiple end-users start running reports they complain about slowness and timeouts. At this point it’s much harder to change or fix anything because time is short, everyone’s panicking and blaming each other, and the users are trying to do their jobs with a solution that isn’t fit for purpose. Of course if the developers had done some load testing then these problems would have been picked up much earlier.
With that in mind, Chris explains some of the things we can do to help with load testing in Power BI.
Comments closedPatrick Gruenauer looks for special characters:
Sometimes special characters are a nuisance. If you are trying to create some user accounts in on-premise or cloud environments, you should avoid special characters in usernames. In this blog post I will show how to find this special characters.
Click through for a regular expression-based approach, which also allows you to exclude special but not special enough characters.
Comments closed