DBA Mastery

Blog Post

Availability group error message 19405

Availability groups (AG’s) is one of my favorite features of SQL Server, despite some DBA’s catalogue them as “too complex” to implement, configure, manage  and maintain … I just...

2019-05-13 (first published: )

750 reads

Blogs

SQL Blunders: Stop Writing These Pointless Queries & Write Smarter!

By

They run, they return data. So what? Some SQL queries just waste your time...

Copilot Outside of SSMS Seems to Work

By

I read Brent’s first look at SSMS and Copilot in there. He didn’t have...

A New Word: Falesia

By

falesia– n.  the disquieting awareness that someone’s importance to you and your importance to...

Read the latest Blogs

Forums

T-SQL - except - add date column

By mtz676

SELECT         [A]       --,[Date]       ,  ...

Problem with CASE statement

By water490

Hi Everyone I have used CASE many times but not sure what I am...

Visit the forum

Question of the Day

Calculating Month End

I want to calculate the end of the previous month as a date that I can use in running a report. What is the best way to do this in SQL Server 2022, assuming I have a date stored in @d?

See possible answers