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…

Advertisements

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…

SQL 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 @SQLPASS 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…

SQL Server 2016 AlwaysOn in Windows Server 2012R2 WFC – MultiSubnet Listener returns wrong IP address after a FlushDNS – Error Connection Timeout!

Issue: (Failover had not occurred, commands executed without pause).   Fixed. Key changes were RegisterAllProvidersIP=0, HostRecordTTL=300 (5 minutes instead of default 1200 (20 minutes)). If using .Net Framework 4.5+, recommend adding to client connection strings: MutiSubnet=True; Ref SqlClient support for HA and DR. Key steps were: Set RegisterAllProvidersIP=0 for the Cluster and LG. Set HostRecordTTL=300 (5 minutes instead of default…

SQL Server 2016 Always Encrypted – Parameterized Samples

With Always Encrypted in SQL Server 2016, if you want to Insert, Update or Filter by an encrypted column (ie. DML) the statement must be parameterized and/or use sp_executesql. Jakub shows how to do this on his post at the SQL Server Security Blog, but here's the condensed version of the article with all the sample scripts/instructions…

SQL Server 2016+ Query Store Blitz – This is AWESOME!

Check out: https://www.brentozar.com/archive/2017/06/introducing-sp_blitzquerystore/ Test it like this:   Here's the sp_BlitzQueryStore.sql - Thank you Erik Darling! If you have SQL Server 2017+ it gives you the top 3 wait stats per plan too. Download it here, via the link above or copy it and run it on Master db. Enjoy! Hiram

Loving the new UI on SSMS 17.0 – Get Ready for SQL Server 2017

If you haven't downloaded the new SSMS 17.0 I recommend you go get the free upgrade. Loving the new UI too. https://docs.microsoft.com/en-us/sql/ssms/download-sql-server-management-studio-ssms It still looks similar as before, but the subtle changes are nice. SCREENSHOTS:  New Icon: Start Menu (Yes I my workstation still has Win 7) Splash Screen: New Query Window, Object Explorer Icons, etc: Here's…