(Jack Vamvas) The massive and exponential growth of database sizes requires new strategies for maintaining SQL Server performance. Therefore as data sets grow performance is maintained and also improved , but not to deteriorate.

(Fany Carolina Vargas) You have a SQL Server Agent job which needs to regularly access a remote file share in an untrusted domain. This requires you to provide the remote username and password while accessing the remote share. In addition, you do not wish to store the password of the remote share ac

(Denny Cherry) ColumnStore indexes are all the rage with data warehouses. They’re fast, they’re new(ish) and they solve all sorts of problems when dealing with massive amounts of data. However they can cause some issues as well if you aren’t very careful about how you setup your partitions on the C

(Kenneth Fisher) You know, sometimes you get a silly idea in your head and you just HAVE to try it out. The idea? Can I write a query without any white space? No spaces, no carriage returns etc. As it happens, yes. Yes I can.

(Pinal Dave) Recently I got a message on Skype about SSMS.

(Surekha K) Find how much disk space is used on a database in a week. (Between disk space usage differences)

(Vitor Montalvao) In the beginning of 2015 Microsoft purchased Revolution Analytics and with that they were able to incorporate R (the most popular open source programming language for advanced analytics) inside of SQL Server bringing R processing closer to the data and eliminating the need to expor

(Pinal Dave) One of my clients contacted me in assistance to install SQL Server. Generally, this is straightforward, but sometimes there are problems. This time we received an error message and it was very interesting. Let us learn about error related to the XML Document.

(Michael J. Swart) My friend Josh came up with the term “dark queries”. Just like “dark matter”, dark queries can’t be detected directly, but their effect can still be observed. He’s talking about queries that aren’t stored in cache. If your monitoring solution relies heavily on the statistics of ca

(KayUnkroth) The April 2017 Release of SSMS for Analysis Services is the first release with support for the modern Get Data experience. This release also features additional capabilities for the DAX parser, which come in handy when authoring or fine-tuning queries in the DAX Query Window.