(Tim Smith) File encoding can cause problems if applications expect or read files encoded in one format and receive a different format and break on an unrecognized character.

(Chris Webb) A quick Q&A-related tip. If you create a report in Power BI Desktop and use a Power BI service live connection:

(Pinal Dave) Today, I have interesting experience while working with a client on Comprehensive Database Performance Health Check. I was working with Sr. DBA on optimizing their SQL Server.

(blobeater) The purpose of an Elastic Job is to execute a T-SQL script that is scheduled or executed ad-hoc against a group of Azure SQL databases.

(Jack Vamvas) Often organisations have a SQL server security policy dictating the ‘sa’ login is disabled.

(Grant Fritchey) I’ve been working in and around data for over 30 years now. My title has changed a number of times and is poised to change again.

(Kenneth Fisher) In case it’s not clear, we are talking about the Login Properties GUI in SQL Server Management Studio (SSMS).

(Rick Dobson) A table variable is a local variable that has some similarities to temp tables. Table variables are created via a declaration statement like other local variables. Like other local variables, a table variable name begins with an @ sign. However, its declaration statement has a type

(Haroon Ashraf) This article talks about the three standard SQL unit tests which can be written against any stored procedure ultimately becoming SQL unit testing object to meet internal or external business specification.

(Jason Brimhall) How necessary is that SQL Server Agent job that you have running on the server? I ask that question of my clients on a routine basis.