This is candid recording of the live presentation I gave at Nova University on the afternoon 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: It’s a’Bot Time
Protected: Big League Questions
There is no excerpt because this is a protected post.
2019 Results: Fort Lauderdale Corporate Run
My Results: Time: 24:35 Overall: 327 Male Rank: 284 of 3200 Pace: 7:54 https://events.hakuapp.com/?registration_number=6626EE0D04DD Start Line Photos: Course: Our Tent:
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
SQLCMD variables for input SQL file
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
The DBA Workout – Literally!
This isn't that DBA workout you've probably heard of before. This is literally what it's titled. LEVEL: Beginner I meant to post this on January, because if you're like me, I had to shed a couple of pounds. Call it what you want, the tech 15, daddy weight, baby weight, whatever... Whoa, that was loaded.… Continue reading The DBA Workout – Literally!
SQL Server Read-Only Routing
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
Protected: Power BI – Follow-up Resources (Video, Slides & More)
There is no excerpt because this is a protected post.
Protected: Registration: Sealand Maersk – Dashboard in a Day @BrowardCollege
There is no excerpt because this is a protected post.
Wanna join me at South Florida Code Camp?
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?
