Refreshing dependent views after a DDL change
When you are in charge of databases with tons of objects, making a small change over an object can be difficult to replicate if you have a lot of...
2019-08-02 (first published: 2019-07-15)
1,286 reads
Blog Posts
For those who want to be a Junior DBA
I’ve been fortunate to have spoken at a few SQL Saturday events this year, and one of the sessions I’ve had the pleasure of presenting has been about getting...
2019-08-01
7 reads
For those who want to be a Junior DBA
I’ve been fortunate to have spoken at a few SQL Saturday events this year, and one of the sessions I’ve had the pleasure of presenting has been about getting...
2019-08-01
12 reads
Interview with Aaron Bertrand
This is the fifth interview we have done. This time our guest is Aaron Bertrand! Aaron is one of the most community oriented person I know and he really...
2019-08-01
45 reads
Learning Powershell with Show-Command
Years ago I blogged about how I like to use the SSMS scripting feature to learn how to do things. ... Continue reading
2019-08-01 (first published: 2019-07-11)
867 reads
SQL Server Management Studio
Hopefully you know that SSMS is a separate install from the main SQL Server install. You can find the binaries from Microsoft (https://docs.microsoft.com/en-us/sql/ssms/download-sql-server-management-studio-ssms) Using SSMS version 18.2, whilst playing...
2019-08-01
92 reads
SQL Server Metadata using Powershell
If you are new at your job or a new client you would like to gather and review the sql server meta data to understand the environment and get...
2019-08-01 (first published: 2019-07-10)
645 reads
Teaching DevOps in Indianapolis
There is literally nothing I like better than working on automation. Before we had all the cool toys that we have now, I was working on automating database deployments....
2019-08-01
7 reads
Automating Replication On Your Server
If you use replication, you have had the situation occur where you had to restore a replicated database. You’ve have doubtless been paged to restore a replicated database. You...
2019-07-31
81 reads
Containers make easy upgrades
I’ve been working with containers and writing a bit about them for awhile. I find them to be fascinating and useful as a technology, and I’ve come to really...
2019-07-31 (first published: 2019-07-10)
420 reads
Blogs
KDA: Echoes of Deception - Case 6
By Zikato
A cryptic message, a book cipher hidden in art provenance records, and a trail...
Capturing My Own Metrics: #SQLNewBlogger
By Steve Jones
A customer was trying to compare two tables and capture a state as a...
Red Flags in Your Query (T-SQL Tuesday #200)
By Zikato
When I'm looking at a query, I bet it's bad if I see... a...
Forums
A Quick Second Opinion
Comments posted to this topic are about the item A Quick Second Opinion
Five Intelligent Query Processing Features in SQL Server 2022 That Quietly Tune Your Workload
Comments posted to this topic are about the item Five Intelligent Query Processing Features...
Checking the Error Log I
Comments posted to this topic are about the item Checking the Error Log I
Question of the Day
Checking the Error Log I
On my SQL Server 2025, I want to search the error log from my T-SQL code for potential issues and then inform an administrator. What is the current way to easily query the error log?
See possible answers