Blair Greenwood is an associate editor for SQL Server Pro, where she extensively covers database administration, development, and business intelligence industry trends and news. Follow her on Twitter at @blair_greenwood and Google+.
Ahead of the Microsoft TechEd 2014 conference, Melissa Data announced that they will be showing off new matching and de-duplication functionality in the company's MatchUp Component for SQL Server Integration Services (SSIS).
Tim Ford is involved in several different facets of the SQL Server space. Not only is he heavily involved in our own IT/Dev Connections conference, but he's also the person behind the annual SQL Cruise technical training event.
Microsoft is cleaning house by replacing its current cloud-database service tiers with new ones. According to the company, it is retiring its SQL Database Web and Business service tiers on April 24, 2015.
During Microsoft's Q3 earnings call yesterday, the company generated a net income of $5.66 billion on revenues of $20.40 billion. Additionally, the Devices and Consumer sector within Microsoft grew 12 percent to $8.30 billion, and commercial revenue grew 7 percent to $12.23 billion.
An option when creating new AlwaysOn Availability Groups is to specify Backup Preferences.
It’s also something you can easily configure once the Availability Group has been set up as well – by simply right-clicking on the Availability Group and selecting Properties – then navigating into the Backup Preferences tab. ...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
On SQL Servers where Availability Groups (or Mirroring) isn’t in play, I typically recommend keeping a combination of on-box backups along with copying said backups off-box as well. Obviously, keeping databases AND backups on the SAME server is the metaphorical equivalent of putting all of your eggs in one basket – and therefore something you should avoid like the plague....More