Pawan Khowal walks us through a Python puzzle:
In this puzzle we have to find un-common words between two strings
Sample Input List
a = ‘Hi I am Pawan here only’
b = ‘here only’
Click through for the solution.
Comments closedA Fine Slice Of SQL Server
Pawan Khowal walks us through a Python puzzle:
In this puzzle we have to find un-common words between two strings
Sample Input List
a = ‘Hi I am Pawan here only’
b = ‘here only’
Click through for the solution.
Comments closedSteve Stedman walks us through a pain point when using replication:
SQL Server replication requires the actual server name to make a connection to the server. Specify the actual server name. (Replication.Utilities).
You might be thinking to yourself that you had a typo in the server name, but no, after checking the server name it matches what you can connect with.
When I’ve seen this error, often it will even tell me the server name it’s expecting, which then makes me ask why I have to type it in if it knows already.
Comments closedAndy Leonard diagnoses a problem:
I clicked the “More” link to display details in the blue box
To provision new Integration Runtime, Azure SQL DB server should not have existing SSISDB. If this SSISDB was once associated with an SSIS IR, you can re-associated it with another SSIS IR (for more info see here).
Click through for Andy’s solution to the problem.
Comments closedGreg Gonzalez announces the news:
SolarWinds recently announced the intention to acquire SentryOne, an event that promises to make life even better for the IT and data professionals who use our products. Both companies have historically focused—in their own ways—on solving real-life problems for customers by providing high-quality solutions.
I do wonder what will happen given that SolarWinds already has a database monitoring tool; will they keep the two separate, combine them together, or do something else?
Comments closedMichael J. Swart uses In-Memory OLTP:
At D2L, we’re the perfect candidate customer for In Memory OLTP features, but we’ve held off adopting those features for years. Our servers handle tons of super quick but super frequent queries and so we find ourselves trying to address the same scaling challenges we read about in Microsoft’s customer case studies.
But there’s only one In Memory feature in particular that I care about. It’s the Memory Optimized Table Types. Specifically, I’ve always wanted to use that feature to avoid tempdb object allocation contention. Recently I finally got my chance with a lot of success. So even though I could say I’m happy with In Memory features, I think it’s more accurate to say that I feel relieved at having finally squashed my tempdb issues.
We’ve used memory-optimized table types for a couple of years to solve exactly this problem and the plan was pretty much the same as what Michael put into action.
Comments closedAlex Velez shares some thoughts on trendlines:
A trendline is a line drawn on a chart highlighting an underlying pattern of individual values. The line itself can take on many forms depending on the shape of the data: straight, curved, etc. This is common practice when using statistical techniques to understand and forecast data (e.g. regression analysis). Determining the best fit and forecasting is beyond this article’s scope, so if you’re interested in learning more, I recommend Anna Foard’s Stats Ninja website. Instead, I’ll focus on various considerations related to visualizing trendlines when communicating data.
My main thought on trendlines is that they are less important than the data points. We make up the trendlines out of thin air; the data points actually exist and actually matter. Trendlines can be useful, but they don’t replace the data.
Comments closedJohn Macintyre shares some Azure Synapse Analytics samples:
To further accelerate time to insight in Microsoft Azure Synapse Analytics, we are introducing the Knowledge center to simplify access to pre-loaded sample data and to streamline the getting started process for data professionals. You can now create or use existing Spark and SQL pools, connect to and query Azure Open Datasets, load sample scripts and notebooks, access pipeline templates, and tour the Azure Synapse Studio—all from one place.
Click through for details on the samples.
Comments closedDavid Eldersveld takes a look at a new sample data set in Power BI Desktop:
With the October 2020 release of Power BI Desktop, Microsoft has incorporated a sample dataset directly into the product. While there are a few commonly used training and demo datasets already, there are benefits to having a basic starter Financials dataset included.
This data can accelerate the learning experience for new users, particularly those who may only need to focus on authoring reports on existing datasets at their organization and don’t need to immediately know much about data modeling.
Click through for David’s mixed review.
Comments closedShane O’Neill needs a better data model:
Once you have the total per row, you throw in a
SUM(that total) OVER ()
and you have a grand total. Thank you to Kevin Wilkie ( blog | twitter ) for re-igniting my curiosity about Window Functions again.
Click through to see a result in SQL Server and then trying to replicate it in Powershell. It’d be a lot easier, though, with a properly normalized data model which includes date, attempt number, and push-ups in that attempt. Pivot those results at the end if you want this sort of report, but SQL is designed to work best with tables in first normal form or higher.
Comments closedErik Darling takes us through the seedy underbelly of T-SQL:
I have to do this a fair amount, and I always go look at this little cheat sheet that I have.
Then it occurred to me that it might be worth sharing the details here, in case anyone else runs into the same need.
The way I learned to do it is with SUBSTRING and CHARINDEX, which is a pretty common method.
That this is possible is great, but it’d be nice to have an easier approach. Thinking through that easier approach is outside the scope of this post…
Comments closed