Organize Your Tabs in SQL Server Management Studio
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
39 reads
Dallas DBAs
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: 2022-11-01)
235 reads
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: 2022-10-28)
361 reads
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
Restore Database or Restore Log?
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
26 reads
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
Purging a SQL Server Express Database
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)
244 reads
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: 2021-10-22)
479 reads
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: 2021-10-15)
298 reads
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: 2021-09-30)
283 reads
Blogs
Daily Coping 3 Feb 2023
By Steve Jones
Today’s coping tip is to ask other people about things they’ve enjoyed recently I...
Daily Coping 2 Feb 2023
By Steve Jones
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
Since changing to the new MVP renewal model, Microsoft MVPs have had until 31...
Forums
Permissions Changes Not Doing Anything
Hi friends, So I have a Login to a server that is a windows...
Re-creating AG after server loss
We recently had to rebuild servers that were configured with AG. I built everything...
Cannot run DynamicSQL Statement to merge table with JSON
Hi there I have a problem with a dynamicSQL Statement. In this code, I...
Ask SSC