Backup SQL Server Database(s) to Azure Blob Container

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…

Advertisements

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…

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…

1st Time Presenting at SFCodeCamp 2018

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…

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…

DBA Makes His Own Super Bowl LII Ad.

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…

PASS Summit 2017

Today was another good day at work. Since returning from summit, I spent a rigorous amount of time developing slides & demos to share what I learned, attempting to deliver on my pact with my CIO and Director. Well, that came true today in full-circle & the feedback was amazing! Recording: Slides: This is a…

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…

My Schedule @ PASS Summit 2017

Here's my week's schedule - narrowed down with help of friends, for my 1st time at SQL PASS Summit 2017 in Seattle, WA. Here's the full conference schedule: http://www.pass.org/summit/2017/Sessions/Schedule.aspx My Schedule: Precon: Mon: Data Modeling with Power BI (603, Marco) Tues: Columnstore Indexes – Practical Solutions & Techniques (606, Niko) Conf: Wed: 1015am: Benchmarking & Testing In-Memory OLTP…

2 New Things in SSMS 17.2 – I Think You’ll Like.

QueryStoreUI reports now supports additional metrics (RowCount, DOP, CLR Time etc.) from sys.query_store_runtime_stats. Performance Dashboard server report now available as a default report: Can connect to SQL Server 2008 and newer versions. Missing indexes sub-report uses scoring to assist in identifying most useful indexes. Historical wait stats sub-report now aggregates waits by category. Idle and…