Imagine this: you have several directories full of SQL script files, and you need to know where a certain table is used. You’d rather like the context too, so you can check the whole SQL Expression and work out why it is running so slowly.
Generative AI is everywhere, but especially in software development. Is it helping us? Steve has a few thoughts.
Introduction This article celebrates a classic algorithm [1] of Dijkstra (1930 – 2002) which finds a path of minimal cost between any pair of nodes in an undirected graph. His procedure is widely recognized as a fundamental tool for examining communication and transportation networks (eg. Google Maps) and is surprisingly simple. By his own admission, […]
A good way to showcase your skills is by working through and documenting a project and solution. Steve notes today that this is important in today's hiring market and asks for sample projects you might suggest for others.
Lemme start this off by saying this is probably irrelevant to you. (It’s irrelevant to me, too.)
Learn how to pivot and analyze data in Power BI like you can do in Excel for fast and easy data analysis.
Today Steve has a few stories of how he's fixed poor programming practices and asks you to share your own.
The key finding from our annual ‘State Of’ survey is that there’s a need for skill diversification to keep up with the pace of technological advances in IT world.
How will this skills gap affect you?
Whether you’re just starting out in your career, you’re a seasoned data professional or you’re a senior IT leader wanting to stay ahead of business growth, join our free livestream on January 23rd.
Redgaters Steve Jones, Ryan Booz and Beca Parker will introduce key findings from the survey and offer their thoughts on the big changes coming in 2024 and what you can do to thrive in this changing landscape.
Register now
I have published videos and articles before about Lakehouse maintenance. In this article I want to address a missing point for a lot of Fabric administrators: How to do maintenance on multiple lakehouses that are located in different workspaces.
Happy New Year from Steve, with a reminder to work on your career plan for 2024.
By Steve Jones
We’re a week late, once again my fault. I was still coming out of...
By Steve Jones
I ran across this article recently (https://www.gatesnotes.com/meet-bill/source-code/reader/microsoft-original-source-code) and it has a great opening piece...
By Steve Jones
I’m in the UK today, having arrived this morning in London. Hopefully, by this...
Hi there, Has anyone else had any trouble with Database Mail in Cumulative Update...
I have a script task that tries to execute a HTTP request, which seems...
Comments posted to this topic are about the item SQL Server 2025 Standard Developer...
If I use BASE4_ENCODE() in SQL Server 2025, is the output URL Safe by default?
See possible answers