SQL setup cannot continue because one or more components in the ‘Microsoft ODBC Driver 17 for SQL Server’ installation are missing
SQL Server 2022 Patch – Blocked by SSISTELEMETRY160
Cannot patch SQL Server due to SSISTELEMETRY160 service running?
Generate EntityFramework CodeFirst Model from SQLServer
Generate EntityFramework Entity Class from SQL Server Table
The certificate chain was issued by an authority that is not trusted – FIXED
The Issue When moving from EntityFramework v6.0 to v7.0 you may get the following exception. The fix The fix is very simple. Just add the […]
SQL Server – Shrink Log files Issues
The issue You are trying to shrink your database but the system will not release the space to allow you to shrink the log files, […]
Reset SQL Server SA Login via Powershell
The Problem You have lost or forgotten the SA password for you SQL Server box!! The solution This is really easy to fix. On the […]
Grant Connect SQL Server – TSQL
The issue You are having connection problems to the database and all the permissions look correct but you cannot login.Fire up the SSMS and expand […]
SQL Server Management Studio on Hi Res Screen
The problem You are using SSMS on one of these new wizbang hi res screens and all the dialogs are tiny and small and you […]
SQL Server Script user with SID
The Problem When you move sql logins around servers the logins are created with an SID that uniquely identifies the login. Assume you setup two […]
T-SQL Drop temp table if it exists
The Problem I often work in SQL Server with temp tables and they can be a pain when developing as you may have code like […]