Video Programming for IT Professionals
Author: SSWUG Research
Forgotten SQL Server Functions – VARP, SOUNDEX and NTILE
(Derek Colley) This article is ideally suited to SQL Server developers and those data professionals wishing to know more about SQL Server functions, and wanting to get a greater understanding of which functions are available and how they can help improve the efficiency and facility of SQL routines.
SharePoint Online – Changing Master Page through CSOM
(Tahir Naveed) This article explains how to change the Master Page through the Client-Side Object Model (JavaScript Object Model).
Will Doing Tasks Beneath My Grade Hurt Me?
People feel the need to help-out when managers ask them to. They feel that they are being a team player or good-soldier, even if the task is beneath their rank or level. This is fine for a very short and contained duration. But if the majority of your assignments are this way — it is detrimental to
DB2 pureScale Feature
(Frankie Sun, Jason Woods and Jo-Ann Woods) The DB2 pureScale Feature keeps your distributed database system available 24×7. WLB, ACR, and client affinities provide uninterrupted service during both planned and unplanned outages. If a member fails, applications are automatically rerouted to other DB
How to Avoid the Cursor in Stored Procedures
(Rajesh Kumar Chekuri) A cursor is a temporary work area it will create in memory when a SQL statement is executed. A cursor holds a set of records accessed based on a select statement. This temporary work area is used to store the data retrieved from the database, and manipulate/process this data r
Leverage Multiple Code Frameworks with One ASP.NET
(Jeff Fritz) In 2001, when Microsoft introduced the Microsoft .NET Framework and, with it, a new technology called ASP.NET, Web developers embraced it for building sites using a forms-based framework. This framework, known as Web Forms, stood the test of time for eight years, with enhancements and c
MySQL General Security Tips
(Rob Gravelle) Ease of use and speedy performance are just two of the many features that make MySQL one of the most popular databases in use today. Unfortunately, a high adoption rate makes MySQL a target for many malicious individuals and organizations.
Introducing MicroXML, Part 1: Explore the basic principles of MicroXML
(Uche Ogbuji) Parts of the XML community always grumble that XML is difficult to understand and process. XML is fundamentally complex for various historical reasons, and people proposed simplified versions for more than a decade. JSON and HTML5 threaten some of the most basic XML tenets. MicroXML a
Embracing SCRUM and CMMI in TFS 2012
(Subodh Sohoni) This article discusses how strongly Team Foundation Server 2012 supports the implementation of SCRUM and CMMI processes