QUOTED IDENTIFIER Set Incorrectly?!

So What Is Going On? I recently ran into an issue when I set up a job to collect information from an extended event. I wanted to write that to a table in my scratch DBA database. This allowed the customer and I to slice and dice data with ease. This seemed easy enough. I […]

The post QUOTED_IDENTIFIER Set Incorrectly?! appeared first on dbWonderKid.

Make Your Queries Go Faster

Getting Started with SQL Server Performance Tuning

Watch! Getting Started with Performance Tuning Have slow queries and want to get down to the basics of learning some fundamentals for performance tuning? If so, John Sterrett is giving an talk at the Nashville User Group (Online) tomorrow.…

Tuning Update Statement with SQL Server

,

You are out doing your scheduled sweeps of the environment and you notice a huge I/O consumer is one of your update procedures. Your initial thought may be to panic because how can you test data that is changing? You have several methods to tuning queries that adjust data that allow data to revert between […]

The post Tuning Basics – Updating an Update appeared first on dbWonderKid.

Tips for working remotely

Accelerated Database Recovery

,

How did we get here? There are many ways that a database can crash and need to recover. Maybe you find yourself here from something more severe like hardware failure, perhaps it was only a reboot and when things started to come back you see databases stuck in an “In Recovery” state. I personally have […]

The post Advanced Database Recovery appeared first on dbWonderKid.

SQL Server 2022

SQL Server 2022 What is New?

,
SQL Server 2022 was announced yesterday at Microsoft's Ignite Conference. Here are some of the items that caught our attention. This includes SQL Server 2022 Announcements and other announcements around the Microsoft Data Platform. https://www.youtube.com/watch?v=ncF-zFzBDAY Bob…
Heap not sorted like clustered Index

Clustered Index vs Heap

, ,
What is a heap? Heap was actually named pretty accurately. It is a “pile” of unsorted/unorganized data. A heap will exist on any table that lacks a clustered index. Heaps can exist even if you have a non clustered indexes. The main advantage to a heap is the speed at which you can insert data […]
SQL Server 2022

Replay in the Cloud

, ,
Replay like a Rockstar! Want to save money, validate performance, and make sure you don't have errors while migrating to Azure SQL Database, Azure SQL Managed Instance, SQL Server RDS in Amazon AWS? In this video, you will learn how…
Tips for working remotely

Benchmarking Queries with SentryOne Plan Explorer

,
Today, I want to focus on a free tool that everyone can use when benchmarking queries or performance tuning their queries. This tool is Plan Explorer by SentryOne (I think I will still always know them as SQLSentry). Plan Explorer is another…
Tips for working remotely

Free SQL Data Compare

I am a consultant in Austin who can help make your data go fast, be secure and highly available. When I am engaged in a performance tuning project priority #1 isn’t to make sure your data go faster. Priority #1 is to make sure we get…
Tips for working remotely

Five Tips for Working Remotely

,
The following are five tips for working remotely that I learned over the years from working remotely with large companies like DELL, RDX and now even as a leader of a consulting company that focuses on making our customer's data fast, secure…