(Willie Favero) It’s true, I do have (and have had for a long time) a kind of odd obsession with DB2’s subsystem parameters, or what are more commonly, and incorrectly, referred to as DSNZPARMs. This obsession has been going for a very long time. In fact, I think it all started when I heard Dave F
Author: SSWUG Research
MySQL-style LIMIT and OFFSET in DB2
(Henrik Loeser) An “ancient” but not yet well-known feature in DB2 is the support of MySQL/PostgreSQL-style LIMIT and OFFSET in SELECT statements and searched UPDATE/DELETE. Unfortunately, it is not really documented and I am working on getting some more documentation added (think about the “mostly
Automatic Row Tracking with Visual Studio 2013
(Amr Altahlawi) As databases are used by many applications and many users within those applications, it’s a common practice to log when data was created or last modified. In addition to knowing when the data was changed, knowing who changed the data is a common requirement in business applications.
Sentry 2 and PHP, Part 2: Authentication and access control for PHP
(Vikram Vaswani) Authentication and access control are critical to keep your web application secure. Sentry 2 is a framework-agnostic authentication and authorization system written in PHP. It provides built-in methods for many common authentication and authorization tasks, allowing you to efficient
Using MvcScaffolding Packages to Generate Repositories for your LoB Applications
(Suprotim Agarwal) ASP.NET MVC’s tooling support goes a long way in making it a LOB Application friendly platform. However the default Controller scaffold contains direct references to the DBContext.
Bind a CheckBox list from database using jQuery AJAX
(Brij) I have seen many questions in the forums that how can we bind the CheckBox list from the database via Ajax. There could be many ways to do in an ASP.NET but I will be using the one of the most efficient options available .
Reverse or Mirrored Bar Chart in SSRS
(Mike Davis) There are some pretty charts out there and most of them can be done in Reporting Services. There is one type of chart I had someone ask for that is not natively built in to SSRS. But with a little manipulation you can get the look you want. Here is an example of the chart I am talking […]
SQL Server – Kill all sessions using database
(Vishal Gajjar) Before an existing database can be restored, there should be connections using the database in question. If the database is currently in use the RESTORE command fails with below error:
Finding the metadata for a query
(Kenneth Fisher) You know I occasionally find it interesting how I learn new things. I was running through a practice test for the 70-461 and one of the questions had an odd command as one of the possible answers.
Setting a SharePoint Person or Group Field Value with CSOM
(Kirk Evans) I recently was asked a question about setting a Person or Group field value in a list using CSOM. This post shows how to programmatically set a user or group field value using CSOM.