Browsing around on Brent Ozar, RedGate, and SQLSentry, you'll find check lists for DBA monitoring and regular maintenance operations, but really the provider should already have a service level agreement...

null

null

Speaking of brute forcing SQL Server account logins, it can be easily done by querying the sys.sql_logins table and leveraging the pwdcompare function to join the pwtext hash column against...

We use Thycotic Secret Server as a repository for passwords, keys, etc. In addition to the web based management console, it has a domain authenticated webservice API for integration with...

I understand you want to run an identical quiery across multiple databases on the same instance. By leveraging sp_MSForEachDB you can execute a batch of t-sql across all databases. What...

djackson 22568 (3/25/2016)

---

Our SQL Server installs are all for software we have purchased from vendors. Where we can control the passwords we do. At one point some vendors...

At least from my experience, it's unusual for an ETL process, or even several concurrent ETL processes, to max out CPU. It's typically I/O, network, or memory that get's bottlenecked,...

Recently a network domain issue was preventing windows authentication for some SQL Server instances that I manage, but fortunately I had the option of falling back to using 'SA' account...

Dalkeith (3/24/2016)

---

I do wonder sometimes whether something like Watson could be developed to produce a truly objective job applicant decider. I'm conscious that everyone is slightly biased when it comes...

If what you're describing in a scenario where each SQL Server table is added to the MS Access project as a linked table, and then you're joining linked tables together...

The following will check for and extended property called 'MICROSOFT DATA QUALITY SERVICES - DQS' across all databases, returning one row for each match.

exec sp_MSForEachDB

'

USE ?;

if exists

(

...

Not only does a language like T-SQL abstract us from internals (although we can view at the sequences of high level operations performed by the execution plan), but the execution...

If you have power users or 3rd party applications that insist on connecting as 'SA', then you can fake them off by renaming original 'SA' account, and then recreating 'SA'...

This cartoon reminds me of that 1995 SciFi movie 'Johnny Mnemonic', which takes the concept of a 'sneakernet' to a whole new level.

http://www.wired.com/2013/03/technology-johnny-mnemonic/