T-SQL Scripts to Monitor your Resource Pool Stats
Imagine you have a business-critical MS SQL Server serving requests for both OLTP and some batch...
Import JSON Data with SQL Developer Web into Autonomous Database
Twitter Activity provides loads of information for analysis. You can learn your target audience better, determine the most popular content,...
Entity Framework – Just a Few Clicks Away
Entity Framework is an open-source object-relational mapping (ORM) framework for .NET applications. It let the developers work with data on...
How to Check Status Of SQL Agent Jobs using PowerShell Tool
From a certain point in my career, I started to play around with PowerShell. But I never imagined...
Oracle Data Integrator (ODI) Tutorial: How to Import Files into Oracle Autonomous Data Warehouse (ADW)
When you build an ETL / ELT enterprise system, you need the Data Integration tools, such as Microsoft SQL Server Integration Service,...
MySQL UPDATE: Top 5 Tips for T-SQL Developers
Are you adding MySQL to your list of database skillsets? Then MySQL UPDATE statement is one of the commands you need to learn. We are...
Creation of Pandas DataFrame in Python with Examples
Python is a general-purpose language that can work with various types of data structures and solve...
LINQ in C#: A tutorial with Query Examples in LINQ to Objects
Less is more – this is definitely true when it comes to object collections and LINQ queries. One of the most valuable advantages is the...
3 Methods to Rebuild All Indexes for All Tables with T-SQL in SQL Server Database
There are several methods of how to rebuild all indexes of all tables in SQL Server, among them: Using SQL Server maintenance plans. Using...
TOP 5 MySQL Delete Syntax with Tips for T-SQL Developers
Our journey to MySQL started with CREATE TABLE followed by INSERT. Today, we are...