teacher at whiteboard

Don’t do these things in SQL Server

Recently Brent Ozar posted a link to the PostgreSQL “Don’t do this” page, which I am shamelessly reproducing below, re-tailored for a SQL Server audience. Don’t use -P with sqlcmd sqlcmd is a cross-platform interactive command-line utility that allows you to connect to a SQL Server (or Azure SQL Database) instance and perform database operations.
-> Continue reading Don’t do these things in SQL Server

Post image

Max Server Memory Revisited

Some time ago, I added a free resource to this site to help DBAs know how much max server memory should be assigned to SQL Server, based on an algorithm by Jonathan Kehayias. On 19 August 2016, I went one step further and wrote a free script to perform the calculation for your own instance,
-> Continue reading Max Server Memory Revisited

Post image

On Best Practices

We hear a lot about “best practice”, but what does it mean in the context of SQL Server? Wikipedia describes best practice as follows: A best practice is a method or technique that has been generally accepted as superior to any alternatives because it produces results that are superior to those achieved by other means
-> Continue reading On Best Practices