Proxy accounts for PowerShell, SSIS, and Operating System (CmdExec) job steps are instrumental when performing certain actions in SQL Server Agent. Once you’ve set up a proxy, and configured...
2019-05-08
Default backup schemes for databases would be a nice enhancement.
2019-05-08
251 reads
I consider myself fortunate that I get to work with so many different clients while engaged in Comprehensive Database Performance Health Check. Recently we found out that one of...
2019-05-06
(last updated: 2019-05-05 @ 11:55 EST / 2019-05-05 @ 15:55 UTC ) I had gone through the process of uninstalling the now obsolete SQL Server 2019 CTP, and then...
The...
2019-05-05
This question has come up many times how to capture the SQL Server Database Recovery Progress or Total time take to recover a database. It will help to plan...
The...
2019-05-04
On occasion you have to find means to get around an issue. John Morehouse shows why Robocopy can be a useful tool in testing circumstances.
2019-05-03
Once in a while you might need to make common changes to a lot of SQL Server Agent Jobs.
2019-05-03
You know what it’s like, you need to fail your AG over but is it safe to fail over? Even if your AG says it is, there are other thing to consider...
2019-05-03
491 reads
Achieving minimal logging with INSERT...SELECT can be a complicated business.
2019-05-02
Gail Shaw keeps seeing this in all sorts of places. People getting an unexpected result when working with a subquery, typically an IN subquery, and assuming that they’ve found...
2019-05-02
By James Serra
Announced at Microsoft Ignite last week were some new product features related to the...
This Black Week, don't just get a discount—get ahead! Whether you're a total newbie...
The post When is the perfect moment to build a data strategy in a...
EXEC sp_validatelogins <- Can we use this as a start to identify accounts in...
Hello Everyone! 👨💻👩💻 Are you preparing to study abroad and considering a career in...
(Alone) #call #girl In 0562088713 Downtown Dubai (Alone) #call #girl In 0562088713 Downtown Dubai
Which of these inputs is the smaller input to a hash join?
See possible answers