It should be considered best practice to drop the 'SA' account. However, I still create a MSSQL authenticated account with SYSADMIN membership, because there are a handful of occasions where...

TomThomson (3/28/2016)

---

...

Most stored procedures should fit onto a page (A4 or American letter) - say 60 lines of tex using sensible font. A page and a half or...

You can add db_name() function to the resultset.

exec sp_MSForEachDB

'

USE ?;

if exists

(select table_name...

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...