Dallas DBAs

Blog Post

Degrees and Trade Schools

Can we normalize a couple of things? 1 – Trade Schools. Back in the 80’s trade classes in high school and post high school were frowned upon, or looked...

2024-05-08

15 reads

Blog Post

3rd Party Applications Have Issues

As a SQL DBA, what do you do when a vendor application has performance problems that are code related? Server settings don’t generally seem to be an issue. Queries...

2024-05-20 (first published: )

179 reads

Blog Post

Set-Based vs Row-Based Database Code

In SQL Server, the terms “set-based” and “row-based” refer to different approaches or styles of writing SQL code to manipulate data. These styles have implications for performance, readability, and...

2023-12-18 (first published: )

509 reads

Blog Post

Database Concerns – A Poll!

What are you most concerned about in your database platforms? Please pick from the list below, and expand on your choice in the comments if you like:   Thanks...

2023-11-08 (first published: )

198 reads

Blog Post

IRL #8: SQL Server Down

Problem: My PocketDBA® client called in with a non-responsive SQL Server. Application errors, timeout, alerts firing. SQL Server box is up, and the services are running. Background: This is...

2023-09-06

25 reads

Blog Post

SQL Server is not a Car

Lets compare them anyway, just for fun. Both have an engine Both have a monitoring device (Dashboard/Activity Monitor) Both need power (Gas/Electricity) Both need to be told what do...

2023-09-05

24 reads

Blogs

Create a copy of an Azure SQL DB

By

Where I work, we will be migrating data from one set of databases into...

Take the SQL Saturday Topic Survey

By

What topics do you want to see presented at a future SQL Saturday (or...

Resetting Git and Abandoning Changes–#SQLNewBlogger

By

I recently had an issue in one of my Git repos, and decided to...

Read the latest Blogs

Forums

Looking for recommendations for reporting technologies replacements

By Rod at work

Here at work I've been maintaining an old ASP.NET WebForms app. I was assigned...

Using TDE Best Practice

By Harold Buckner

I am trying to understand when best to enable TDE. Our Asst. Director has...

Program Code giving duplicate errors where no duplicates exist

By Andre 425568

On our Java Hibernate program it is giving a duplicate value on an insert...

Visit the forum

Question of the Day

Disable Memory Grant Feedback Persistence

In SQL Server 2022, how can I disable memory grant feedback persistence?

See possible answers