(Vinod Kumar) The more I play around with Encrypted backups, the more I get to uncover things. It is highly recommended that you read the other posts (Troubleshooting SQL Server 2014 Encrypted Backups) before going ahead because these are all linked in one way or other.
Other News
SSIS Packages executed from Visual Studio Business Intelligence Development Studio – BIDS [Design time] on a 64bit development server goes to unresponsive state during package execution.
(Snehadeep) Through the use of this blog, I would like to address a common scenario that you would run into when executing a complex SSIS package from within the BIDS environment in a x64 bit development server, where the visual studio- BIDS environment goes to a hanged state during the package exec
Improve SSIS data flow buffer performance
(Koen Verbeeck) I have a query that executes quite slowly in SQL Server Management Studio, but when I transfer the data with a SQL Server Integration Services data flow, it takes even more time! The source and destination are both fast and have no bottlenecks, and there are no significant transforma
Multiple File Upload using ASP.net File Upload Control and __dopostback event
(sheikhsaqib) Sometime you need to upload multiple files instead to selecting one by one. Here is the solution in which multiple images can be uploaded without clicking UPLOAD button in ASP.NET using C#.
cstore_fdw and big data
(Josh Berkus) About a month ago, PostgreSQL fork vendor and Data Warehousing company CitusDB announced the availability of the open-source cstore_fdw. This foreign data wrapper creates an external table with highly compressed data, which allows you to keep large amounts of archival data on your Pos
IBM UDB DB2 Database restore and SQL1035N
(Kaushik Nagaraj) I have been trying to create a script that will refresh the test database using QA data on a regular schedule. As part of the script I force all the connections and then deactivate the database.
DB2 for i 7.2 Functions, Functions, Functions
(Michael Sansoterra) In this tip about new DB2 for i 7.2 features, I’m going to cover some noteworthy news about user-defined function (UDF) features. The feature list includes how a function name is now resolved based on casting rules, named parameters, parameter defaults and array parameters.
Developing Error-Free Native Stored Procedures
(Tony Andrews) Stored procedures in relational database management systems (RDBMSs) have been around a long time, and they merely call another program that performs some action or actions for the calling program. There are many benefits for having a called stored procedure do some of the work.
5 jQuery Methods for jQuery Newbies
(Ansh) jQuery is a concise and fast JavaScript library made by John Resig in the year 2006 with a pleasant objective that is write less, do more. It simplifies the traversing of the HTML document, animating, event handling and Ajax interactions for instant web development.
Reset all Fields using jQuery
(Jagbir Saini) This is a common requirement while developing a web form which consists of various Input controls like Textbox, Radio Button, Checkbox, DropdownList, File Upload etc. We also need to have a button which clears the value of all the fields. Generally we named this Button as Reset.