If you have a partitioned table or index in SQL Server, but you need more partitions, you can add a partition to the partition function using the ALTER PARTITION FUNCTION statement with the SPLIT RANGE argument.
When you do this, you split an existing partition into two.
Continue readingIn SQL Server, error message 116 occurs when you try to select multiple columns in a subquery without introducing it with the EXISTS operator.
Starting from SQL Server 2017, you can now install SQL Server on Linux.
More specifically, you an install it on Ubuntu, Red Hat (RHEL), and SUSE.
Below are instructions for installing SQL Server on each of these Linux distributions.
Continue readingAzure Data Studio is a graphical tool for managing databases.
It is available on Windows, MacOS, and Linux. On Linux it’s available on Red Hat (RHEL), SUSE Linux Enterprise Server, and Ubuntu.
Below is a step-by-step guide to installing Azure Data Studio on Ubuntu 18.04 via the GUI. Screenshots included.
I’ve also provided the commands for installation via the command-line in case you prefer that method.
Continue readingYou can install Azure Data Studio on to Red Hat either via the GUI or command-line.
This article outlines both methods. I’ve included screenshots for the GUI installation.
Continue readingYou’ll get error 7710 if you try to split a partition in SQL Server, but you haven’t specified a “next used” filegroup.
Continue readingIf you’ve installed SQL Server on your Red Hat machine, you’ll need some tools to connect to it and run queries, etc.
The sqlcmd and bcp utilities are a couple of good options for helping you perform the most common tasks.
Continue readingIf you’ve installed SQL Server on your SUSE machine, you’ll need some tools to connect to it and run queries, etc.
The sqlcmd and bcp utilities are good options for performing the most common tasks.
Continue readingIf you’ve installed SQL Server on your Ubuntu machine, you’ll need some sort of tool to connect to it.
Installing the sqlcmd and bcp utilities is good place to start.
Continue readingI recently installed the latest release of SSMS (SQL Server Management Studio) and saw that Azure Data Studio was automatically installed with it.
The release notes confirm that this is the case starting from SSMS 18.7 (which was released on October 20, 2020:
Continue readingBeginning with SQL Server Management Studio (SSMS) 18.7, Azure Data Studio is automatically installed alongside SSMS. Users of SQL Server Management Studio are now able to benefit from the innovations and features in Azure Data Studio. Azure Data Studio is a cross-platform and open-source desktop tool for your environments, whether in the cloud, on-premises, or hybrid