Select Page

Blog

Welcome to Datavail’s Blog, where you can read the latest insights, tips and opinions of our experts on all things data and technology.

Category: MS SQL
Browse All Categories

Querying Database File Properties

You may need to find out the filegroups that are in a database, the logical file name, initial size, autogrowth/maxsize, path, and file name so that you can determine if files in a filegroup exist on separate hard drives with free disk space and if the files are not limited in size. In addition, you may wish to increase the file autogrowth size if they are set at rather small increments or set to increase by a percentage. You can right-click on the database and select “Properties” in the pop-up menu,then click on the “Files” page.

JP Chen | July 28, 2015

Soft Skills Aid in Application Development Projects

Database administrators serve an essential role in helping to develop applications and are central to the process because they are most familiar with the data on which the applications are based. But they must also use their soft skills to solve tough issues in the development process. Soft skills like being a team player, accepting of feedback and flexibility are key to a successful DBA working on developing applications. These skills help ensure a successful project.

Bill Mitalski | July 23, 2015

What To Look For In Database Managed Services

Data plays an integral role in business and the explosion in the amount of data poses a real challenge to database managers. Often, managers find that the hands-on management of all of this data overwhelming. So what options are there? Cloud-based database management provides organizations with database expertise when they are needed, where they are needed, and at the scale needed. There are several things to look for in a managed service provider.

Robin Caputo | July 20, 2015

There’s a Better Way to Use Your DBAs

When an organization doesn’t have 24×7 support, the senior database administrator is typically forced to do low-level work and is placed on-call for emergencies. She becomes bogged down in “administrivia” and is unable to operate effectively.

Robin Caputo | July 15, 2015

Querying the Drive Space Utilization

How can you query the disk drives space utilization to show all the drives, total capacity, free space, and percentage free for the drives that contain the SQL Server databases data and log files? In addition, how can you be alerted when any one of the disk drives containing the database data or log files is running low on disk space?

JP Chen | July 9, 2015

Tips for Upgrading From SQL 2008 to 2012 or 2014 Part 2

Previously, I mentioned in part 1 that a line has been drawn bisecting the upgrade path leading from SQL 2008 versions to SQL 2012+. As of SQL 2012, Microsoft has implemented a new licensing scheme and SQL instances are now licensed by core rather that by CPU.

Andy McDermid | July 8, 2015

Using Microsoft Excel Power Query to Shape Databases

With the release of Excel 2013, Microsoft introduced a set of powerful new features called Power Functions. These include Power Pivot, Power View, Power Maps and Power BI. These Power features take data shaping to a whole new level.

Eric Russo | July 7, 2015

Data Shaping with Microsoft Excel Power Query

Anyone who works with data probably has some comfort working with Microsoft Excel. The software’s tabular presentation of data, combined with its ability to easily export, import, and sort, gives it the core capabilities of data analysis.

Eric Russo | June 23, 2015

3 Slick Scripts for Database Mail Alerts and Reports

Database Mail enables you to send e-mail messages from the SQL Server Database Engine. Database Mail uses the standard Simple Mail Transfer Protocol (SMTP) to send mail.

JP Chen | June 16, 2015