(David Dye) In a recent post outlining how to report errors in SSIS I briefly discussed event propagation in an SSIS package. Creating the sample package for this post re-introduced me to some of the intricacies and nuances of event handlers.

(Melissa Coates) SSRS has the capability to schedule the refresh of report snapshots via a report-specific schedule or a shared schedule. However, what if you don’t have a specific time you want the refresh to run? Alternatively, what if you want the snapshot to be refreshed after an event occurs,

(Sal De Loera) This post contains the following queries that support development and operational tasks within a Microsoft Parallel Data Warehousing (PDW) Appliance environment.

(Pinal Dave) “How do I return a few of my resultset rows at the bottom of the entire resultset?”

(Chad Churchwell) I was recently approached by the DEV team and since they have no access in QA and Prod, they asked if they could be able to just see the package and folder structures through SSMS from their workstations. Since Integration Services connectivity is outside of SQL and controlled thro

(Francis Hanlon) If you are using replication in SQL Server, you can monitor it in SSMS, but it makes sense to monitor distribution jobs automatically, especially if you can set up alerts or even set up first-line remedial action when a problem is detected.

(Arshad Ali) In my last article, I talked about how you can use an FTP task in SSIS to download files from an FTP server. But what if the file you have downloaded is an XML file and you need to import this data from the XML file into a SQL Server table? How do you process/parse XML data into […]

(Colleen M. Morrow) Once upon a time, in a blog post far, far away, I started talking about auditing in SQL Server. And I told you all about how to use SQL Audit to monitor what’s going on in your databases. Remember that? If you do, you might also recall that I mentioned there being more than on

(Pinal Dave) There are many different ways of scaling SQL Server to accommodate more transactions and throughput. The general scale-up approach includes:

(Rohatash Kumar) In this article, I would like to show the similarity of the SQL GetDate function and the C# DateTime class. Many developers use the DataTime function to find information related to date and time in SQL Server. Here we will see how you can do it in C#.