(Chris Webb) Here’s something interesting that I just discovered about how Power Query deals with function parameters of type list…

(Pinal Dave) After my previous article on “Inside Temp table object creation”, I had a number of people ask me more about this topic. There seems to be a need for understanding these basic fundamentals that we have known for ages in a refreshingly new way.

(Chandrika Bandi) A computed column is computed from an expression that can use another column or columns in the same table. Functions, variables, constants, non-computed column names or any combination of all these may be used along with operators to create a computed column.

(Pinal Dave) Recently I was working with one of my friends who handles production server databases as a senior DBA. He told that recently one of the Jr. DBA was fired from his company because he has run a drop table command on a production server.

(James Serra) The traditional data warehouse has served us well for many years, but new trends are causing it to break in four different ways: data growth, fast query expectations from users, non-relational/unstructured data, and cloud-born data. How can you prevent this from happening?

(Michael J. Swart) What’s the difference between Oracle’s “materialized views” and SQL Server’s “indexed views”? They both persist the results of a query, but how are they different? Sometimes it’s difficult to tell.

(Chandrika Bandi) The ALTER COLUMN T-SQL portion of the ALTER TABLE command is used to change a named column. There is a list of scenarios where this is not possible, such as a column used in a PRIMARY KEY or FOREIGN KEY constraint.

(Feodor Georgiev) For data to be usefully analyzed, it must be consistent, accurate, and trustworthy. When incoming data is non-uniform, duplicated records are created and the data starts losing its value. In order counteract this issue, SQL Server’s Data Quality Services (DQS) helps monitor and mai

(Derik Hammer) I have a number of SQL Server Availability Groups in my organization. Of them, most are multi-site configurations for disaster recovery. Naturally, the latency that a separate data center implies is more than my application can handle for its writes.