(Shaun J Stuart) Last time, I talked about the issues with trying to get a server to monitor itself for downtime. In part 2 of this series, I’ll talk about my solution for monitoring. In the final part, I’ll discuss how to use the logged data for reporting.
Author: SSWUG Research
Oracle Exadata Basics
(David Fitzjarrell) Since its introduction in September, 2008, Exadata has fast become both a familiar term and a familiar sight in the IT/database realm. The system has undergone several changes in its short history, from storage solution to complete database appliance.
Generation of XML, XSD, DTD With Java
(Debadatta Mishra) As you know XML documents play a very significant role in modern projects and product development. Apart from XML documents we encounter jargons like XML schema, XSD and DTD files.
Visual Studio Tips: Copy & paste tricks
(Susan Ibach) Here’s a few hidden tricks in Visual Studio for those who love .
Speed up parsing of XML in C# Compact Framework (using XmlTextReader & XElement)?
(Armen) I am trying to import large XML file (goal is 100,000 rows) to import it to SQL CE database file (with Compact Framework 3.5 and SQL CE 3.5).
Constraints in SqlServer 2008
(Amit Singh) In general terms constraints are a kind of validation which validates the data at table level on the event of any change in data such as (Insert/Update/Delete).
SSWUGtv Data Points Briefing: Kevin Kline discusses SQL Server 2014 and the features that you can try out in the free preview.
Video Programming for IT Professionals
Using JSON in WebSphere Cast Iron, Part 2: Invoking JSON-based REST APIs
(Rajath Ramesh and Manjunatha D) IBM WebSphere Cast Iron introduced two activities, Read JSON and Write JSON to work with JSON data. Part 1 of this 3-part series showed how to configure JSON handling activities to invoke JSON-based REST APIs and to create your own. Part 2 shows how to build an orche
SQL Server Analysis Services (SSAS) 2012 Standard Deviation Functions
(Scott Murray) How does the standard deviation and related statistical functions work in SQL Server Analysis Services? Are those functions natively available? Can you call this code in MDX? Check out this tip to learn more.
Stored Routines to easily work with the SQL_MODE
(Federic) Working with the SQL_MODE can be tricky, because it’s a command separated list involving long keywords. To be honest, I hate to rewrite the flags, trying to read an unreadable list, etc. Of course some string functions can help (Justin Swanhart suggests to use REPLACE() to make comma-separ