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...
Different flavors of LINQ queries
The current article continues the series about LINQ. The previous part introduced the LINQ...
A PowerShell Tool to Get the Status of SQL Agent Jobs
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...
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...
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:...
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 proceeding to the MySQL DELETE statement....
How to Easily Get Data from Web Source Using Power BI Rest API Calls
Microsoft Power BI is a data visualization and analytics tool which lets you create powerful visualizations with a graphical user...
MySQL Insert Command vs T-SQL Query Syntax with Examples
Developers are lifelong students. Gaining new knowledge as fast as we can is always our gig. If...