SQL Database Project in Azure Data Studio
Learn how to create and modify a database project in Azure Data Studio.
Dark Mode in SSMS 21 and overall first impressions
Let me cut to the chase. If you are like me, you may have been searching for: How to turn on Dark Mode in SSMS V21. Searching for that very thing today inspired me to write this blog to help others do the same thing because I couldn’t seem to find an easy answer.
Navigating the Database Landscape in 2025 Livestream on Feb 12
Join us on February 12th for the livestream: Navigating the Database Landscape in 2025: Simplifying Complexity. Discover the latest trends and insights from our 2025 report, learn new approaches for professional development, and gain valuable knowledge to stay ahead in your career.
No End to Programmers
The idea of chat-oriented programming has led some people to think that AI LLMs will reduce the need for programmers. Steve disagrees.
Unreliable Narrators
Steve has a few thoughts on a interview with Grady Booch, an icon in our industry, who have a great quote on AI technology.
How to use @@ROWCOUNT in SQL Server
I would like to know the number of rows affected by my SQL Server query. I know this is displayed as a message in SQL Server Management Studio, but I have to check the number of rows in an IF statement to verify if everything went alright. How can I do this in SQL Server?
Building a Data Center
A data center is a complex beast. Is it worth building and maintaining your own? Steve has a few thoughts on a data center versus a cloud.
Why you should avoid Implicit Measures in your Power BI model
Learn about the differences and challenges with implicit and explicit measures in Power BI.
Frappe and Laravel: Database Management and Migrations
In this second installment of our series comparing Frappe and Laravel, we probe into critical aspects of database management and migrations.
Words vs Data
Are you clear in your reporting. Steve notes that sometimes we might leave too much up to interpretation by the end user.
Blogs
A bespoke reporting solution doesn’t have to cost the earth
By ChrisJenkins
You could be tolerating limited reporting because there isn’t an off the shelf solution...
Presenting with Visual Studio Code
A while back I wrote a quick post on setting up key mappings in...
Advice I Like: In 100 Years
By Steve Jones
In 100 years a lot of what we take to be true now will...
Forums
Lots of FKs
Comments posted to this topic are about the item Lots of FKs
Real-time On-prem SQL Server Data in Excel – Over the Internet
Comments posted to this topic are about the item Real-time On-prem SQL Server Data...
Can You Let Go of Determinism
Comments posted to this topic are about the item Can You Let Go of...
Question of the Day
Lots of FKs
In SQL Server 2025, what are the most outgoing and incoming FK references a table can have?
See possible answers