(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

(Joe Celko) When we have to deal with and store a lot of data, it makes sense to aggregate it so that we store only the information we actually need. If we get this right, this works well, but the design of the system takes care and thought because the problems can be subtle and various.

(Parikshit Savjani) One of the design goals of SQL Server 2016 was to improve performance and scalability of the engine out of the box to make it run faster without the need of any knobs or trace flags for customers.

(Manvendra Singh) If you have to remove an AlwaysOn Availability Group from your SQL Server instance then follow this tip. I’ll explain step by step how to remove an AlwaysOn Availability Group using both SQL Server Management Studio and T-SQL commands.

(Jack Vamvas) This is not a trick question, but what is the Windows Exit Code 1077?