Video Programming for IT Professionals Career management advice, coaching and much more. We discuss making the best of your professional development, provide specific tips and ideas for advancing your career and even answer questions from field.
Author: SSWUG Research
How to hot-add a vCPU to a virtual SQL Server
(Simon Liew) I have SQL 2012 Enterprise installed on a Windows Server 2008 R2 Enterprise Edition virtual server. One of the benefits of running SQL on virtual environment is the capability to present additional vCPUs to the virtual server online and real-time without interruption to running processe
Snazz Up Your MVC Apps with Twitter Bootstrap: A Get-Started Guide
(Ondrej Balas) As a developer, it can be challenging to create a nice-looking user interface, especially one that’s consistent between applications.
Licensing distributed DB2 10.5 servers in a high availability (HA) environment
(Amyris Rada and Roman Melnyk, B.) Are you trying to license your IBM DB2 Version 10.5 for Linux, UNIX, and Windows servers correctly in a high availability environment? Do you need help interpreting the announcement letters and licenses? This article explains it all in plain English for the DB2 10.
Understand jQuery Ajax Function: Pass JSON Data to Service Method
(Sourav Kayal) Welcome to the Understand jQuery Ajax article series. This series explains the Ajax methods of the jQuery library. Our previous articles explained how to consume various types of services using a jQuery Ajax method. You can get them here.
Create SQL Table Schema based on data from flat files
(Pradeep SVS) Today we ll see how to create a SQL table schema based on flat files(excel, csv, txt formats).
WPF Base Classes – Selector
(Richard Carr) The thirty-sixth part of the Windows Presentation Foundation Fundamentals tutorial looks at another WPF control base class. This article describes the Selector class, which is subclassed by controls that allow the user to select from a list of values.
SQL Server – Custom sorting in ORDER BY clause
(Vishal Gajjar) ORDER BY clause can be used to sort the results returned by SELECT statement in SQL Server. It orders the result set by specified column list. When used with character data type columns it sorts data in dictionary-order.
SSIS Execute SQL error – No disconnected record set is available
(Mike Davis) If you get the error in SSIS that says:
ADO.NET: Using JOINs to get Data from Multiple Tables
(Ged Mead) In this previous post, I showed you how easy it is to create a Master-Detail form with the tools built in to Visual Studio. In that example, two separate controls were used to display the related data from the two tables. But sometimes you’ll want to get data from two or more tables and