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.
Other News
HADR Tools: HADR Calculator
(Ember Crooks) The HADR Calculator is one of three HADR tools provided by IBM on developerWorks.
SQL SERVER – SQLCMD to Build Comma Separated String
(Pinal Dave) We have an active usergroup in Bangalore called SQLBangalore. Whenever I get a chance to attend the local usergroup sessions (which happens often – trust me), I get to learn something every single time.
Unified ASP.NET 5 – Using MVC 6, WEB API and Entity Framework 7 in an Application
(Mahesh Sabnis) Visual Studio 2015 Preview comes with some new and exciting enhancements for web development, cloud development and cross-platform mobile development. A prominent change in this release is the unification and combination of MVC, WEB API and Web Pages in a single programming framework
Export GridView Records to XML Using ASP.Net C#
There is often a need in a project’s reporting module to export GridView Records to XML. So by considering that requirement I decided to write this article especially focusing on beginners and those who want to learn how to export a GridView to XML using ASP.NET C#.
Date Ranges in Data Warehouses using Oracle 12c
(stewashton) When you load data with an “effective date” into a Data Warehouse, what happens when the new data is the same as yesterday’s? Do you add a new record with the new “effective date” or do you update a date range in the existing record?
PECL/mysqlnd_ms needs updates for MySQL Group Replication
(Ulf Wendel) ‘Synchronous’, multi-master, auto-everything – that’s the new MySQL Group Replication (IPC14 talk/slides) in simple words. After torturing PHP developers for decades with MySQL Replication there is now a new replication option which does not require read-write splitting.
Analyzing Historical Performance Data – Access Paths
(Lockwood Lyon) The Explain facility produces a report of SQL access path information in the form of rows entered into a Plan Table, a Statement Table, and other performance-related tables.
How to Get SQL Column Values as Comma Separated String using XML Path Method
(banitabisht) There are many scenarios where we have to show the values of column value as comma (or any other special character) separated string in result set.
Resumable functions in C++
(Raman Sharma) Last year, in a CTP release, we had provided a glimpse into resumable functions and await support in the Visual C++ compiler. In Visual Studio 2015 Preview we have gotten further along that journey and provided a more general purpose solution.