(Kenneth Fisher) T-SQL TuesdayIt’s TSQL Tuesday again! This time our respected host is Bert Wagner (b/t). Quick aside, if you haven’t seen his vlogs before take some time and watch a few. They are entertaining, informative and best of all short!

(Greg Larsen) There may be a time when you want to turn off transparent data encryption on one of your TDE enabled databases. One of these times might be if you want to send a copy of your database to someone else without having it encrypted.

(Pinal Dave) There are so many wait types available in SQL Server and sometimes I feel that it’s an ocean of wait types. I have already written about most common wait types earlier.

(Siddharth Mehta) Location data can be found in almost every kind of data domain. The most generic form of location-based data are addresses of users, which contains geographic information like country, state, and city. In this time of visual analytics, users are used to analyzing any geographic dat

(Pinal Dave) Once in a while, I get questions where users have indeed explained the question well enough that I can easily understand their question. If I understand question quickly, I am always able to answer it efficiently as well. In this blog post, we will see one such question which I answered

(Chris Webb) The recent blog post on the Analysis Services team blog about new memory options contained information about some very interesting functionality that has just been added.

(Marcin Policht) Global distribution of updatable data stores is one of the more challenging goals that software designers and architects have been struggling with over the years.

(Kyle Weller) Did you know that you can execute R and Python code remotely in SQL Server from any IDE? This eliminates the need to move data around. Instead of transferring large and sensitive data over the network or losing accuracy with sample csv files, you can have your R/Python code execute wit

(lukaseder) Imagine you have a configuration table like the following:

(Simon Greener) Previously I wrote about a function that converted the segments of a (Multi)LineString into a COGO XML document that contains all the instructions (bearing, distances, move deltaZ etc) to create a (Multi)LineString.