I've bumped into a few folks over the past year or so who simply don't know that you can easily edit (contiguous/similar) details across multiple lines in SQL Server 2012—so I thought I'd share....More
SQL Server Agent is a handy job-scheduling program built for SQL Server; with it, users can easily create essential jobs and specify what steps will be taken, when a job will be executed, set alerts for specific events, and more....More
I know all the Microsoft buzz is about Power BI and Excel these days, but customers need real-world, professional business intelligence solutions that meet their complex real world requirements today....More
In small-to-midsized businesses, using OLAP cubes for business intelligence (BI) analyses is often not a viable approach. A better solution is to design and implement a self-service BI solution on the client side....More
SQL Server 2012 not only carries forward the ability to store user databases on SMB network shares, it adds several new high availability options when used with Windows Server 2012. Unlike early versions, it supports SMB file shares to store SQL Server databases.
Download this whitepaper to learn about the SMB benefits as well as creating development and test environments while minimizing downtime....More
Some differences between the COALESCE and ISNULL functions make COALESCE preferable, whereas others make ISNULL preferable. Learn the differences, to make an educated decision about which to use....More
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