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
Reverse Engineering a Physical Model Diagram
By Steve Jones
I recently wrote about a logical diagram with Redgate Data Modeler. That was interesting,...
Prepping for Certification, Part 3 of ?
By Brian Kelley
After I have understood the details for a certification test (part 1), including format...
SQL Training Black Friday Deals
By Brian Kelley
If you're looking for particular "Black Friday" deals, here is what I've seen advertised...
Forums
Best analysis approach to reduce data type length in multiple tables
Hello SSC, I hope everyone is having a happy and safe holiday season! I...
Do you separate data/log files and TempDB files on different disks using AWS EC2
Hello, I am receiving multiple direction on deploying SQL Servers in AWS EC2. ...
Service account being in local admin in AWS EC2 environment?
Hello, I am working with a company on their database administration. I am trying...
Question of the Day
A New Operator
In SQL Server 2025, what does this code return?
SELECT '1' || '0'See possible answers