If you’re a developer or someone who prefers to work with Linux tools, but you’re stuck using a Windows operating system, then Windows Subsystem for Linux (WSL) is an excellent solution for you. WSL is a feature in Windows 10 […]
How to Set the Default Database for SQL Server Users
When you log into SQL Server using SQL Server Management Studio (SSMS) and open a new query window, you will automatically be set to use your logins default database which was set during the creation of your SQL User. This […]
Importing Flat Files into SQL Server with SSMS
SQL Server Management Studio (SSMS) offers a feature called Import Flat File, which is a streamlined version of the Import Data feature. It minimizes the need for user intervention during a file import. This feature does not include the option […]
Data Types in SQL Server
Understanding SQL data types is fundamental for anyone developing with a SQL database. Every column in a database table requires both a name and a data type. The data type serves as a guide for SQL, indicating the nature of […]
How to Filter Objects in SSMS
This guide simplifies the process of filtering objects in SQL Server Management Studio (SSMS), a handy feature often used by MS SQL DBAs to quickly locate tables, SQL logins, stored procedures, or any other objects in abundance. Finding a SQL […]
How to Change SSMS Connection Colours
SQL Server Management Studio (SSMS) is the go-to tool for the average MSSQL user, and it’s even most SQL Server Production DBA’s preference. It enables seamless querying, database management, and various tasks. It’s always been there too! One of the […]