A Fine Slice Of SQL Server
If you’re interested in interactive data visualisation you’ve probably heard of the d3 JavaScript library, even if you’ve never used it or even know any JavaScript. Mike Bostock, the creator of d3, and colleagues followed this up with d3.express, which was quickly renamed to Observable.
Read on to see how you can build a simple Observable Framework app without spending a lot of time troubleshooting JavaScript code.
Leave a CommentEugene Meidinger calls out my favorite law of headlines:
If you know Betteridge’s Law of Headlines, then you know the answer is no. But let’s get into it anyway.
Recently there was LinkedIn post that made a bunch of great and valid points but ended on an odd one.
Number one change would be removing Power BI from Fabric completely and doubling down on making it even easier for the average business user, as I have previously covered in some posts.
It’s hard for me to take this as a serious proposal instead of wishful thinking, but I think the author is being serious, so let’s treat it as such.
Read on for a bit of history and why Eugene thinks this is a very bad idea.
Leave a CommentSean Gallardy digs into an interesting problem:
Quite the interesting problem was brought to me by a friend, in that they had a database level audit setup and were having `select` queries trigger audits that the object had updates run on them. The question became, how is this possible as a select query doesn’t update anything. Let’s start with a quick setup and original output.
Read on for the solution, as well as a much more common place in which you’d find this issue.
Leave a CommentAs we begin a new year in 2025, many of you are looking at new projects, new applications, trying to determine how to integrate AI into your business, modernizing your data estate, or considering an upgrade or a cloud migration. As you consider your options, let’s look at the state of the union in 2025 of Microsoft new releases and capabilities for SQL Server, Azure SQL, SQL database in Fabric, Copilots, tools, and developer experiences.
There’s a lot on the list, so check it out.
Leave a CommentAndy Brownsword points and clicks:
One of the benefits which comes with a Managed Instance is having backups taken care of for you. That also includes restores. Particularly useful is a one-click (ish) restore for a specific point in time.
Restoring a database is as easy as creating a new database, as its part of the same workflow.
Read on to see how it works, as well as one limitation around existing databases.
Leave a Comment