A Fine Slice Of SQL Server
Niraj Kumar explains how two regression techniques work:
Lasso Regression is a regularization technique used for feature selection using a Shrinkage method also referred to as the penalized regression method.
Lasso is short for Least Absolute Shrinkage and Selection Operator, which uses both for regularization and model selection.
If a model uses the L1 regularization technique, then known as lasso regression.
Click through for a summary of the two techniques.
Comments closedRobert Cain continues a look at KQL query syntax:
As with other languages such as SQL, KQL has an operator for returning a unique list of values in a column:
distinct. Using this you can return the values in a column, but only once, removing any duplicate values from the result set.
Click through for a few examples of how you can use distinct as well as one terrible pun.
Tom Zika writes out a list of coding standards:
No magic constants
What is
4? Just set a variable (constant) from a lookup table. Or write a comment with an explanation.
It’s the least you can do.
Read on for a set of things I generally agree with. This one’s a little bit of a tough case, as in extremely high-performance systems where the cost of a lookup is just too expensive, I’d prefer to use keys rather than values and save the compute cost and possible worse query plan. That said, even in that case, yes, definitely write a comment explaining what 4 is. That said, had I picked any of the other dozen or so recommendations, I wouldn’t have had anything interesting to say other than “go read this.”
2 CommentsDerik Hammer discusses two management strategies for team leadership:
There are two analogies for leaders that have made a visceral impact on my life and career, the architect leader and the gardening leader. These analogies became central to my personal and professional growth ever since I formally entered management five years ago. Arguably, I have been a leader for much longer than that in the various team or technical leadership positions and my time in the military. However, it wasn’t until my focus moved predominantly to management that I began building models for leadership mindsets.
My philosophy on this hews really well with the book Turn the Ship Around! by David Marquet. I highly recommend it for anybody in management or looking to go into management. One really short synopsis of the strategy I try to follow is to make goals clear, get the level below you invested (in part by bringing them in and actually listening to what they say), and be hands-off enough to let people learn and take initiative in how they solve problems and meet your goals.
Comments closedAhmed Mahmoud looks at point-in-time recovery and answers some frequently asked questions:
On some occasions, after the failover is initiated, the current Primary DR will start a new backup chain from that point and old backups are available on the current secondary DR. If we want to restore the backups which exists in Secondary it will not allow us to perform, apparently restore cannot be initiated on the Primary as the backup is not available.
Also, sometimes we observe in secondary DR for few databases, PitR restore point is available and for few databases it shows “no restore point available”
Read on to understand why that happens and what you can do about it.
Comments closedKevin Chant values consistency:
Over the years I have worked a lot with automating T-SQL updates across multiple databases. During that time, it has become very clear that both consistency and comments are essential to make the process smooth.
Naming conventions of objects created using T-SQL should be consistent. Along with comments in your code for colleagues or anybody else who picks up your code.
Especially if you are working in a team who want to work in a DevOps related way.
I value consistency a lot but I’ve found I’m too inconsistent to be consistent.
Comments closedBob Dorr troubleshoots an issue:
When 2 or more workers are modifying the same row, it is possible to encounter 13535. The time of the begin transaction and the modification are the defining properties. When the transaction begin time is before the latest row modification, error 13535 is encountered.
Click through for an example of how you might trigger this error. This ultimately is the optimistic concurrency problem: how do you deal with multiple writers when using snapshot-based optimistic concurrency? Silently clobber or raise an error? Looks like temporal tables, like memory-optimized tables, raise an error instead of going quietly into the night.
Comments closedMike Cisneros provides tips on how to edit chart legends in Excel:
One essential element of our charts and graphs rarely gets the attention it deserves: the legend.
Without a clear and thoughtfully-incorporated legend, viewers of our data communications will struggle to understand exactly what we’re presenting to them. Any additional effort an audience needs to devote to solving the mystery of “which data series is green?” or “what’s the difference between square data markers and circles?” is energy they won’t have to put towards grasping your visual’s important insights. A well-designed legend will remove that cognitive burden.
Click through for eight such tips.
Comments closedBenjamin Smith builds an oracle but with R, not Delphi:
Knowing how to write API requests and handle their responses is a valuable skill that a developer, data
engineer or data analyst/scientist needs to know. In this short blog I share how its possible leverage DuckDuckGo’s instant answer API to create a oracle which can answer (some) of your questions using thehttrpackage and Shiny.
Click through for a simple app which does the job.
Comments closedMarco Russo diagnoses an error:
If you try to use SELECTEDVALUE on the visible column of the table generated by the Fields Parameters feature in Power BI, you get the following error:
Calculation error in measure ‘Sales'[Selection]: Column [Parameter] is part of composite key, but not all columns of the composite key are included in the expression or its dependent expression.
Read on to understand what causes this error and what you can do to resolve it.
Comments closed