Dallas DBAs

Blog Post

Where Is My SQL Server Errorlog?

If you need to find the SQL Server ErrorLog in a hurry and don’t want to spend 30 minutes drilling into every drive on the server: “I don’t watch...

2022-11-21 (first published: )

235 reads

Blog Post

SQL Server Registered Servers

Query multiple SQL Server instances at one time! Thanks for watching! Kevin3NF Follow @Dallas_DBAs
The post SQL Server Registered Servers appeared first on DallasDBAs.com.

2022-11-09 (first published: )

361 reads

Blog Post

SQL Server Best Practices

As a CIO or CTO, one of your primary responsibilities is to ensure that your organization’s data is managed effectively and efficiently. To do this, you need to have...

2022-09-14

11 reads

Blog Post

SQL Server Migration and Upgrade

(This post written by Jon Biggs (t), one of our Senior DBAs) We are currently performing migrations with upgrade of multiple-instance SQL Servers to new servers. The migrations are...

2022-03-22

27 reads

Blog Post

Group By Starting Characters

I was chatting with Jeff (b|t) on my team yesterday and the context escapes me but I had this thought: “Can you Group By the beginning characters, or a...

2021-10-29 (first published: )

479 reads

Blog Post

Do Full Backups Break Log Shipping?

TLDR: Nope. Keep on doing your full backups. Make sure that any databases you Log Ship are NOT also doing log backups in your SQL Maintenance Plans, Ola Jobs,...

2021-10-22 (first published: )

298 reads

Blog Post

How old are those stats?

SQL Server maintains a variety of stats about all sort of performance items. Index usage (or missing indexes) Query performance Corrupt pages Disk IO performance Way more than I...

2021-10-11 (first published: )

283 reads

Blogs

Daily Coping 3 Feb 2023

By

Today’s coping tip is to ask other people about things they’ve enjoyed recently I...

Daily Coping 2 Feb 2023

By

Today’s coping tip is to challenge negative thoughts and look for the upside. I’m...

Deadline for Microsoft MVP contributions is 20 March 2023

By

Since changing to the new MVP renewal model, Microsoft MVPs have had until 31...

Read the latest Blogs

Forums

Permissions Changes Not Doing Anything

By EsquireDeveloper

Hi friends, So I have a Login to a server that is a windows...

Re-creating AG after server loss

By izinger

We recently had to rebuild servers that were configured with AG. I built everything...

Cannot run DynamicSQL Statement to merge table with JSON

By Weegee71

Hi there I have a problem with a dynamicSQL Statement. In this code, I...

Visit the forum

Ask SSC Logo Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers