Loading to Azure from On-Prem SSIS

In my introduction to the topic of using SSIS in the cloud, I noted that SSIS is not currently available...

Step By Step Logshipping configuration

Log shipping provides a means to maintain a secondary server on an automated basisusing a chain of transaction log backups. This chapter explains the basic confi guration oflog shipping...

Step By Step Logshipping configuration

Log shipping provides a means to maintain a secondary server on an automated basis
using a chain of transaction log backups....

SQL Server Permissions – Database Roles

A fundamental component of SQL Server is the security layer. This article covers three common security misconfigurations in SQL Server.
Related Posts:

When Too Much is Not a Good Thing December...

SQL Server Permissions – Database Roles

EZ PZ Permission Squeezee
Given the critical level of importance related to permissions, one may think it is a concept that...

Random Blog Post Challenge

OK, for no particular reason at all or maybe because I had too much food at lunch or just because...

The Psychology of Value

J.C. Penney is one of the oldest and most storied retailers still in existence in the United States. For years,...

Tempdb settings in SQL Server 2016

A nice little error log feature that I noticed in SQL Server 2016 regarding tempdb. Tempdb, a system database in...

Do you need a degree to be DBA?

This question gets asked a lot and reoccurs over the years. Do you need a degree to be DBA? I have seen...

Power BI Hands-On Workshops in April, 2017

During the month of April, I will be delivering three full-day Power BI hands-On workshops.  Each of these events will...