SQL Server Table Partitioning and Partitions Tutorial

Database development, Tables

Problem In this article, we will focus on the demonstration of table partitioning. The simplest...
Read More

Oracle Database Security – Encryption and Decryption

Database administration, Security

Data encryption is very important because it’s a way to protect the current and the archived data in order to ensure its confidentiality....
Read More

Microsoft SQL Operations Studio: Configuration and Querying

Tools & technologies, Utilities & Extensions

In my previous article, Microsoft SQL Operations Studio: Understanding and Installation, we discussed deeply the need for a new SQL Server...
Read More

Microsoft SQL Operations Studio: Understanding and Installation

Tools & technologies, Utilities & Extensions

SQL Server Management Studio is considered as the default integrated graphical user interface tool...
Read More

Struggling with Data Export from Microsoft Dynamics 365 CRM to External Portals

Database administration, Work with data

Though Microsoft Dynamics 365 does not offer any built-in feature to export the CRM data to external portals so far, there is a simple way...
Read More

T-SQL BEST Practices

Languages & Coding, T-SQL • 3 Comments

In this article, we will discover some best practices of T-SQL queries. Badly written queries can cause performance and I/O problems. For...
Read More

Grouping Data using the OVER and PARTITION BY Functions

Database administration, Work with data • One Comment

The OVER and PARTITION BY functions are both functions used to portion a results set according to...
Read More

Restoring Database with CDC Enabled

Tools & technologies

In this post, I am going to talk about an issue I found while restoring a backup of CDC enabled database to a different SQL instance. You...
Read More

SQL Server – Dissect the Internals of sp_spaceused

Database development, Stored Procedures

This article is an effort to dissect the output of the sp_spaceused stored procedure. Introduction Understanding the database usage...
Read More

Real-Time Operational Analytics and Non-Clustered Column Store Index

Database development, Indexes

In this article, we will focus on real time operational analytics and how to apply this approach to...
Read More
Close