With all the security breaches in the news these days it’s important to run a vulnerability assessment on your SQL Server database. SQL Server Management Studio makes doing so simple and straight forward. Starting with SSMS 17.4 you can run an automated scan directly from the database menu.
If you’re working with SQL Server, chances are good that you have come across the need to create an index on a guid column. In some cases, although I don’t advise it, guids are used as the primary keys on every table. This typically results in a clustered index on these columns. Other times you […]