Languages & Coding

An Overview of Analytic Functions in PostgreSQL

Languages & Coding, PostgreSQL

Analytic functions are special kinds of pre-built functions that come with PostgreSQL by default....
Read More

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 processing tasks, as data gets pulled by...
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....
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 that it would become such an essential...
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...
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 data-related problems with the help of...
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:...
Read More