(Tim Ford) If you’ve been working with Microsoft SQL Server for any length of time, you’ve probably strewn about a collection of scripts you call upon on a regular basis across many folders, thumb drives, cloud-based folder sync applications, and floppy disks (some of us remember those).
Other News
Performing Audit in SQL Server Integration Services
(Mridul Chandhok) In this blog post, let’s have an insight on how Auditing can be done in SSIS packages?
Time-Series Database Requirements
(Baron Schwartz) I’ve had conversations about time-series databases with many people over the last couple of years. I wrote previously about some of the open-source technologies that people commonly use for time-series storage.
Scrambled Output from db2top
(Ember Crooks) I don’t know about you, but I’m pretty addicted to db2top. I started using it way back when it was a download from Alphaworks. It is simply unparalleled for free real-time monitoring for DB2.
The DB2Night Show z48: Where is the Problem in My z/OS Transaction?
(Martin) 100% of our studio audience learned something!Martin showed the sources of transaction data both within and outside of DB2, and the considerations for end-to-end problem resolution.
ADF BC Reserved Mode for DB Connection Critical Applications
(Andrejus Baranovskis) With this post I would like to explain how you can control ADF BC mode and switch from default managed to reserved mode and back. With default managed mode, there is no guarantee in ADF BC for DB connection to stay assigned for the user session.
Move That Datafile!
(Steve Ries) Moving datafiles has always been a pain. There are several steps, it’s fairly easy to make a mistake and it requires the datafile to be offline. There are also different steps depending on whether the database is in ARCHIVELOG mode or not. In ARCHIVELOG mode, the steps are…
Oracle Audit Control part 1 – location of the audit table
(Neil Chandler) One of the oldest problems with the Auditing capabilities within Oracle is that the SYS.AUD$ table resides in the SYSTEM tablespace. Unless you are rigorous in ensuring that your audit records are routinely pruned to keep the table manageable, it can single-handedly make the SYSTEM t
MVC 5 with EF 6 in Visual Basic – Creating a More Complex Data Model
(Mike Brind) This tutorial is the sixth in a series of 12 that teach you how to build MVC 5 applications using Entity Framework for data access and Visual Basic. In the previous tutorials you worked with a simple data model that was composed of three entities.
Working with DropDownList in ASP.NET MVC
(Sheo Narayan) In this article, we are going to learn several tips and tricks of working with DropDownList in ASP.NET MVC.