📡 BIG News – PASS Summit 2019!

I'm very excited to announce that I've been accepted as a speaker at PASS Summit 2019. I'm extremely grateful for the opportunity and look forward to PASS Summit 2019. CategorySession TitleStatusLive RecordingGeneral SessionThe Power Platform Game ChangerAcceptedYouTube VideoGeneral SessionReal-time Sentiment Prediction in SQL ServerAcceptedYouTube Video See you in Seattle, WA on Nov 5 - 8.… Continue reading 📡 BIG News – PASS Summit 2019!

Hack / Protect SQL Server – Resources 💎

Here's my Resources slide from this weekend's presentation. Stay tuned - live recording coming soon. Resources: fleitasarts.com andy.pt SQL Server R Services Samples: Microsoft Repo Pre-Trained ML Models: Install in SQL Server SQL Server Machine Learning Services: Tutorials SQL Server Components to Support Python: Interaction of Components Threading ML: Logistic Regression Interactive deep learning: Learn alert… Continue reading Hack / Protect SQL Server – Resources 💎

Sentiment Prediction – Resources 😃

Here's my Resources slide from this weekend's presentation. Stay tuned - live recording coming soon. Resources: fleitasarts.com github.com/hfleitas/SentimentPrediction ailab.microsoft.com SQL Server R Services Samples: Microsoft Repo Pre-Trained ML Models: Install in SQL Server SQL Server Machine Learning Services: Tutorials SQL Server Components to Support Python: Interaction of Components Threading ML: Logistic Regression Resource Governor: Alter External… Continue reading Sentiment Prediction – Resources 😃

Adjust for Best Performance: Windows Themes and Power

These are 2 low-hanging fruit settings that make SQL Server run better. Adjust theme for Best Performance and power option for High Performance. 0.Run.bat - Run as administrator! 1.BestPerformance.reg 2.BestPerformanceRestartThemes.cmd The script above helps tremendously when having to RDP over super-high latency networks (satellite) that have 2000+ ms (milliseconds) latency on a good day. This… Continue reading Adjust for Best Performance: Windows Themes and Power

SQL Server Always On – Monitor The Redo_Queue_Size

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