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?
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.
Learn about the differences and challenges with implicit and explicit measures in Power BI.
In this second installment of our series comparing Frappe and Laravel, we probe into critical aspects of database management and migrations.
Are you clear in your reporting. Steve notes that sometimes we might leave too much up to interpretation by the end user.
You’re running an ad-hoc query in a Microsoft SQL Server database with SQL Server Management Studio (SSMS) and need to further analyze the result set in an Excel spreadsheet. How do you export the data?
As organizations move to the cloud, the once essential role of the Database Administrator (DBA) as the guardian of system optimization, has been overshadowed, often viewed as a bottleneck to innovation. Yet, as technology evolves, the one thing I know is history repeats itself, and optimization skills are once again emerging as a critical necessity. […]
The idea of data debt seems both silly and obvious to Steve. We all have too much data and it's out of control.
Introduction JSON (JavaScript Object Notation) has become a popular data format for storing and exchanging information. Microsoft SQL Server, starting from version 2016, introduced built-in support for JSON, allowing developers to work with JSON data more efficiently within the relational database environment. This article will explore how to store, retrieve, and manipulate JSON data in […]
There may come a time when you want to or need to rename a database. In this tip we look at a couple different options.
By Steve Jones
A customer wanted a report they could email to their boss about jobs, something...
By Chris Yates
In the world of modern data infrastructure, SQL databases remain the backbone of enterprise...
Do you know if your SQL Server is really running at its best? To...
Comments posted to this topic are about the item Find Invalid Objects in SQL...
Comments posted to this topic are about the item Single User SQL Server on...
Comments posted to this topic are about the item All the Costs of Downtime
How can I start SQL Server on Linux in single-user mode to restore the master database?
See possible answers