A Fine Slice Of SQL Server
Andy Leonard troubleshoots an error:
Have you encountered this error: “Failed Get Parameter Info of parameter ____”? I ran into this error a couple times while consulting for a client to lift and shift SQL Server Integration Services (SSIS) to Azure Data Factory (ADF).
Click through for an example and what is the most likely cause of the problem.
Comments closedBob Rudis creates an R package:
HTTP Headers Hashing (HHHash) is a technique developed by Alexandre Dulaunoy to generate a fingerprint of an HTTP server based on the headers it returns. It employs one-way hashing to generate a hash value from the list of header keys returned by the server. The HHHash value is calculated by concatenating the list of headers returned, ordered by sequence, with each header value separated by a colon. The SHA256 of this concatenated list is then taken to generate the HHHash value. HHHash incorporates a version identifier to enable updates to new hashing functions.
Read on to see when it might be useful and other things you should know about the package. H/T R-Bloggers.
Comments closedLaetitia Avrot looks at the logs:
If you’re one of my customers, you might know how I insist on monitoring your Postgres logs and digging into them to find precious insights on what’s going on with your Postgres. For a long time now, there is pgBadger. For PGSQL Phriday #010, Alicja asks us to focus on pgBadger.
You might be surprised to find out I am not using pgBadger. I will explain why later, but keep assured that I do think pgBadger is a good tool. It will help DBAs get better performance and follow how their instance is doing before there is a very bad problem.
Click through for Laetitia’s reasons as well as an alternative way of analyzing log files.
Comments closedSean Gallardy shuts it all down:
I was sent a quite an interesting email stating that SQL Server would not shut down. Attempting to stop the service via services or the SQL Server Configuration Manager resulted in a timeout with SQL Server still running. Trying to execute the
shutdownwith and withoutNOWAITT-SQL command resulted in the same, the process still running. Seems quite weird that SQL Server just refuses to shutdown!
Click through for Sean’s investigations, what the result was, and how the customer ultimately decided to deal with it.
Comments closedDavid Klee has a series for us:
My SQL Server on VMware Accelerator boot camp video series is now live on Youtube! There’s no strings attached and no price of entry, so now there’s no reason why you can’t join me in this adventure to learn more about how to performance and availability tune your SQL Server on VMware data estate.
Eyeballing this, it comes in at about 8 hours of content. And if you want to learn all about virtualization of SQL Server, I’m not sure there’s a better person to learn from than David.
Comments closedChris Webb gives us some performance testing advice:
If you’re excited about Direct Lake mode in Fabric you’re probably going to want to test it with some of your own data, and in particular look at DAX query performance. Before you do so, though, there are a few things to know about performance testing with Direct Lake datasets that are slightly different from what you might be used to with Import mode or DirectQuery datasets.
Chris shares some great advice and takes us through a good approach for testing. This post is all about the how, not the results.
Comments closedSoheil Bakhshi takes us through some terms:
In this blog post, I will explain some of the key concepts, personas, and terminologies related to Microsoft Fabric, a SaaS analytics platform for the era of AI. If you are not familiar with the basic concepts of SaaS analytics platforms and how Microsoft Fabric fits in, I recommend you read my previous blog post, where I explain them in detail.
Click through to learn more about what terms like “tenant,” “capacity,” and “persona” mean in the context of Microsoft Fabric.
Comments closedAnthony Nowocien takes us through a useful tool:
This week, #PGSQLPhriday is hosted by Alicja Kucharczyk. Every month, one community member proposes a new subject to this monthly blogging event and let the world (or your family/friends/neighbors if you prefer) know all about pgBadger. It’s a tool to analyze your PostgreSQL logs and present you a nice web report.
If you like some history, it has been developed by Gilles Darold since more than 11 years, as v1.0 came along on June the 10th in 2012. At this time, pgfouine was the main log analyzer and the complete Perl rewrite was greatly performance influenced. In V4, it started to have its current look, by embarking the Bootstrap library and fonts.
Click through to see what pgbadger does and an example of how it makes log analysis understandable.
Comments closedSteven Sanderson renames a file:
Managing files is an essential task for any programmer, and when working with R, the
file.rename()function can become your best friend. In this blog post, we’ll explore the ins and outs offile.rename(), discuss its syntax, provide real-life examples, and share some best practices to empower you in your file management endeavors. So grab a cup of coffee and let’s dive into the world offile.rename()!
Click through for two examples. But do read the documentation if you’re running on Windows and dealing with symbolic links.
Comments closedPeter Baranovskiy doesn’t want bog standard but is okay with mostly standard:
There are multiple ways to style or theme a Shiny app. A high-level overview is available in the Mastering Shiny book by Hadley Wickham. Here I’ll show the easiest way to do this. If you need to build an entirely – or mostly – new Shiny theme (e.g. a corporate theme), this post is probably not for you. In that case
bslibmay be the best starting point. Otherwise, if you are generally happy with a pre-made theme and just want to tweak some of its elements, read on.This post is based on an actual app, so that you can see how it all works. Here’s the app’s source.
Click through to see what kinds of changes you can make without a major overhaul.
Comments closed