Glenn Berry goes over three different tactics you can use to squeeze some extra performance out of SQL Server without a lot of heavy lifting.
Tim Radney of SQLskills talks about the various Standard tiers available in Azure SQL Database – what they get you, and how much they cost.
Glenn Berry talks about some upcoming AMD processors, which he says may change the server processor landscape.
Glenn Berry of SQLskills walks through the next iteration of Intel Xeon processors, and how they suit SQL Server 2017.
Glenn Berry (@GlennAlanBerry) explains why you need to be very careful about your physical processor choice when configuring servers to run SQL Server 2016 Standard Edition.
There's a very handy new tool from Microsoft called the Database Experimentation Assistant (DEA). The DEA makes it very easy to conduct A/B testing for SQL Server upgrades, providing quantitative insight into the performance differences across two versions of a database workload on SQL Server. READ MORE… Originally Posted February 08, 2017
The Environment Health Overview health score indicates the overall health of your entire environment; Jason Hall (@SQLSaurus) explains how to use it to make work easier.
Glenn Berry discusses the ever-changing landscape of memory/storage technology, and how it relates to SQL Server workloads on Windows servers.
Glenn Berry (@GlennAlanBerry) discusses a new feature in Windows Server 2016, Storage Spaces Direct, and how SQL Server will benefit.
Glenn Berry (@GlennAlanBerry) provides some blueprints for how to decide whether newer processors are worth the investment to improve your OLTP workloads.
Tim Radney (@tradney) walks through the configuration of a new SQL Server 2016 feature, Stretch Database, and discusses some of its limitations.
Originally appearing in my monthly column at Database Trends & Applications magazine. When it comes to cloud-based database management, there are really only two players: Amazon, the value leader, and Microsoft, the innovation leader. Amazon has carved out a niche as the value leader in cloud-based database management, supporting not only its own implementations of […]