(John Brady) So far our AWR report query shows overall duration between two consecutive snapshots, database time (i.e. doing work), SQL execution time (may be lower), total wait time, wait time by class, and some common specific wait events. We know how busy the database was and how much time it spe
Author: SSWUG Research
CRUD Operations using AutoMapper in C# MVC Application
(Akhil Mittal) In our article series of Learning MVC, we learnt a lot about MVC, about various techniques to communicate to database in MVC applications, and few internal concepts too.
Backing Up a SQL Server Database Directly Onto a Remote Server
(satnam singh) Recently I encountered a situation where the backup drive was short of space on the production server. The policy on the production server was that as soon as soon as the Full Backup is complete, a copy of the production backup is transferred to the staging server using RoboCopy and t
Adding a column to a table with a default (NULL vs NOT NULL)
(Kenneth Fisher) There are lots of ways to learn new things, or be reminded of old things. One of my favorites is the QotD on sql server central. Recently there was an interesting question on defaults. It pointed out that there is a difference between adding a column with a default that allows NULLs
‘You’ve got access, but I’m not sure why’
(Michael J. Swart) Use “xp_logininfo” when curious about how and why someone has access to a database.
XML Serialization for interfaces in .NET
(brooknovak) In your quest to find out how you can support XML serialization for types that contain interfaces, you may often find yourself coming to the same answer: you cannot serialize interfaces. That is true, but you can work around it, and I will present two methods.
Using JQuery to parse XML
(Travis Jorge) JQuery is a powerful scripting tool that allows you to add a lot of interesting features to you websites and web applications. One of which is the ability to parse XML and then do something with the data. In the example below I parse out an XML document of calls and create a list from
Read and Write Microsoft Excel with Open XML SDK
(Dr. Song Li) This article presents an example on how to read and write Microsoft Excel with Open XML SDK.
Using a custom composite types in PostgreSQL
(Pavel Stìhule) I like a custom composite types – in PL/pgSQL. I don’t use a composite types in tables ever. There is a risk of some issues with composite types on client side – a client language drivers usually doesn’t work simply with custom composite types – so I use it only on server side.
Are you looking for some excellent DB2 11 reading materials?
(Willie Favero) Let’s see, if it’s fall, there’s a new DB2 for z/OS just going generally available (GA), and IDUG EAMA and IOD 2013 are the major happening events, it can only mean one thing; Julian Stuhler must have a new white paper available. Well, that’s almost true.