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. Category Session Title Status General Session The Power Platform Game Changer Accepted General Session Real-time Sentiment Prediction in SQL Server Accepted See you in Seattle, WA… Continue reading 📡 BIG News – PASS Summit 2019!
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 💎
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 😃
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
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
In short, this is an example of how you do it. Set a couple of variables, use -v parameter sqlcmdVariable="%batVariable%". The following contains more details on how to use SQLCMD variables for an input SQL file. Note, I am not advising you to you use this as your routine backup method. If you're looking for… Continue reading SQLCMD variables for input SQL file
Not too long ago, I had a conversation with a friend about how SQL Server Always On Availability Groups and how they could be configured for Read-Only routing. This is a typical scenario when folks want to leverage their secondary replicas (nodes) for read-only workloads. This allows you to build an active-active cluster where one… Continue reading SQL Server Read-Only Routing
On Saturday, March 2nd of 2019 I'm presenting 2 sessions. Join me for South FL Code Camp 2019 at Nova South Eastern University in the Carl DeSantis building. You can register for this one-day free learning event here. This year I am presenting 2 sessions. Real-time Sentiment Prediction in SQL Server Track: SQL/BI - Room 2067 Time: 9:50AM-11:00AM… Continue reading Wanna join me at South Florida Code Camp?
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