A common task that all database and system administrators face is patching systems. Patching your systems is very important -- first and foremost, security fixes are included in patches. Patches also ...

Redgate is releasing a major upgrade for its popular tool, SQL Prompt, helping developers increase the speed and quality of their SQL coding and take advantage of the most recent improvements in SQL ...

Testing and tuning SQL is an often-overlooked aspect of incorporating the database into your DevOps pipeline. It is important to be able to analyze and optimize SQL performance within your application ...

It's no secret that even though MySQL has been a Microsoft partner, it also is a Microsoft competitor. And ever since Oracle made overtures to buy Sun and (get MySQL in the process), Microsoft's been ...

There are plenty of ways to get the most out of SQL Server without just upgrading to the latest version. For database admins working with older (maybe much older) SQL Server systems, here are four ...

Comparing cursor vs. WHILE loop performance in SQL Server 2008 Your email has been sent Tim Chapman discusses your iteration choices in SQL Server 2008 and explains why determining which option ...