(Pinal Dave) This blog post is a bit of a different post than the normal blog posts which I write as the topic of this blog post is SQL Terms vs MongoDB Terms.

(Andrey Podkolzin) I’ve been working for a company that develops IDEs for database interaction for more than five years. Before starting to write this article, I had no idea how many fancy tales would lie ahead. Thus after making 30 pages of it, I decided to group up the tales thematically and divid

(blobeater) Moving to public cloud such as Azure, AWS or even private cloud services you need to be tracking costs and seeing if you are “effective”.

(Aveek Das) Recently, I had a requirement from one of my clients to design a Power BI report in which they wanted to visualize the cumulative sales by week of quarter.

(Paul White) The ALTER TABLE … ALTER COLUMN command is very powerful. You can use it to change a column’s data type, length, precision, scale, nullability, collation…and many other things besides.

(Pinal Dave) Earlier, I wrote a blog about fixing one of the issues which I reported to Microsoft. In this blog, I would share another issue that I reported via my blog and it got fixed in the latest release. SQL SERVER – Scrollbar in the Middle – Bugs Fixed by SSMS Team.

(Kenneth Fisher) The SQL_VARIANT data type is an interesting beast. It is a data type that can store most types of data. So a date, decimal, int, varchar etc. can be stored in this single data type. This sounds great right? Well there are a few issues here.

(Ron L’Esteve) In my previous article, Azure Data Factory Pipeline to fully Load all SQL Server Objects to ADLS Gen2, I demonstrated how to create a dynamic, parameterized, and meta-data driven process to fully load data from a On-Premises SQL Servers to Azure Data Lake Storage Gen2.

(Grant Fritchey) Over the next couple of months, I’ll be putting on a number of different sessions teaching about the tools supplied by Microsoft, for free, that can help you when tuning your queries. One of the most important of these tools is Extended Events.

(Pinal Dave) I recently installed the latest version of the SQL Server Management Studio for one of my demo sessions. While preparing for it I realized that one of the things for which I used to make fun of SSMS is no longer available.