(Pinal Dave) After so many years of existence of the stored procedures, I still see developers struggling to execute the stored procedure. Every other day I receive a question in an email asking how to pass parameters to the stored procedure.

(Jack Vaughan) SQL Server for Linux has gained added features on its way to general availability as part of the almost-ready SQL Server 2017. Meanwhile, its Windows-based brother is upping its high availability quotient.

(Paul White) This article shows how SQL Server combines density information from multiple single-column statistics, to produce a cardinality estimate for an aggregation over multiple columns. The details are hopefully interesting in themselves. They also provide an insight into some of the general a

(Robin Lester) In this post we will look at the problem where we need to move the data at irregular intervals from an on-premise SQL instance with a constantly changing schema to an Azure SQL database.

(Kenneth Fisher) Every now and again you need to know how big a table is. Or several tables. Or all of the tables. Number of rows is frequently handy when you’re going to create a new index or otherwise modify the table.

(Greg Larsen) Are you using database mail to send SQL Agent job completion messages, and alerts? If so, are you also purging the old mail items stored in msdb? In this tip, I will show you how to purge database mail.

(Pinal Dave) When you run a blog with a million views a month, one must expect every kind of audience on the blog and author should be not judge every single email.

(Jeffrey Yao) It is well-known that T-SQL does not have native Regular Expression (RegEx) support for string related queries. For example, you cannot search records with a regular expression in WHERE clause.

(Pinal Dave) Microsoft SQL Server has given an option to connect to SQL Server when normal connections can’t be made because of any reasons.

(Chris Webb) Something I didn’t understand at all when I started writing this series was how the “None” data privacy level worked. Now, however, the ever- helpful Curt Hagenlocher of the Power Query dev team has explained it to me and in this post I’ll demonstrate how it behaves and show how data pr