(Jason Brimhall) One of the more gut-wrenching experiences of a DBA is to have a database get stuck in recovery. This typically happens when the server was rebooted unexpectedly and typically coincides with a rather large transaction.
Tag: sql server
(Marcin Policht) Data imports represent some of the more commonly performed database management tasks. When importing data into Azure SQL Database, you can leverage a number of traditional SQL Server data import techniques.
(Pinal Dave) I am happy to write this blog post as I am really happy that finally, SQL Server Engineering team has decided to fix the error which we all have been struggling for many years.
Comparing The Performance Of Reading Data From Files With File.Contents And Web.Contents In Power Query And Power BI
(Chris Webb) In my last post I mentioned the Power Query engine’s persistent cache, which in some scenarios caches the data read from a data source when a query is refreshed.
(Prashanth Jayaram) This guide is all about provisioning SQL Server 2019 using Azure Container Instance (ACI), including the installation and configuration.
(Edwin Sarmiento) In our previous tips we look at how to setup Containers on Windows and Linux. In this tip we will introduce several docker commands that you can use to manage and work with Containers both on Windows and Linux.
(Grant Fritchey) One part of my job is to understand the compliance landscape. This means that I read a lot about the GDPR and related similar laws.
(Kenneth Fisher) Todd Kleinhans (b/t) is host for T-SQL Tuesday this month and wants us to talk about how we use databases in our day to day life.
SQL SERVER – Script Level Upgrade for Database ‘master’ Failed Because Upgrade Step ‘SSIS_hotfix_install.sql’ Encountered Error 15151
(Pinal Dave) Recently I was helping a client where SQL Server upgrade was failing with an error. If you have seen my blogs, there have been many blogs where I explain steps to fix upgrade-related issues.
(James Serra) As a follow-up to my blogs What product to use to transform my data? and Should I load structured data into my data lake?, I wanted to talk about where you should you clean your data when building a modern data warehouse in Azure.