Installing Azure Data Studio on Mac OSX
In this blog post, I describe the installation process for Azure Data Studio on Mac OSX. I’ve decided to download and install the “insiders build” from GitHub.
Read MoreQuick and Dirty - SQL Server 2008 R2 to SQL Server 2017 Migration
SQL Server 2008 R2 is quickly approaching EOL. Some are still looking for ways to migrate their databases to newer releases of SQL Server such as SQL Server 2017. This blog post details a simple method for migrating simple databases using detach and attach. By simple, I mean databases without complicated transnational replication technologies such as mirroring. I imagine this method would used for databases supporting simple applications.
Read MoreAzure Stack Benefit - Extended Support for SQL Server 2008 / 2008 R2
Microsoft SQL Server is quickly approaching End Of Life. While most customers would prefer to upgrade to the latest release, that’s not always possible. Some customers, especially in large enterprises and government, simply need more time to clean up old code in order to address deprecated features. Others maybe plan to refactor the application completely. Either way, having a few more years to transition would help several user bases. Microsoft heard these concerns and and offered a lifeline. Customers who migrate SQL Servers to Azure cloud will get an additional three years of patches for free. While at Dell Technologies World, I discovered this offer also extends to the on-premises Azure Stack.
Read MoreTroubleshooting - MS SQL Server - Cannot connect to WMI provider. [0x8004100e]
I ran into a strange error today. I attempted to launch SQL Server Configuration Manger on a server deployed in Azure, and I was greeted with an error dialog that implied either the server was unreachable or that I didn’t have rights. The error read, “Cannot connect to WMI provider. You Do not have permission or the server is unreachable. Note that you can only manage SQL Server 2055 and later servers with SQL Server Configuration Manager. Invalid namespace [0x8004100e].” After a bit of digging, I found a solution, and possibly even a root cause.
Read MoreProject Repository - Azure DB Lessons
I’ve created a new GitHub repository to track various Azure DB projects I’m working on in my spare time. Azure DB’s fully managed nature makes it somewhat different than traditional Infrastructure as a Service (IaaS) installs. There are some features (like ETL) which are not available to end users which means customers may need to reconsider some architectural decisions. My plan is to work on the basics in addition to more advanced topics related to the architectural changes. Like any side project, I can’t quite commit to timelines, but as long as I keep coming up with questions I’d like to answer, I’ll keep adding. The first project is to build a SQL DB via code. The beauty of doing this in the public via GitHub is that anyone can fork the code, or contribute.
Read MoreTip: New Azure Images Available Sql Server 2019 and Windows Server 2019
A few new images showed up on Azure. Looking through the images, one can now find images for both SQL Server 2019 and SQL Server 2019 CTP. This is an excellent way to test the new software before going live with it in production. One note is that at the time of this writing, the only version of Windows Server 2019 that’s available is datacenter.
Read MoreInstall SQL Server 2019 via Docker Container on Mac OS X
In a previous post, I wrote about setting up SQL Server 2019 via Docker container on Windows 10. Microsoft has championed the fact that they support more than just Windows. I decided to put that to the test and try running SQL Server 2019 on on Mac OS X using Docker. I figure Docker is Docker on pretty much everywhere it’s running, so this should be a piece of cake.
Read MoreInstall SQL Server 2019 via Docker Container on Windows 10
One of the big announcements from the Microsoft Ignite Conference was SQL Server 2019 being made available for public preview. Public preview means the software isn’t very far from being made generally available (GA) to everyone as a finished product. IT Pros who support SQL Server typically take a look at the new version to investigate features and understand how the software might fit into their environment. In this post I show an easy way for IT pros to try using SQL Server 2019 on a Windows 10 computer running Docker.
Read More