By Avi Niv
Recently we deployed database mirroring in an environment with an Active Directory. The process is usually quite simple and straight-forward, but this time was different.
The mirroring should have been scripted, so it could be embedded in an application’s installation and deployed worldwide. As in any other sensitive infrastructure solution, monitoring is essential. Microsoft provides the sp_dbmmonitor stored procedures to configure and review monitoring metrics. Even though are not user-friendly, they are manageable.
There are several options to watch what's going on with your mirroring.
By Guy Glantser
Let's say you are developing an SSIS package on your dev box to load data from an Excel file to SQL Server. For this example, let's assume your dev box is Windows 7 64-bit with SQL Server 2012, and the Excel version is above 2007 (meaning you're using an "xlsx" file).
So you launch SQL Server Data Tools, you create a new SQL Server Integration Services project, and you drag a Data Flow Task onto the control flow design area. Then you go to the data flow design area and you drag the Excel Source component. You create...
Madeira’s excellent course on SQL Server Integration Services starts in March, but you can get a head start here! Take a tour through a few articles, specially chosen by us to get you going, from setting up SSIS to creating your very first work there. Why not check out our custom-built starter pack?
Starting in March, Guy Glantser will lead a course on SQL Server Integration Services. If you’ve taken one of Guy’s courses before, you already know he’s a dynamic, exciting, extremely knowledgeable teacher. If you haven’t, you’re in for a treat.
Once a week for five weeks, we’ll dive in to SSIS, starting at the beginning but quickly moving to the increased benefits you can get from it if it’s already part of your work. After creating our first packages, we’ll cover troubleshooting and administration, working with parameters, and the crucial topic of error logging.
For anyone who works with SSIS now...
We mark the start of 2014 with a big company event, as we start every year. This month’s newsletter has photos, upcoming events, and career opportunities. Welcome to another great year with Madeira!
By Avi Niv
Recently I was asked to investigate a timeout issue that was causing SSIS package executions to fail.
The timeouts seemed to have no pattern of any kind, there were no long blocking queries, the packages' sessions were SUSPENDED until they timed out, and the sessions were not blocked at any point. At first glance, there was no reason to suspect a memory issue, since all user queries executed successfully and so did most of the SSIS packages. Furthermore, packages that did time out occasionally executed successfully from time to time and the number of executions remained the same.
By Eitan Blumin
Service Broker is a cool feature new since SQL Server 2005. Yes, SQL 2014 is just around the corner so it’s hardly “new” any more. But in reality, many DBAs and database users are still not aware of this feature, don’t know how to utilize it, or are afraid to do so because they’re not familiar with it.
In my previous post in the series, Service Broker Sample: Multi-Threading, I showed a rather advanced scenario where we can implement a multi-threading solution inside the SQL Server database engine. In this post, I hope to show a simpler scenario...
Dikla Aviv has written a post to help each and every one of us figure out a career path. Sometimes you just need to stop and take a look around.
Guy Glantser is on his way home! At the final day of the PASS Summit, he went deep into the internals of SQL Server with four intensive sessions that filled his head with dreams of further study...
Guy Glantser is on his fourth day of the PASS Summit this year and meeting some people whose work he's been reading all these years. Kimberly Tripp, Jonathan Kehayias, and Paul Randal on today's post!