This paper describes best practices for security, networking, and component architecture for building a hybrid business intelligence (BI) environment by using a combination of Microsoft Office 365, Microsoft Azure, and on-premises data sources. Many organizations are taking advantage of the benefits of cloud computing such as lower capital expenditures and increased agility, while still maintaining data in on-premises data stores.
Analyzing performance often requires you to understand what is normal and what is not. Steve talks about the importance of baselines.
This article aims to save you days or weeks of troubleshooting when using SQL Server 2016 for large databases
In-Memory OLTP was introduced with SQL Server 2014 as a way to improve transaction performance. There are several scenarios that are not supported, such as some data types, and Darko Martinovic describes the issues and provides workarounds. He also has provided a tool to assist in migrating disk-based tables to In-Memory optimized tables.
Is there a best way to comment code? Or maybe just different styles. Steve Jones asks what you think today.
My struggles with a customer's database that used a different collation sequence. The easy way is never the right way, or is it?
Watch in awe and wonder as Brent Ozar creates a deadlock, then uses sp_BlitzLock after the fact to show you which queries and tables were involved.
Learn how containers can help with database development.
PlanTrace Now Supports PostgreSQL The same plan analysis you know from...
By Steve Jones
the kinder surprise – . the point in your early adolescence when you realize...
If you’ve been following my T-SQL Snapshot Backup series, most of what I’ve covered...
Comments posted to this topic are about the item The New Wave of Security...
Comments posted to this topic are about the item There's Too Much to Learn
Comments posted to this topic are about the item How to Calculate Distance Between...
On which Linux versions is SQL Server 2025 on Linux supported?
See possible answers