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

Different flavors of LINQ queries

Languages & Coding

The current article continues the series about LINQ. The previous part introduced the LINQ...
Read More

A PowerShell Tool to Get the Status of SQL Agent Jobs

Languages & Coding, PowerShell, 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

MySQL UPDATE: Top 5 Tips for T-SQL Developers

Database development, Languages & Coding, 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

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

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

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

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

How to Easily Get Data from Web Source Using Power BI Rest API Calls

Business intelligence, JSON, Languages & Coding, Power BI

Microsoft Power BI is a data visualization and analytics tool which lets you create powerful visualizations with a graphical user...
Read More

MySQL Insert Command vs T-SQL Query Syntax with Examples

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

Developers are lifelong students. Gaining new knowledge as fast as we can is always our gig. If...
Read More
Close