Database Management & Programming News, Articles & Tutorials for Database Administrators
SQL Server in Azure Virtual Machines - Performance Optimizations 12/05/2016
When deploying SQL Server in an Azure virtual machine, you can take advantage of several Azure Infrastructure-as-a-Service (IaaS) features that enhance performance of the SQL Server database engine. We will explore a couple of these enhancements in this article. In particular, we will focus on increased I/O throughput facilitated by the Solid State Drive (SSD) storage available on most Azure virtual machines (VMs).
Identifying Last Night’s SQL Agent Job Failures 12/01/2016
Finding the nightly job failures is just one of a DBA's morning rituals. It is fairly easy to scan all the email with a number of creative search criteria, but what if you would like a more automated approach? Read on to learn how to find and report all job failures using a script.
Removing Email from msdb Database 12/01/2016
Is your msdb database growing bigger every day? If so you might want to consider purging some of the history records from the msdb database. If you are sending email using database mail and you are not periodically purging email information, then you might find out this is one of the reasons your msdb database is growing bigger.
Getting Started with R Services in SQL Server 2016 – Part 1 11/28/2016
SQL Server 2016 brings native support to advanced analytics in the database itself, using R Services. Learn what R is, what the on-premise advanced analytics options from Microsoft are, and how to get started using R Services with SQL Server 2016.
Storing Numbers As Strings In An Oracle Database 11/21/2016
It’s interesting to note that sometimes VARCHAR2 fields are used to store numbers. Read on to see why this isn’t the best practice and how to get around the sorting issue if you can’t change the table.
Basic DB2 System Tuning Strategies 11/17/2016
While the performance of a mission-critical application sometimes takes center stage, IT staff are always aware that the performance of the overall system affects all applications. Database management systems, operating system software, physical data storage and retrieval, and backup and recovery operations all take part in providing a solid infrastructure for applications. For many customer facing applications, such as on-line transaction processing, the database management system is the key component.
Microsoft's SQL Server Database Is Heading to Linux 03/08/2016
Next year, Microsoft plans to release a version of its hybrid-cloud-friendly database software for the open-source operating system.
More Database News...