A Fine Slice Of SQL Server
Getting started with Git is easy (ha!), but once you’ve mastered the basics, it’s natural for developers to start thinking about customising their git process. Most Git settings live in the
.gitconfigfile. In this blog post, I’ll discuss what you should consider setting in your config file to make a more efficient development environment.
There are some interesting settings that I hadn’t heard of, but I could see making sense.
Leave a CommentMiles Cole lays out an argument:
I’m guilty. I’ve peddled the #NotebookEverything tagline more than a few times.
To be fair, notebooks are an amazing entry point to coding, documentation, and exploration. But this post is dedicated to convincing you that notebooks are not, in fact, everything, and that many production Spark workloads would be better executed as a non-interactive Spark Job.
Miles has a “controversial claim” at the end that I don’t think is particularly controversial at all. I agree with pretty much the entire article, especially around the difficulties of testing notebooks properly.
Leave a CommentA long time ago in a galaxy far, far away, SQL Server Management Studio was included as part of the SQL Server installer.
Back then, upgrading SSMS was not only a technical problem, but a political one too. Organizations would say things like, “Sorry, we haven’t certified that cool new SQL Server 1982 here yet, so you can’t have access to the installer.” Developers and DBAs were forced to run SSMS from whatever ancient legacy version of SQL Server that their company had certified.
Working in a controlled industry, I still get to hear that answer.
Leave a CommentNivritti Suste grabs the bits:
Beginning with SQL Server Management Studio 21, Microsoft stopped providing the direct download package/binaries to install SSMS, instead it just downloads the SSMS installer. This installer then starts the installation of SSMS and downloads what is needed to install SSMS. Sometimes there may be a need to do an offline installation where you do not have access to the internet. In this article, we walk through the steps to do an offline install of SSMS.
I would have been curious about how large the installation folder is, considering that it grabs all possible options.
Leave a CommentBen Richardson checks out a new function:
Instead of building up a few different text functions on top of each other, you can now use regex inside Excel formulas to search for patterns, and clean data much more efficiently.
Our favourite of these new additions is REGEXREPLACE, which lets you find text based on patterns and replace data in one simple formula.
Read on to see how the REGEXREPLACE() function works.
Akhil Reddy Banappagari compares three popular platforms:
When you are planning database migrations to PostgreSQL, it is usually the small things that cause the biggest production bugs. One of the most common traps for developers is how different databases handle
NULLand empty strings ('').While they might seem like similar concepts, representing the absence of a value, the way a database engine interprets them can change your query results, break your unique constraints, or cause data loads to fail. In this guide, we will compare the behavior of Oracle, SQL Server, and PostgreSQL to help you avoid common migration pitfalls.
PostgreSQL and SQL Server are close in the way in which they deal with NULL and empty strings, but all three platforms have at least some differentiation, so if you’re deeply familiar with one, the next platform may trip you up a little.