The memory is still fresh from attending the 2019 PASS Summit just a few weeks ago, so here we share our three experiences with you. While we mostly came for the three days of knowledge, sharing and networking opportunities, we also came for the camaraderie and celebration of SQL Solutions Group. Our main office is […]
In 2014, we published a SQL-themed “Night before Christmas” blog post that proved highly popular with the SQL community. As an homage to that post five years ago, we present to you this year’s version….
‘Twas the day of PASS Summit, when all through the venue,SQL experts were hungry and grabbing a menu;Sandwiches were made and […]
Introduction
The SSISDB database (a.k.a. the Integration Services catalog) was introduced back in SQL Server 2012 to de-clutter the MSDB database and provide an in-house logging and reporting infrastructure. In a nutshell, SSISDB is an SSIS framework making SQL Server Integration Services more robust and enterprise-friendly by providing:
Database backup
Database encryption
Support for environments
Support project and package parameters
Package […]
Much has been written about the performance implications of the dreaded RBAR, a term coined by Jeff Moden many years ago. I won’t rehash any of that here other than to say that in almost all cases, set operations are faster and more efficient than RBAR. So we spend a lot of time teaching (or […]
Introduction
To deploy SSIS packages from SSDT to SSISDB, using Integration Services Deployment Wizard is one of the simplest and interactive ways. All you have to do is to right-click the package and click on Deploy, go through a few menus and you are done.
Problem
Unfortunately, SSIS is too bound to an Active Directory and would only […]
Introduction
While reading a summary from Brent Ozar on a SQL Server VLF problem highlighting a very well written article on how VLF could affect SQL Server performance by David Levy, I tried to find a more modern solution other than relying on an old-school DBCC LOGINFO.
Good news: Microsoft created a sys.dm_db_log_info DMV and even provided some recommendations on what a good number […]
As 2009 dawned, I was shopping for a new (read: used) car. The one I drove most of the time was, at this point, 14 years old.
I was focused on one brand and one model, but I was soon entranced by a different model from that brand—in fact, it was the top of the line. […]
In late July, Google announced the alpha release of Cloud SQL for Microsoft SQL Server and positioned it as a way for enterprises to “experience fully managed SQL Server with built-in high availability and backup capability” in the cloud.
The specs Google outlined for Cloud SQL are nothing to sneeze at:
Up to 30 TB of storage
Up […]
Introduction
Recently I had to work with a client that moved its infrastructure between servers (side-by-side upgrade). Always Encrypted was used on a previous server and I was tasked to make sure its all good on a new server.
This feature (available in SQL Server 2016 SP1 Standard Edition and up) is end-to-end encryption that allows clients […]
We now have a finished T-SQL framework, and this is the last post of the series. We start with the complete Template (with the error engine, activity log and batching). In this post, we’ll examine each new segment and focus on the batching feature, explain what is going on and the necessity.
The finished Template:
The Input […]
Gallery
Gallery
Gallery
Gallery
Gallery
Gallery
Gallery
Gallery
Gallery