Mission: SQL Homeostasis

When you restore a database, it will also restore all permissions along with it. But what if you are restoring...

2018-04-19

11,181 reads

How to check whether and when sql index statistics were updated last time?

I was working for a client on their very critical and heavily used database. The application was an E-commerce website...

2018-04-19

5,090 reads

If you ever had a need to start a SQL job using sp_start_job stored procedure in msdb then you know...

2018-04-19

14,760 reads

My first time at SQL Saturday New York City was an absolute blast! Thank...

Just a quick one this morning. I’m on the road and haven’t worked up...

Businesses rely on data for decision-making and strategy, but data silos hinder productivity. These...

Hi, I have a workstation with SQL Express 2019 installed and I have a...

Hello - I have attached a Word document here with details about my issue....

I am having trouble writing linking the MAX query that I created back to...

If I want to delete a log shipping secondary server where only one database is used to restore the logs, what should I do?