Tag: SQL

Craig Mullins' blog post maps out the process for developers who need to retrieve a limited number of qualifying rows from a table.

Read More

Case histories of migrations from on-premises SQL to cloud SQL using Amazon Web Services (AWS).

Read More

This blog post discusses costs vs. advantages of converting an existing application from IMS DB to DB2.

Read More

SQL Server replication will not stand up to some kinds of DDL. This blog post will take you through the process to automate replication tear-downs and rebuilds.

Read More

Sometimes an application can require different, perhaps even somewhat "odd" data sorting. Often you can conjure up an answer by properly understanding the problem and applying some creative SQL.

Read More

This blog post gives you all the details in order to determine the just-right size to help stand up an Azure Virtual Machine to host your SQL server.

Read More

What is the challenge and ongoing affect of the continual redefinition of a DBAs job roles and responsibilities. Find out in Craig Mullin's blog post.

Read More

Have you heard about the new release of MCSA: SQL 2016 certification? Would you consider upgrading?

Read More

TempDB is a critical system database that has been available with SQL Server for ages. Here are some enhancements in conjunctions with SQL Server 2016.

Read More

Do you know what you're supposed to do before upgrading to Oracle Database 12c? We have the checklist.

Read More