SQL Tact

Scenario: We need to configure an existing legacy application from an external vendor to talk to our new SQL Server 2017 Availability Gr...

Got this email from a client in the southern US asking how to up their game in SQL Server, frustrated by a lack of hands-on opportunities ...

From a dev colleague: “Asking for a client... d o you know how to get a backup of an Azure SQL DB downloaded outside of Azure?” Short ...

What's a "soft delete", and why should DBAs be aware of such behavior in tables? So, a DELETE statement is a “hard” delete...

Much more on this topic at the Sparkhound blog . Wrote this email exchange with a colleague who wanted to confirm that the client-proposed...

Wrote this email exchange with some developer colleagues about to embark on performance tuning. Subject:  bag o' tricks from DMV talk ...

Wrote this email recently to a crew of developers who were shooting themselves in the foot with a database rich in varchar(max) data types. ...

Got this question in an email.  I'll paraphrase. William   Hoping you can advise me on best way to handle this.   My client...

Sent:  Friday, January 20, 2012 10:30 AM To:  William Assaf Subject:  dba has a question William, Can you send me references to support ...