(Sergey Gigoyan) In some cases, a SQL Server database occupies much more space than actually is used by the data or would ever be used. In such situations, it would be optimal to reduce the size of the database and return the storage space to the operating system.

(Esat Erkec) SQL AS keyword is used to give an alias to table or column names in the queries. In this way, we can increase the readability and understandability of the query and column headings in the result set.

(Kenneth Fisher) I realized in my last #PowershellBasics post that I was talking about running a file and passing in an optional parameter but I didn’t describe how to do it. I decided that it was a distinct enough task that I’d make it it’s own post, so here we go.

(Pinal Dave) Yesterday, I had asked a very simple question on twitter about the top reasons for the slow performance. I had received a lot of interesting answers and perspectives on that topic. Lots of people also sent me a detailed email as they thought there is not enough space to type the answer

(Daniel Janik) Have you ever needed to bulk edit a table from excel to change it into a group of insert statements or change multiple query lines?

(Manoj) While working on some data analysis I saw one Spark SQL query was not getting me expected results. The table had some good amount of data, I was filtering on a value but some records were missing.

(Dinesh Asanka) How do you attach and detach databases in SQL Server? What is the difference between a SQL Server backup and restore vs. detach and attach?

(Maria Colgan) At the recent OOW European conference there was a lot talk about Converged Databases and how they can greatly simplify data driven app development.

(Pinal Dave) In the past, I have written a few blogs where I explained a few issues about the failure of listener creation Failure in a cluster. In this blog, we would see another cause of listener creation failure.

(Tim Radney) Azure SQL Database Managed Instance became generally available in late 2018. Since then, many organizations have started migrating to Managed Instance for the benefits of a managed environment.