This is candid recording of the live presentation I gave at Nova University on the morning of March 2nd, 2019 with South Florida Code Camp 2019. You can see the event info in my previous post. I am made this recording for the attendees that were interested to play it back at their own pace.… Continue reading Video: Real-time Sentiment Prediction in SQL Server
This was my 2nd time attending the annual conference and I barely got a chance to plan my schedule ahead of time. I pretty much selected the pre-con(s) the same day they were announced months prior, but not the general conference sessions until 2 days before my flight to Seattle, WA. I compiled this list… Continue reading My Schedule @ PASS Summit 2018
Cause sometimes you need to check why replication is slow or halted. For example, like during an IO storm - no hurricane pun intended. Say you have transnational replication over an Always On (SQL Server Availability Groups) environment that's a publisher. To see in the Dashboard just add the column, this is what it looks… Continue reading SQL Server Always On – Monitor The Redo_Queue_Size
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.
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)
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… Continue reading 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… Continue reading My Schedule @ PASS Summit 2017
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… Continue reading 2 New Things in SSMS 17.2 – I Think You’ll Like.
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