Languages & Coding

T-SQL Scripts to Monitor your Resource Pool Stats

Languages & Coding, T-SQL

Imagine you have a business-critical MS SQL Server serving requests for both OLTP and some batch...
Read More

Import JSON Data with SQL Developer Web into Autonomous Database

JSON, Languages & Coding

Twitter Activity provides loads of information for analysis. You can learn your target audience better, determine the most popular content,...
Read More

Entity Framework – Just a Few Clicks Away

Frameworks, Languages & Coding

Entity Framework is an open-source object-relational mapping (ORM) framework for .NET applications. It let the developers work with data on...
Read More

How to Check Status Of SQL Agent Jobs using PowerShell Tool

Languages & Coding, Microsoft Azure, PowerShell, SQL Server, Tools & technologies

From a certain point in my career, I started to play around with PowerShell. But I never imagined...
Read More

Oracle Data Integrator (ODI) Tutorial: How to Import Files into Oracle Autonomous Data Warehouse (ADW)

Languages & Coding, Programming

When you build an ETL / ELT enterprise system, you need the Data Integration tools, such as Microsoft SQL Server Integration Service,...
Read More

MySQL UPDATE: Top 5 Tips for T-SQL Developers

Database development, Languages & Coding, MySQL, Statements, T-SQL

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...
Read More

Creation of Pandas DataFrame in Python with Examples

Database administation, Frameworks, Languages & Coding, Work with data

Python is a general-purpose language that can work with various types of data structures and solve...
Read More

LINQ in C#: A tutorial with Query Examples in LINQ to Objects

Basics of C#, Languages & Coding

Less is more – this is definitely true when it comes to object collections and LINQ queries. One of the most valuable advantages is the...
Read More

3 Methods to Rebuild All Indexes for All Tables with T-SQL in SQL Server Database

Database development, Indexes, Languages & Coding, T-SQL, Tables

There are several methods of how to rebuild all indexes of all tables in SQL Server, among them: Using SQL Server maintenance plans. Using...
Read More

TOP 5 MySQL Delete Syntax with Tips for T-SQL Developers

Database development, Languages & Coding, MySQL, Statements, T-SQL

Our journey to MySQL started with CREATE TABLE followed by INSERT. Today, we are...
Read More