MySQL is one of the most popular databases in the world and Node.js is a complete platform for building server side applications.
Community
SSIS vs. Oracle GG
(Kellyn Pot’Vin-Gorman) This is the third in a series of product identifications between Oracle and Microsoft to assist those attempting to understand the similarities and differences between these essential parts of any data platform environments.
Making A List
(David Fitzjarrell) In-lists can be a convenient way to search for multiple values in a single select statement.
Calling an Oracle Function with PL/SQL BOOLEAN Type from SQL
(lukaseder) One of the most wanted features in the Oracle database is the BOOLEAN type.
SSIS Expressions for Email Addresses, Random Numbers, File Names, Round, OR and XOR Logic and More Examples using SQL Server Integration Services
(Daniel Calbimonte) I read the previous article about SQL Server Integration Services (SSIS) Expressions and was wondering what other things can be done with SSIS Expressions?
NLog: Rules and filters
(Ivan Yakimov) In Confirmit, we use NLog library for logging in .NET applications. Although there is a documentation for this library, I found it hard to understand how the loggers work. In this article, I’ll try to explain, how rules and filters are used by NLog.
Video – Creating Azure SQL Database
(blobeater) A quick 2 minute upload (with sound, my voice) showing you how easy it is to create an Azure SQL Database using the Azure portal and then using SSMS (SQL Server Management Studio) to connect to it.
Changing the Time Zone of Azure VMs
(Denny Cherry) When you create a VM in Azure it’s always set to the UTC timezone. There are some times when that doesn’t work and it needs to be set for a specific time zone.
Methods to Insert Data into SQL Server
(Ed Pollack) There are a variety of ways of managing data to insert into SQL Server. How we generate and insert data into tables can have a profound impact on performance and maintainability!
Modern enterprise performance management for the agile business
(Stephanie Freyer) As companies look to fully embrace agility as a way of working and doing business, integrated planning is emerging as an ideal way forward.