Skip to content
SQL Management Studio is the must use tool for SQL database administrators, however every time I’ve needed to install it...
As a database administrator one of the important data health checks you can perform is checking that email addresses being...
When you have a date or datetime column in an SQL database, it will output a value that looks like 2017-01-01...
SQL Management Studio allows you to open a table in design mode, make changes then generate a “change script”. The...
Below you’ll find two ways to search an SQL table column for a case insensitive string. Both examples use the...
Problem When designing a table you’re unable to save the changes. When you try you receive the following message: Saving...
Problem When attempting to delete a database table row using SQL Management Studio you receive the following error message: No...