close-up photo of audio mixer with red dim light

Installing SQL Server on Windows? Don’t forget these two useful switches

A few days ago on Twitter I wrote: Couldn’t connect to new SQL Server install because I forgot to enable TCP/IP. I’m the lead author for a Microsoft Press book about SQL Server administration. Aside from demonstrating that checklists are helpful, it did raise an interesting point about why this isn’t a configurable option in
-> Continue reading Installing SQL Server on Windows? Don’t forget these two useful switches

SQL Server logo

Fix SQL Server with one click

Tempting headline, isn’t it? It might even seem like clickbait, but that’s not the intention. The SQL Server default configuration is not recommended for production environments, and yet I have worked on many production environments that have been set up by people who don’t know that the default configurations are not recommended. These same people
-> Continue reading Fix SQL Server with one click

MySQL has this feature that SQL Server needs

In the grand scheme of things, MySQL and SQL Server operate in different realms. It’s difficult to compare them because MySQL is predominantly used for websites as part of the free LAMP stack (Linux, Apache, MySQL and PHP), while SQL Server’s range is much broader than that. There’s one neat feature that MySQL has, which
-> Continue reading MySQL has this feature that SQL Server needs

Post image

An Introduction to Azure SQL Database

It’s the second half of 2016, and Azure is the new hotness. I’ve raved about Blob Storage, virtual machines, AzCopy, and all those good things. When the dust settles, though, this blog is about managing data, and sometimes we don’t want to worry about the hassle of maintenance and administration. Azure SQL Database takes the
-> Continue reading An Introduction to Azure SQL Database

Post image

Forecast: Azure Skies Over the Amazon

Microsoft Azure and Amazon Web Services are taking over. Last week, a client approached me to migrate their complex environment in two phases from two physical data centers, first to Azure VMs, and ultimately to an Azure SQL Database, doing away with logical servers completely. In my mind, this trend is only going to accelerate.
-> Continue reading Forecast: Azure Skies Over the Amazon

Intersection of Technology and Liberal Arts

The Intersection of Art and Science

This is the first post in a series of four, where Ed Leighton-Dick, via Brent Ozar, is proposing that we SQL Server folks participate in the #SQLNewBlogger Challenge. I write a fair number of words on my personal website, and tend to neglect this site. Reading Brent’s post, it occurred to me that I can
-> Continue reading The Intersection of Art and Science