(Jason Brimhall) Every now and again, you may run into an error about implicit conversions in your queries. Implicit conversions are not uncommon in the computing world and can be viewed as kind of a fail-safe for when we don’t quite follow decent practices when designing the database or when writin

(Paul White) This post provides new information about the preconditions for minimally logged bulk load when using INSERT…SELECT into indexed tables.

(Pinal Dave) I get to work with various different versions and environment when I am busy with my clients with Comprehensive Database Performance Health Check. While I work with different customers often I forget what data type is supported by which version of SQL Server.

(Ashish Kumar Mehta) A developer approached me with an MDF file of a SQL Server database which they wanted to restore. This person only had the MDF file for the database and no transaction log file, also they didn’t have a backup of the database.

(Pinal Dave) While deploying Always On Availability Group with a client, they found that when they use automatic seeding, the database was not shown on secondary.

(Hannes DuPreez) A programming language is only as clever as the person using it

(Kenneth Igiri) Database Mail is a feature in SQL Server that allows database applications to send email via SMTP. The database engine actually queues messages to be sent and these messages are passed to an external process to handle the email sending.

(Erin Stellato) I have had a lot of conversations recently about types of workloads – specifically understanding whether a workload is parameterized, adhoc, or a mixture.

(Lindsay Moore) Regardless of the size of your organization, there’s always a wide variety of items to keep track of in database systems like SQL Server — user logins, data access, security protections and more.

(Paul White) SQL is a declarative language. We use SQL to write a logical query specification that defines the results we want.