Applying SQL Transformations and Handling Missing Values in Azure ML
In this article, we will introduce SQL transformations in action. We will also see how to handle...
Automating the Tabular Model Processing of Analysis Services (SSAS) Databases in SQL Server
This article talks about automating the processing of the Analysis Services database in SQL Server. Automation is one of the most important...
Installing SQL Server Failover Cluster Instance – Part 1
In this article, I am going to explain the process of installing SQL Server on failover cluster instance (FCI) on the primary node. First,...
Automate Database Test Restore in SQL Server
This article talks about automating the database restoration process which is often done manually...
T-SQL Regular Expressions: SUBSTRING, PATINDEX and CHARINDEX
In my previous article about T-SQL regular expressions, I have explained the LIKE operator, its usage and provided several examples with...
Hosting Plugins in the Jenkins Community Repositories
It is the third of a series of articles devoted to the problem of Jenkins plugin implementation and hosting. If you haven’t got...
Basics of SQL Server Task Automation
This is an introductory article about automation in SQL server primarily focused on the basic...
Transact-SQL: Working With Strings
Microsoft SQL Server has many built-in functions that can be used to format the output and represents it in the desired format. In this...
Create Indexed Views in SQL Server
Introduction You would have already heard about views in databases. We create views for a number of reasons. One of the main reasons for...
10 Best MySQL GUI Tools
MySQL is among most widely-used and popular database technologies, so quite a lot of tools have...
