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 […]
Terrible Performance of SQL Server Linked Server query over WAN
The problem I have a linked server connection between 2 SQL servers approx half the world away. One server resides in Sydney, Australia and the […]
SSIS Convert between datetimeoffset and datetime
The Problem I had a sql table that was storing data in a DateTimeOffset(7) datatype, DateDeleted. I was trying to use SSIS to sync the […]