Keeping a good thing going. Register here (FREE): https://www.sqlsaturday.com/755/registernow.aspx You can extend the invite to your friends and colleges if you think they’ll be interested in the topics. I'll be presenting at Nova South Eastern this Saturday afternoon at 1:30pm in Room 2066 of the Carl DeSantis Building (3301 College Avenue, Carl DeSantis Building, Davie, FL 33314). Here's… Continue reading I’ll be presenting Saturday 6/9/2018 @NovaSE – 1:30pm Room 2066
My friend asked, does SQL Server have a data type or type of index it can use to search for text in a field? Yes, use varchar. If possible, create a non-clustered index on the column or use a full-text search catalog index. You can use the Like operator or the Contains operator if you… Continue reading SQL text search – 3x faster CONTAINS vs LIKE.
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.
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
This is a step by step guide to help a friend that is looking for a quick and inexpensive way to upload/migrate his small on-prem SQL Server databases onto Azure cloud without having to use complex tools. Note: This will work on SQL Server 2012 or above with internet connectivity. SUMMARY: Create Azure… Continue reading Backup SQL Server Database(s) to Azure Blob Container
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)
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
Well, that turned out much better than expected. After receiving the news, the day before the conference, that I was selected to speak at South Florida Code Camp 2018, I shared the news with friends and colleagues inviting them to the event. Immediately, I rushed to prepare the necessary equipment and pick up my speaker… Continue reading 1st Time Presenting at SFCodeCamp 2018
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)
While my friends and family enjoyed the game, my uncle and I worked rigorously to make this video. During SuperBowl LII we edited the clip and barely got to watch the game. This was VERY hard to make, but I am happy to share the finished clip. After a few lessons learned, I plan to make… Continue reading DBA Makes His Own Super Bowl LII Ad.