(Pinal Dave) Earlier this week, I wrote about SQL SERVER – Simple Example of Batch Mode in RowStore. It was very well received and lots of people started to ask questions after reading the blog post. The most asked question was about the Performance difference between RowMode and BatchMode.

(Jason Brimhall) The second Tuesday of the month is upon us once again. That means it is time for another group blog party called TSQLTuesday.

(Ben Richardson) This article covers how to connect a Python application to Microsoft SQL Server using a 3rd party Python SQL library. The library that we are going to use is called “pyodbc”, which is freely available.

(Koen Verbeeck) I’ve created a couple of charts and PivotTables using Excel. Can I share these with my coworkers in the Power BI service? Or do I have to create everything in Power BI Desktop? What is the difference between a dataset and a workbook?

(Tim Radney) Migrating an on-premises SQL Server instance to an Azure Virtual Machine (VM) is a common method to migrate to Azure. IT professionals are familiar with scoping the size of VMs with regards to vCPU, memory, and storage capacity.

(Marcin Policht) The networking capabilities of Azure SQL Database have been evolving since its inception, as the service offering became more diverse and the underlying infrastructure platform matured.

(Pinal Dave) Why do organizations keep their entire team ready and available when any new deployment is about to happen? Well, the answer is pretty simple: there are many different variables that can go wrong when the new deployment happens.

(Mohammed Moinudheen) One great feature of SQL Server is the ability to get alerts when there are issues. The alert process can send email notifications using Database Mail after you have configured your SMTP settings and setup your jobs and alerts to use this account. In some cases, you may not hav

(Pinal Dave) One of the reasons, I love my job is that I get to work with the latest technology and also get to speed up the client’s computer. Recently one of my clients upgraded their SQL Server to the latest version SQL Server 2019. After the upgrade, they expected that the performance of SQL Ser

(Joydip Kanjilal) Entity Framework Core (EF Core) is a lightweight, open source, cross platform and extensible version of Microsoft’s popular ORM Entity Framework. EF Core is light-weight and runs on top of the .NET Core runtime. While working on ORMs we often use models that are mapped to database