---

Filter by type:

• All
• Articles
• Blog Posts

Code That Writes Code

• by Kevin3NF

• Dallas DBAs

“Work Smarter, not Harder” We’ve all heard it before, pretty much any job, anywhere. In our DBA slice of the IT world, this is very relevant to how we...

2023-04-28

Organize Your Tabs in SQL Server Management Studio

• by Kevin3NF

• Dallas DBAs

I blogged about this in August, but wanted to do this video as well: Thanks for reading and/or watching! Kevin3NF Follow @Dallas_DBAs
The post Organize Your Tabs in SQL Server...

2022-11-02

Where Is My SQL Server Errorlog?

• by Kevin3NF

• Dallas DBAs

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-01

1 reads

SQL Server Registered Servers

• by Kevin3NF

• Dallas DBAs

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-10-28

SQL Server Best Practices

• by Kevin3NF

• Dallas DBAs

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

Restore Database or Restore Log?

• by Kevin3NF

• Dallas DBAs

How long has this worked, and why didn’t anyone tell me? A typical restore statement from a FULL backup and a LOG backup: USE [master] RESTORE DATABASE [XE_demo] FROM...

2022-05-11

24 reads

SQL Server Migration and Upgrade

• by Kevin3NF

• Dallas DBAs

(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

Purging a SQL Server Express Database

• by Kevin3NF

• Dallas DBAs

This is not another IRL post, but rather is more of “Help, my SQL Express database is full!” post. I was contacted by a lawyer that was using a...

2022-01-12 (first published: 2021-12-30)

232 reads

Group By Starting Characters

• by Kevin3NF

• Dallas DBAs

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: 2021-10-22)

475 reads

Do Full Backups Break Log Shipping?

• by Kevin3NF

• Dallas DBAs

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: 2021-10-15)

291 reads

Filter by type:

• All
• Articles
• Blog Posts