Tag: TempDB

Check your SQL Server's code compatibility with Azure so you don't step in it.

Is your SQL Server Code Ready for Azure?

I recently had a discussion with a client that turned to the question of SQL Server code compatibility with Azure SQL Database. We were designing a new pipeline for their on-premises SQL environment, and they mentioned their abandoned cloud migration effort from a few years earlier. The business ended up pausing this effort because of…
Read more

sql server slow disks in Azure

Analyzing Disk Latency in Azure Virtual Machines – Part 2

“I thought the cloud was supposed to be fast. Why are things moving like a sloth?” Have you heard someone complain about the speed of an application after moving it to the Microsoft Azure? Azure is a good environment, but things are not always fast in the cloud. To illustrate, in this post, we’ll review…
Read more

disk latency in azure

Analyzing Disk Latency in Azure Virtual Machines – Part 1

If you’ve moved your SQL Server workload to Azure Virtual Machines, you’ve noticed there’s no shortage in the number of options available. Virtual machine sizes, disk types, caching vs no caching, support for bursting, etc. When hosting SQL Server on Azure Virtual Machines, choosing the right combination of VM size and disk types is essential…
Read more

try sql server 2022 new features

Use a Docker Container to Explore SQL Server 2022’s New Features

There’s a lot of hype surrounding the next version of SQL Server. And for good reason. SQL Server 2022 is packed with some long awaited niceties, improvements, and enhancements. Here are a few of the SQL Server 2022’s new features we are excited about. Contained Availability Groups Enhancements to Availability Groups and Distributed Availability Groups…
Read more

tuning sql server

Infographic: 5 Commonly Overlooked SQL Server Settings

When we examine SQL Servers as part of our SEROShield SQL Server Health Check, we find five commonly overlooked SQL Server settings that can put performance, reliability, and even data at risk. Why are SQL Servers often misconfigured? SQL Server is robust. Microsoft has put a lot of effort into creating a database platform that…
Read more

balancing sql server tempdb

How to Configure SQL Server tempdb?

How many tempdb data files should a SQL Server have? And where should they live? What about their growth settings? Should it be by percent? Or, should they grow by a certain size each time? Are there other tempdb configuration settings I should be concerned with? In short: how should I configure my SQL Server…
Read more

SQL Server Configuration settings

Webinar: Is Your SQL Server Healthy?

SQL Server. Many business depend on it. But how can you tell if your SQL Server is healthy? It’s not always obvious. SQL Server can be pretty forgiving in many ways, until it’s not. And that can put your performance and even your data at risk. The right configuration settings are critical. Unfortunately, it’s easy…
Read more

SQL Server disk IO traffic jam

Identifying SQL Server Disk Latency

When SQL Server is not as fast as users think it ought to be, how can you tell where the slowdown is? Where’s the performance bottleneck? Where’s the traffic jam? Is it waiting on CPU? Does it needs memory? What about the disks? Could SQL Server be slow because of disk latency? Could be. But…
Read more

SQL Server Security

What Takes Precedent db_datareader (GRANT) or db_denydatareader (DENY)?

If a user is a member of db_datareader, which grants access to a table, and db_denydatareader, which denies access to a table, which role will take precedent? That’s the question someone on LinkedIn recently posted in the SQL Server Administrators group recently. Here’s a link to the question. The LinkedIn poster essentially wanted to know…
Read more

Learning SQL Server

Learn SQL Server with PluralSight’s FreeApril

“I want to learn [a technology]. Where should I start?” Since I’ve spent the last 25 year working with SQL Server (no exaggeration, see footnote), the question is usually about learning SQL Server. Sometimes it’s about learning related technologies such as data analytics and visualization, scripting languages such as Python or PowerShell, or the burgeoning…
Read more