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 and later versions that…
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 guide shows how to…
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 to save the import…
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 the data within each…
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 Server Object While the…
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 features that many users…
_
Hi, my name is Peter Whyte. I’m an experienced SQL Database Administrator (DBA) & Blogger, working remotely from home in Edinburgh, Scotland.
I help maintain High Availability SQL Server database environments, troubleshoot issues, and optimize performance within my role as a Site Reliability Engineer (SRE) at GoDaddy. This blog includes a lot of information and skills required working as a SQL Server DBA.