Сreating a Virtual Machine With Oracle VM Virtual Box
Microsoft announced cross-platform support of SQL Server – the SQL Server 2017 and SQL Server...
Your Ultimate Guide to SQL Joins: OUTER JOIN – Part 2
Outer join is at the center stage today. And this is part 2 of your ultimate guide to SQL joins. If you missed part 1, here’s the...
How CTE Can Aid In Writing Complex, Powerful Queries: A Performance Perspective
We often see poorly written complex SQL queries running against a table or tables in databases. Those queries make the time of execution...
Synthetic Data Generation
Introduction Sooner or later, any information system gets a database, often – more than one. With...
Mastering the Use of Stoplists With SQL Server Full-Text Search (FTS)
Creating and managing stoplists serves as one of the main components responsible for improving the Full-Text Search performance alongside...
Your Ultimate Guide to SQL Join: INNER JOIN – Part 1
Inner join, outer join, cross join? What gives? It’s a valid question. I once saw a Visual Basic code with T-SQL codes embedded in it....
Configure SQL Server Log Shipping
This article explains the step by step deployment process of the SQL Server Log shipping. It is the...
How To Create SQL Trace To Capture SQL Server Events
Facing an SQL Server performance issue, you need to identify the source of that performance problem fast. Therefore, a tool for tracking...
Git Branching Naming Convention: Best Practices
Git offers flexible branching strategies, but what does it mean? In simple words, a branching strategy is a set of rules, a convention that...
3 Nasty I/O Statistics That Lag SQL Query Performance
“But it ran fine on our development server!” How many times did I hear it when SQL query...
