Visual C++ Redistributable for Visual Studio. The listed items are provided as links to the corresponding download pages where you can fetch the necessary files. MySQL Workbench Windows Prerequisites: To be able to install and run MySQL Workbench on Windows your system needs to have libraries listed below installed.
![]() ![]() ![]() Sql Serer Client Install And RunIf my laptop bites the dust when I’m on the road, or if I need to get a few minutes of work in on vacation, then any web browser will get me most of the way there. We don’t get VPN access or anything like that, so it keeps the client work simple and fast.And then I try to use web services for as much as possible, like Expensify, Quickbooks, etc. Our SQL Critical Care® is about mentoring, so we’re walking people through their own servers, showing them what to look at while we investigate the root cause together. WebEx – for client work. PowerPoint & Excel – yeah, technically there are online equivalents of these, but I haven’t been satisfied with them, especially with the amount of training classes I teach. (Why VMware and not Parallels? I just started with it because I used to be a VMware admin, and it works fine.) In very rare cases where a client wants me to VPN into their environment, I’ll build a separate VM for each client to avoid VPN client hassles. I do a lot of work in the cloud, but 2 local VMs get heavy use: SQL2017 to build & show demos, and SQL2019 for R&D work. VMware Fusion – to run virtual machines. Slack – although now that I think about it, I might be able to switch over to the web version of that now. Plus, powerful filters & muting rules keep you blissfully ignorant of the rants. Pay $10 and make that garbage go away. Download folder – shortcut because when you work in GMail, you end up downloading a lot of attachments and editing them locally, like signing PDFs. Github – for source control of the First Responder Kit, SQL ConstantCare®, internal apps I try to write my T-SQL queries from scratch here, without IntelliSense, just to see if I can, hahaha. Textmate – my favorite text editor. In practice, ADS’s execution plan experience isn’t quite there yet, and I want the students to see the same user interface they’re used to using every day (SSMS).When I need to edit Power BI reports – despite thousands of votes, Microsoft doesn’t plan on bringing Power BI Desktop to the Mac. In theory, I could run SQL Server in a Docker container and run queries in Azure Data Studio. My training classes generally involve performance tuning servers, indexes, and queries. These days, I only start a VM under 2 scenarios:When I need to build or deliver SQL Server demos – I fire up a VM with SQL Server 2017 or 2019 running. Can you copy os x from mac mini to install new hard drive for imacI wouldn’t want one client’s VPN update to hose someone else’s connection.If I was a full time DBA for a company with only a handful of production servers, or a development DBA doing performance tuning work on just a handful of applications, I’d still have a Mac as my primary desktop, but I’d use a jump box to run SSMS and SentryOne Plan Explorer.If I was a full time DBA with dozens or hundreds of SQL Servers, I’d probably switch back to Windows and focus on automating my work with PowerShell. I’d still aim for one VM per client just because VPN software can be so terrible. This would be different if I had a different job.If I was a remote DBA contractor, like if I had to regularly jump in and fix broken Agent jobs, then I’d probably have a lot more VMs.
0 Comments
Leave a Reply. |
AuthorTim ArchivesCategories |