These days database administrators are tasked with working with a multitude of data types. And, as the Cloud has become more prevalent, the different types of database experience required continues to expand. Let us know the database services you are currently tasked with managing....More
Learn how you to automate, track, report and troubleshoot database performance problems and causes with “The Essential Guide to Database Monitoring.” Get advice on how to make gathering performance metrics and assessing database health less painful by establishing baselines and implementing automated monitoring....More
Transaction log backups are critical for point-in-time recovery. If you're in full recovery mode you also better be sure to be backing up those transaction logs because it's the only way to keep your log files healthy and lean....More
The 2015 IT/Dev Connections Data Platform and Business Intelligence sessions have been announced. We're taking a first peek at who will be providing knowledge and guidance at this year's event at the Aria Resort in Las Vegas....More
The quest for the Golden Record to achieve a single, accurate and complete version of a customer record is worth the pursuit to attain survivorship. Record matching and consolidation are only the beginning. Melissa Data takes a new approach. Learn how to apply intelligent rules based on reference data to make smarter and better decisions for data cleansing....More
Which database types do you currently administer in your organization?
These days database administrators are tasked with working with a multitude of data types. And, as the Cloud has become more prevalent, the different types of database experience required continues to expand. Let us know the database services you are currently tasked with managing.
As summer nears, the Power BI Preview is making bigger waves with every weekly release. Popular data sources and a plethora of Power BI Designer enhancements are being released at light speed pace. Check out the highlights on what has been released and what we might see next....More
Over the past few years we did not hear anything from Microsoft about SQL Server on-premises business intelligence enhancements. The extended cricket-chirping silence left us speculating about the future of Reporting Services, Analysis Services and other key technologies that are being used today to power critical decision making solutions. Good news, the waiting and wondering is over. Microsoft recently announced significant SQL Server on-premises upgrades for business intelligence in numerous presentations at both //build and Ignite conferences....More
In the last few posts (posts 19 – 24) I’ve covered some high-level concerns and reviewed some details about how to implement and manage database backups against AlwaysOn Availability Group databases. Most of the information I’ve provided was pretty basic or elementary – along with some additional guidelines for things to watch out for when managing backups. Which is to say that backups are never something you can simply take for granted and they’re never something you just take lightly....More