The quest for randomness in SQL Server leads us to two prominent players: RAND() and NEWID(). This blog post shows examples of both functions, exploring their capabilities, use cases, and the subtle distinctions that set them apart when generating random […]
How to Open SSMS with a Different Domain User
If you’re working with SQL Server in a corporate environment, you may need to connect to the server using a different Domain User account. For example, you may need to test the access and permissions of newly created SQL Server […]
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 […]