Working with SQL Server in Hybrid Cloud Scenarios
A hybrid cloud is a fairly attractive model when implementing cloud computing in enterprise...
Execute Powershell in SSIS Using C#
Introduction PowerShell is a Shell included in Windows to automate tasks in the operative system and other applications like SQL Server,...
Transparent Data Encryption and Always Encrypted
If you need to store confidential data in your database, you can use data encryption. SQL Server supports encryption with symmetric keys,...
SSAS: Attention, Accuracy, and All the Benefits
This article is about working with Microsoft Analysis Services and a little bit about the...
Introduction to Temporary Tables in SQL Server
A temporary table in SQL Server, as the name suggests, is a database table that exists temporarily on the database server. A temporary...
Why Multiple JOINs are bad for Query or Do Not Get in the Way of Optimizer
Recently, I came across an application that generated DB queries. I understand that there is nothing new about that, but when application...
CombGuid: Generation of SQL Server-friendly Guid Values in .NET Applications
Usage of UUID as a primary key for tables has a bunch of pros, including the option to retrieve IDs...
Pitfalls of Linked Server Usage
An interesting project related to the task queue processing come to the company I work for. It was previously developed by another team. We...
Dynamic T-SQL and Benefits of its Usage
In our projects, we have to cope with different tasks. To solve some of them, we use dynamic T-SQL. Why do we need dynamic T-SQL? Well, it...
SQL Server Security Ponderings
DBA is the guardian of the data, and there are two aspects of being a guardian. The first one is...
