(Chris Webb) If there’s one feature of Power Query that’s guaranteed to get Excel users very, very excited indeed it’s the ability to combine data from multiple workbooks into a single table.

(Robert Sheldon) Every time you access a relational database to make a query, you have an important decision to make: What is the appropriate isolation level for your query? If you get this wrong, the consequences can be serious. Deadlocks, Dirty reads, Non-repeatable reads, or poor performance.

(K. Brian Kelley) I’m responsible for the security of my organization’s SQL Servers. Lately I’ve been looking outside of SQL Server and wondering what I should be checking. Someone mentioned the Administrators group and that made me think about other groups on the server.

(Pinal Dave) We have an active usergroup in Bangalore called SQLBangalore. Whenever I get a chance to attend the local usergroup sessions (which happens often – trust me), I get to learn something every single time.

(Dallas Snider) The numeric data inserted in my database table after my SQL Server Integration Services (SSIS) package executes does not look like the data from its comma-separated source file. What can I do to fix the problem?

(Chris Bell) SQL Server has an amazing community. It freely provides information and training of SQL Server technologies via the internet and even in person events like SQL Saturday’s.

(James Serra) I have previously blogged about the Fast Track Data Warehouse, a reference configuration optimized for data warehousing (see Microsoft SQL Server Reference Architecture and Appliances). That was version 3.0 of the reference configuration that was for SQL Server 2008 R2.

(Derik Hammer) The other day I set out to performance tune a database deployment. The company was getting ready to implement almost a year’s worth of database schema drift where major restructuring had occurred. One of the first things that I noticed was that they were moving a number of tables into

(Steve Endow) I’ve developed many Dynamics GP Visual Studio Tools AddIns that depended on one or more SQL scripts.

(Kenneth Fisher) You see dozens of blog posts and articles about how the order of a result set is not guaranteed without an ORDER BY clause and here is my contribution to the subject.