Azure Storage tips

As a followup to my blog post Azure Data Lake Store Gen2 is GA, I wanted to give some pointers when using ADLS Gen2 as well as blob storage,...

2020-01-24 (first published: )

277 reads

DevOps for databases: “DataOps”

DevOps, a set of practices that combines software development (Dev) and information-technology operations (Ops), has become a very popular way to shorten the systems development life cycle and provide continuous delivery of...

2020-01-16 (first published: )

689 reads

My latest presentations

Just wanted to make everyone aware of my latest presentations that I recently uploaded. Details below. I also have a list of all my presentations with slide decks here.   Azure...

2019-12-04

24 reads

Microsoft Ignite Announcements

Microsoft Ignite has always announced many new products and new product features, and this year was no exception. Many exciting announcements, and below I list the major data platform...

2019-11-13 (first published: )

608 reads

Databricks Delta Lake

Introduced in April 2019, Databricks Delta Lake is, in short, a transactional storage layer that runs on top of cloud storage such as Azure Data Lake Storage (ADLS) Gen2...

2019-10-25 (first published: )

432 reads

Blogs

Using Erik Darling’s sp_pressure_detector to resolve CPU issues

By

Last Friday I spent my lunch break going through some links I had marked...

How to Resolve Remove-AzKeyVaultKey : Operation returned an invalid status code ‘Forbidden’ Error

By

I’ve come across another error message in my seemingly never-ending battle with Azure Key...

Continuous integration and delivery (CI/CD) in Azure Data Factory using DevOps and GitHub - Part 2

By

(2020-Jan-28) This blog post is a followup to my previous post about DevOps (CI/CD) for...

Read the latest Blogs

Forums

SSIS compoenents

By mcfarlandparkway

For SSIS to pickup any dll componenet where do we need to deploy?  some...

AWS instance storage

By Dhruva_51

We are planning to use one of AWS instance for sql server and wanted...

Insert New Rows in sql based on difference between 2 dates

By PSB

Hi,   I want to create a new records based on the difference between...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers