(Thomas LaRock) I wrote a post recently about troubleshooting connectivity for endpoints on Microsoft Azure VMs. The day the post went out I was greeted with this tweet:

(Cate Murray) As the competitive landscape internally and externally continues to get tougher, it’s becoming more and more important to focus on differentiating yourself. This is especially important if you’re applying for an internal promotion, or starting to look externally to the organization for

(Marcin Policht) In the recent articles published on this forum, we have been describing the process of preparing a Windows Server 2012 R2-based image containing a pre-staged installation of SQL Server 2014.

(Kenneth Fisher) If a user is going to call me about problem, I’d much rather know about it ahead of time. In fact my favorite problems are the ones I’ve already fixed before the users ever notice it.

(Jason Brimhall) Welcome to the fabulous world of blog parties, SQL Server and what has been the longest running SQL Server related meme in the blogosphere – TSQLTuesday.

(Pinal Dave) In the recent past, I have been writing about different error messages on SQL Server that one encounters. Thanks to my blog readers who have been sharing a lot of errors with me either by email or by blog comments and asking for solution.

(Tim Hidalgo) Once you’re clear about what data the developers and testers need to be able to be effective, you have several alternatives approaches to providing them exactly the data that will give you rock solid database tests that will allow deployments with far less risk.

(Chris Webb) Quite often, in Power Query, you want to ‘nest’ calculations and transformations – apply them not across the whole table, but repeat the same calculation or transformation across multiple groups of rows within that table.

(Jeremy Kadlec) We need to recover a SQL Server table immediately. Someone has dropped one of the main tables from one of our core databases. This means our production system is down, users are telling all of our customers that our systems are down, our web site is in maintenance mode and every me

(Arshad Ali) In my last article “Converting Comma Separated Value to Rows and Vice Versa in SQL Server”, I talked about how you can convert comma separated (or separated with some other character) values in a single column into rows and vice versa.