(Andreas Wolter) In this article I will bring together several techniques for troubleshooting a performance as well as a security related “phenomenon” I recently noticed when doing some tests with Natively Compiled Stored Procedures.

(Pinal Dave) It’s always a good experience to visit customer sites and talk to people. Sometimes I get to see things outside SQL world as well. There is a lot to learn and I believe that I can do that by sharing what I learned. In this blog post we will discuss Why Cluster Network is Unavailable in

(Robert Sheldon) Transparent Data Encryption (TDE) encrypts the data within the physical files of the database, the ‘data at rest’. Without the original encryption certificate and master key, the data cannot be read when the drive is accessed or the physical media is stolen. The data in unencrypted

(John L. Viescas, Ben G. Clothier and Douglas J. Steele) Sometimes, despite their best efforts, SQL database developers are forced to deal with external data outside of their control. World-class database consultants and instructors present effective ways to help you deal with such situations.

(Yochanan Rachamim) Explain how to easily and quickly use SQLPackage to import or export your Azure SQL Database.

(Chris Webb) Last week a reader left a comment on my blog asking what the third argument of the List.Contains() M function (somewhat cryptically called equationCriteria) does. I didn’t know, so I did some research and found out that lots of the List.* functions have the same argument.

(Denny Cherry) Well that really depends. When your database VM fails for some reason (either someone does something bad like delete the VM by accident, or a Windows patch doesn’t install correctly and the VM won’t start correctly, etc.) do you care about having your logins on the server, your jobs,

(James Serra) Microsoft’s end goal is for Azure to become the best cloud platform for customers to run their data workloads. This means Microsoft will provide customers the best environment to run their big data/Hadoop as well as a place where Microsoft can offer services with our unique point-of-v

(Thomas LaRock) Data is the most critical asset that you, or any company, owns. Without data, your company would cease to exist. All that hardware you bought? Yeah, that’s just there to help data get from one place to another faster. It’s all about the data, so you’d better treat it right.

(RDORR) You are aware of our statements indicating “Microsoft Loves Linux.” Over the last couple of years the open source activities at Microsoft have accelerated all around me. Recently I blogged about the design of of the debugger bridge and the use of LLDB.