(James Serra) I have heard some people say if you have a data warehouse, there is no need for cubes (when I say “cubes” I am referring to tabular and multidimensional OLAP models). And I have heard others say if you have OLAP cubes, you don’t need a data warehouse.

(Greg Larsen) When you are setting up a new SQL Server machine you need to determine how big you should make tempdb. Not an easy task to get it right out of the box.

(Shreyas R Gowda) Today, I was working with one of my clients with an issue where the application fails to connect to SQL server. The issue was encountered with the restart of the SQL services. The initial connections go through but within a very short duration the connections starts to fail.

(lukaseder) One of the things that confuse SQL users all the time is how DISTINCT and ORDER BY are related in a SQL query.

(Denny Cherry) A really great feature in Azure SQL DB went GA today. That feature gives you and SQL DB the ability to automatically fail databases over to a Secondary replia, without having to configure your application to handle that failover. You point your application at a VIP and that VIP will a

(Pinal Dave) Have you ever configured database mail using Gmail account? There are many articles on the internet describing the steps. In this blog, we would learn about fixing an error “The SMTP server requires a secure connection or the client was not authenticated” which you might see when databa

(Andy Mallon) I was recently doing a training session when a developer commented that it was OK to run an expensive query twice because on the second execution, SQL Server would use the “results cache” and be “practically free”.

(Joseph Sack) Last year SQL Server 2017 and Azure SQL Database introduced query processing improvements that adapt optimization strategies to your application workload’s runtime conditions.

(Nat Sundar) What is Data Science and what is the life cycle of a Data Science project?

(Simon Greener) I had need today to create a function that extracts all linestring elements from a GeometryCollection and returns a LineString or a MultiLineString.