When creating a non-clustered index, each covered column is sorted in ascending order by default, but you can specify optional DESC (decending) or ASC (ascending) keyword following a column's name.

It's important for a software tool, especially a database management tool like SSMS or VS, to provide a visual queue that environmental context has changed. I believe we've all experienced...

Clean SQL runs better for the same reason that a clean car runs better. It's simply that those same developers who take time to format their code in a meaningful...

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

(

...