Scalegrid
APRIL 16, 2020
AWS , Azure. AWS , Azure. AWS , Azure. AWS , Azure. AWS , Azure. AWS , Azure. AWS , Azure. AWS , Azure , DigitalOcean. Are you a startup that has free AWS or Azure hosting credits you’d like to use for your database hosting? Do you want to deploy in an AWS VPC or Azure VNET?
SQL Server According to Bob
JANUARY 26, 2017
My goal is to resolve mysteries about SQL Server I encounter but do this without going straight the source code first. The first case that helped me start this journey was asked by a MVP within the SQL Server community (his first name starts with Joey<g>). The question went something like this….
This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.
SQL Server According to Bob
JUNE 27, 2016
To some of you SQL Server On Linux is old news from various announcements made a couple of months ago. Yes, SQL Server runs on Linux! It was Jan 2015, in my previous supportability role, that I started looking at SQL Server on Linux. I proceeded to install an Ubuntu VM and the internal build of SQL Server on Linux.
Particular Software
DECEMBER 9, 2019
I once had a client who started out with a very noncomplex server infrastructure. The hosting provider had given them ownership of an internal IP subnet, and so they started out with two load-balanced public web servers: X.X.X.100 It's easy enough to upgrade load-balanced web servers. It's not so easy with a junk drawer server.
Dynatrace
APRIL 21, 2022
As organizations adopt microservices architecture with cloud-native technologies such as Microsoft Azure , many quickly notice an increase in operational complexity. To guide organizations through their cloud migrations, Microsoft developed the Azure Well-Architected Framework. What is the Azure Well-Architected Framework?
SQL Performance
JANUARY 12, 2022
Despite the poor performance, working on the solution is an interesting exercise. You can enable its consideration without the requirements of batch mode on rowstore , e.g., using SQL Server 2019 Enterprise or later, by creating the following dummy columnstore index: CREATE NONCLUSTERED COLUMNSTORE INDEX idx_cs ON dbo.
SQL Performance
JUNE 10, 2020
In my coverage of the physical treatment of named table expressions in the series I focus on the treatment in Microsoft SQL Server and Azure SQL Database. Recall that what triggered this series is some confusion that exists in the SQL Server community around named table expressions.
Expert insights. Personalized for you.
242 
Let's personalize your content