(Dilkush) XML to SQL (or to any relational database) could be real pain if XML has schema with lots of nodes and sub nodes.
Author: SSWUG Research
DBA Myths: You can’t use an alias in an UPDATE statement.
(Kenneth Fisher) I’ve found a very common belief among users of T-SQL (both DBAs and Developers) is that you can’t use an alias with the UPDATE statement. As best I can tell the reason for this is because of a simple misunderstanding of the UPDATE command syntax.
Availability Monitoring – Part 3
(Shaun J Stuart) This is the final almost final part of my series of articles about creating a process to monitor your SQL Server for downtime. Part 1 can be found here. Part 2 can be found here.
How to check if your databases are part of a replication
(Ivan Donev) If you need to check if there is any database on your SQL instance, related to replication, you have couple of different options – from manually checking through SSMS to using different options with T-SQL. Now I will share a simple script that you can use if you need to quickly check if
How to Log Service Requests (SRs) for Oracle SQL Developer on My Oracle Support (MOS)
(Jeff Smith) Someone told me today that they can’t log a support request with my Oracle Support for SQL Developer.
One to one chat using Asp.net SignalR groups
(KedarRKulkarni) I have been experimenting a lot with SignalR these days. During this time, I tried to implement a fully functional chat client(web) with the help of SignalR.
5 Reasons to Use Oracle Scorecard and Strategy Management
(Christian Screen) When Oracle released the Oracle Scorecard and Strategy Management (OSSM) component of the Oracle BI Foundation Suite there were few questions and even less answers about the product offering than I think most Oracle BI aficionados would have expected.
SSWUGtv Data Points Briefing: Kevin discusses the SQL SERVER 2014 CTP and Buffer Pool Extensions.
Video Programming for IT Professionals
Securely integrate an LDAP user registry with IBM Business Process Manager
(Mark Connell and Shili Yang) IBM Business Process Manager includes an internal security provider for user access management. However, you may want to leverage an existing user registry, such as an enterprise user directory in LDAP, instead of recreating and maintaining the users and groups in the B
Using a loadbalancer with MySQL
(Daniel van Eeden) A loadbalancer is used in many MySQL setups. Loadbalancing can be done with an hardware loadbalancer or with software. Software solutions tend to be a fair bit cheaper.