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
Microsoft Excel 2013 is a big step forward with respect to business intelligence. The native integration of PowerPivot and Power View provides a whole new level of scalability and functionality....More
In managing a database or sometimes numerous databases, we often get caught up in the day-to-day maintenance and lose sight of the other principles we know are critical to ensuring optimal performance. Here’s a quick refresher....More