SQL Server 2017 – Deferred Name Resolution Bug.

This issue came up recently while in the midst of an upgrade to SQL Server 2017, but it's actually not related to the upgrade and has been around all along on previous versions. So I took a moment to write this, cause a friend told me it would make a nice blog post. Mad credit… Continue reading SQL Server 2017 – Deferred Name Resolution Bug.

Advertisements

Encryption and Database Source Control

Since returning from PASS Summit, I spent a rigorous amount of time developing slides & demos to share the latest technologies I learned, attempting to deliver on my pact with my CIO and Director. Yesterday, I delivered the 2nd round on that promise and received great feedback. PS. Shopping for a new tie. I intentionally focused… Continue reading Encryption and Database Source Control

I’ll be presenting Saturday 2/24/2018 @USF School of Business – 8:30am Room 118 (Tampa, FL)

Hi, I just received the news that I got selected to speak at University of South Florida Saturday, 2/24/18 at 8:30am in Room 118 (USF School of Business - BSN, 12212 USF Maple Drive, Tampa, Florida, 33620). Here’s the event info: http://www.sqlsaturday.com/699/EventHome.aspx Register here (FREE): https://www.sqlsaturday.com/699/registernow.aspx Pls fwd this invite to your friends and colleges… Continue reading I’ll be presenting Saturday 2/24/2018 @USF School of Business – 8:30am Room 118 (Tampa, FL)

VIDEO: 5 Questions from CIOs to SQL DBAs and Developers

TRANSCRIPT Hi, I’m Hiram and I’m a Database Administrator and Developer. I am recording this video to answer 5 questions I got recently from CIOs. 1. What have you done regarding DB high availability to assist with the implementation of Active/Active solutions? <See video: Answer 1 goes here> 2. Can you deconstruct how you solved… Continue reading VIDEO: 5 Questions from CIOs to SQL DBAs and Developers

I’ll be presenting tomorrow at Nova Southeastern University – 9:50am Room 2081 (Carl DeSantis Building)

Hi, I just received the news that I got selected to speak at Nova Southeastern University tomorrow, 2/10/18 at 9:50am in Room 2081 (Carl DeSantis Building). Here’s the event info: http://fladotnet.com/codecamp/Home.aspx Register here (FREE): https://eventbrite.com/e/south-florida-code-camp-2018-tickets-38099337143 Pls fwd this invite to your friends and colleagues if you think they’ll be interested in attending. There will be… Continue reading I’ll be presenting tomorrow at Nova Southeastern University – 9:50am Room 2081 (Carl DeSantis Building)

ApexSQL Add-in Errors Post-Uninstall

Delete ApexSQL or the particular add-in subfolder. From: 1. C:\Program Files 2. C:\Users\username\AppData\Local\ApexSQL 3. C:\Program Files (x86)\Microsoft SQL Server\130\Tools\Binn\ManagementStudio\Extensions 4. C:\Program Files (x86)\Microsoft SQL Server\140\Tools\Binn\ManagementStudio\Extensions 5. C:\Program Files (x86)\Microsoft Visual Studio 14.0\Common7\IDE\Extensions 6. C:\Program Files (x86)\Microsoft Visual Studio\2017\Community\Common7\IDE\Extensions Run cmd as administrator VS2015 "C:\Program Files (x86)\Microsoft Visual Studio 14.0\Common7\IDE\devenv.exe" /setup "C:\Program Files (x86)\Microsoft Visual Studio… Continue reading ApexSQL Add-in Errors Post-Uninstall