LinkedIn
YouTube
GitHub

SQL Server

Home Category: SQL Server

So You Wanna Debug SQL Server Part 2

Erik Darling
SQL Server
2 Comments
Birth Control Debugging, and, heck, even learning about debugging, is a time-consuming and often unhelpful process when it comes to tracking down issues in SQL Server. It is arduous and tedious, and yields little chance of making you any friends. So why write about it? Mostly because no one else is willing to — at…
Read More

How to Restore a SQL Server Database into Azure SQL DB Managed Instances Redux

Erik Darling
Managed Instances, Microsoft Azure, SQL Server
No Comments
Anything Brent Can Do There’s some things you can do with Managed Instances, and some ways you can look at data that you can’t do elsewhere. For instance, you have the ability to start an restore ASYNC — that means if your session drops, the restore will continue headlessly in the background. There’s nothing about…
Read More

Azure SQL DB Managed Instances: We’re All GUIDs

Erik Darling
Managed Instances, SQL Server
1 Comment
Six is having problems adjusting to his clone status Some funny things happen when you create databases up in a Managed Instance. For Instance (HEH!), you may expect this to yield some fruitful results, but it Manages (HAH!) to defy logic. Transact-SQL CREATE DATABASE YourMom; SELECT * FROM sys.master_files WHERE name = 'YourMom'; 12345 CREATE DATABASE YourMom; SELECT…
Read More

Let’s Give The Optimizer A Name

Erik Darling
Humor, SQL Server
66 Comments
Clunky As my favorite monkey likes to say, the hardest things do with computers are: 1. Naming things 4. Asynchronous processing 2. Cache invalidation 5. Off by one errors Things are tough for Microsoft, too. Take “the optimizer” for instance. It’s based on something called the Cascades Framework. No one wants to say “Cascades Framework”,…
Read More

[Video] Office Hours 2018/1/17 (With Transcriptions)

Brent Ozar Unlimited Team
SQL Server, Videos
1 Comment
This week, Tara, Erik, and Richie discuss 3rd-party tools for object-level restore, patching, stringing multiple CTEs, Meltdown and Spectre, instance stacking, organizing DBA teams, DBCC checks, moving local databases to Amazon RDS, CTEs vs temp tables, and backups and restores. Here’s the video on YouTube: You can register to attend next week’s Office Hours, or subscribe to…
Read More

[Video] Office Hours 2018/1/31 (With Transcriptions)

Brent Ozar Unlimited Team
SQL Server, Videos
2 Comments
This week, Brent, Tara, and Richie discuss a simple way to fill tempdb, tools for retrieving data from transaction logs, tools for diagraming server architecture, their favorite counters for checking if SQL server on VMWare has sufficient memory, SSRS subscription issues, change requests, thread pool issues, best practices for SELECT * into, failover SQL Server…
Read More
Menu