Welcome to Datavail’s Blog, where you can read the latest insights, tips and opinions of our experts on all things data and technology.
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.
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.
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.
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.
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?
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.
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.
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.
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.