(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,
Author: SSWUG Research
SSIS Event Propagation
(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.
How do I tell what stored procedure from inside the stored procedure?
(Kenneth Fisher) I’ve occasionally had the problem of trying to put “smart” logging messages into a process. You know the ones, you’re trying to set up logging for a process and you really want to create a somewhat generic piece of code that you can throw into each stored procedure.
Recording Media in a Windows Store App Part 3: Video Capture
(Eric Vogel) Welcome to the third and final installment of the MediaCapture API series, where I’ll cover how to record video with audio from a video camera in a Windows Store app. The user will be able to record and save a video in a given video format and encoding quality.
Monitoring a SQL that executes well thousands of times but sometimes it takes longer
(Carlos Sierra) There is this SQL that is constantly executed by many users. This SQL executes in a subsecond thousands of times per day. Every once in a while the same SQL takes several seconds but these incidents are uncommon. Tracing would cause significant overhead since there is no known way to
PYTHON / Additional Examples and Usages of XML
(Jimmy Gunawan) In previous post, I talked a lot about XML and probably some of you got confused on how we can really use this XML writing and reading knowledge. This is normal.
How to create an archival backup and maintain it forever
(Marco V.) Sometimes it could happen to retain a backup for a very long time, even forever that is it should be maintained until you manually remove it.
SSWUGtv: How do you follow-up after an interview? Before a thank-you note, what do you do to make sure you make a lasting impression?
Video Programming for IT Professionals Career management advice, coaching and much more. We discuss making the best of your professional development, provide specific tips and ideas for advancing your career and even answer questions from field.
Configure SQL Server Security to Allow Only Browsing of SSIS Packages
(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
SharePoint 2013: Clicking the icon in Type column is highlighting the item instead of launching the document
(Chris Grist) If we step back to SharePoint 2007 before Bieber fever, before the first black US president, before 1D and before many hours lost to Angry Birds; we had a field in SharePoint called DocIcon and when you clicked on it, it would open the associated document.