(Fikrat Azizov) In these series of posts, I am going to explore Azure Data Factory (ADF), compare its features against SQL Server Integration Services (SSIS) and show how to use it towards real-life data integration problems.
Tag: sql server
Tuning Azure SQL Elastic Pools
(blobeater) The below image is a beautiful picture, now it could be worse. The red line and the green line could peak at the same time and for a very long time or the blue line could behave the same as the red line and peak at the same time as the green line.
Database In Recovery Redux
(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.
Importing Data into Azure SQL Database
(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.
SQL SERVER – Identify the column(s) responsible for ‘String or binary data would be truncated.’
(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.
Provisioning SQL Server 2019 Azure Container Instance using PowerShell
(Prashanth Jayaram) This guide is all about provisioning SQL Server 2019 using Azure Container Instance (ACI), including the installation and configuration.
Docker Commands with Examples for SQL Server DBAs – Part 3
(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.
Data Breaches: All Your Fault
(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.
Writing Crossword puzzles with a database: T-SQL Tuesday #113
(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.
