Sample Use Case for Using SQLCMD Utility Batch Files
In this article, we look at a sample use case of how you can create SQLCMD batch files that can be interactive and reused in different SQL Server environments.
2023-07-14
In this article, we look at a sample use case of how you can create SQLCMD batch files that can be interactive and reused in different SQL Server environments.
2023-07-14
Steve takes a look at go-sqlcmd, the newest evolution of the sqlcmd command line tool.
2023-04-21
5,699 reads
dbForge SQL Studio gives you a few advantages over SSMS. See what Kenneth discovered during his first use of the tool.
2022-04-27
4,518 reads
Introduction I have to admit that I love SSMS. It is a great tool, and I felt furious when a colleague mentioned that Azure Data Studio will replace SSMS in the long run. In this new article, we will talk about the main differences between Azure Data Studio and SSMS. We will see if my […]
2021-11-10
22,504 reads
Create a quick application that stores your favorite queries that you can use to quickly connect to any server and return the results.
2021-03-08
As a DBA it is important to have a toolbox that supports the work you do. You need to have a toolbox that allows you to work smarter instead of harder. Read on to learn about some key tools every DBA should have in their toolbox!
2019-12-16
Dave Mason shares some thoughts on the Data Migration Assistant: I recently took advantage of an opportunity to try Mirosoft’s Data Migration Assistant. It was a good experience and...
2019-04-16
Earlier I blogged about SQL SERVER – Getting Started with Azure Data Studio. After reading the blog post, I receive an email from a reader asking about the primary...
2019-04-15
Do you still use SQL Server Management Studio or do you use Azure Data Studio? I was recently asked during my recent Comprehensive Database Performance Health Check, Well, the...
2019-04-13
The first critical task any data professional should ever learn how to do is how to connect to SQL Server. Without a connection to SQL Server, there is barely anything one could do to be productive in the data professional world (for SQL Server).
2019-03-30
By Steve Jones
I love Chicago. I went to visit three times in 2023: a Redgate event,...
By Brian Kelley
I have found that non-functional requirements (NFRs) can be hard to define for a...
You can find the slidedeck for my Techorama session “Microsoft Fabric for Dummies” on...
Testing with AG on Linux with Cluster=NONE. it was all going ok and as...
Hi, I have two tables: one for headers with 9 fields and another for...
We're trying to understand how quick new versions of SQL server can be. Obviously...
Let’s consider the following script that can be executed without any error on both SQL Sever and PostgreSQL. We define the table t1 in which we insert three records:
create table t1 (id int primary key, city varchar(50)); insert into t1 values (1, 'Rome'), (2, 'New York'), (3, NULL);If we execute the following query, how will the records be sorted in both environments?
select city from t1 order by city;See possible answers