My peers and I work with customers one-on-one, but we also provide "shared" resources. I thought it'd be helpful to share what these resources are. If you're an education IT pro and work with Azure, I am sure you'll find something on this list that will help you do your job more effectively.
End-to-end (E2E) encrypted communication is valuable and necessary. Many tools provide this. Recently, I’ve started using Keybase, not only because of its ability to provide E2E encrypted messaging but also because of its additional feature set. One key feature is the ability to link your identity on Keybase to your identity on other sites, including … Continue reading Importing a key or key pair in Keybase on Windows
In two days, October 31, 2019 at noon US Central time / 17:00 UTC, I will be presenting my talk "What's New in Azure SQL Database" for the PASS Cloud Virtual Group. If you'd like to attend, you can register at https://cloud.pass.org/MeetingDetails.aspx?EventID=14249. You'll need your PASS username and password. If you're not currently using Azure … Continue reading Presenting “What’s New in Azure SQL Database” Webinar for the PASS Cloud Virtual Group
Today, seemingly out of the blue, I was unable to connect to my MSSQLLocalDB instance of SQL Server Local DB. The error message I received indicated something went wrong during the login, purportedly with a trigger. Here's how I did some troubleshooting, research, and finally figured out a non-destructive way to get back in my … Continue reading Unable to Log In to SQL Server Local DB Due to Missing MDF File
I am writing this quick blog post because of a neat feature in Azure Data Studio that is currently undocumented in the official documentation: split terminal. Azure Data Studio, like VS Code which it's based on, supports an integrated terminal. You have a choice between PowerShell, cmd, or git bash. You can have multiple terminal … Continue reading Azure Data Studio: Split Terminal
This Saturday, the Atlanta SQL user group is organizing its annual SQL Saturday. After a hiatus last year, I will be presenting a brand new talk, titled The New Tool in Your Kit: Azure Data Studio.
Microsoft has released a PowerShell module to check your device and operating system for the Spectre and Meltdown vulnerabilities. This PowerShell module is easy to install from an elevated PowerShell window: You may need to approve the installation of the NuGet provider if you haven't previously installed modules from NuGet. You will likely also get … Continue reading Check your Windows OS for Spectre and Meltdown vulnerability with PowerShell
In my post two days ago on silently installing SQL Server 2017 Reporting Services (SSRS 2017), I just provided the most basic information on configuration. In fact, after installing SSRS 2017, it will be completely unconfigured. Configuration can be done using the Reporting Service Configuration Manager GUI. In my case, the configuration needs to be … Continue reading Complete automated configuration of SQL Server 2017 Reporting Services
With the release of SQL Server 2017, Reporting Services is now a separate installation. The installer can be downloaded from the Microsoft Download Center and installed in either a free edition (Evaluation, Express, or Developer) or a paid edition with a product key. It can also be installed silently, and in this blog post, I … Continue reading Silent Installation and Configuration for SQL Server 2017 Reporting Services
The 15.5 release of SQL Server Data Tools for Visual Studio 2017 is the first release to support SSRS, SSAS, and SSIS in VS 2017. The command line below shows how to install all SSDT components in the only installation of VS 2017 on a machine: To work offline, you'll need to create a layout … Continue reading Silent, Offline Installation for SSDT 15.5 for Visual Studio 2017