(Thomas LaRock) Last week while at SQLBits I attended a session titled SQL Server/Azure Engineering Model given by Conor Cunningham from Microsoft. During the talk, Conor announced that there was an update to the SQL Server 2016 privacy statement. Conor is hoping that this update will help clear up

(Nat Sundar) When you are doing the rapid deployment of an updated SSIS project, there are a number of things you have to check to make sure that the deployment will be successful. These will include such settings as the values in environment variables, Package parameters and project parameters.

(Christina Phillips) The best laid plans… Word templates are not my favorite thing. There I said it. It is not because I don’t think are pretty and functional and allow for more flexibility than report writer reports. It’s just that they can be time consuming in a way that clients don’t expect

(Pinal Dave) Just another day while doing performance tuning engagement, Senior DBA of the organization and I both noticed that one of the SP sp_readrequest is continuously listed as long running SP. Well, the good part was that it was not taking too much of the resources.

(Eli Leiba) You want need to create a copy (clone) of a database on the same SQL Server instance. This can be done in several steps, but is there a simpler way of doing this with T-SQL so it can be done in one step?

(Pinal Dave) If you work with a product for a long time, you would start loving it. I have worked with many other RDBMS, but my love to SQL Server will never die. The amount of information available in logs is very helpful and can help in pointing the exact issue related to retrieve data.

(Arun Sirpal) TDE (Transparent Data Encryption) encrypts the data files at rest but don’t forget that it also encrypts your backup file too.

(Robert Sheldon) Analytics helps improve business operations, and SQL Server 2016 users can master it — in real time, using operational data in a transactional database.

(Chris Webb) As a consultant I frequently work with customers who want to add me to their Power BI tenant so I can publish reports, monitor data refresh and so on.

(Tim Wiseman) How can I incorporate logic similar to an If/Else construct into a T-SQL Query?