After having used PowerShell to manage SQL Server since 2006, when PowerShell was first introduced, I'm pretty comfortable with it. Everyone has to start somewhere, though, so I'd like to share some basics with you....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
As far as I'm concerned we'll likely always have SQL Injection around to haunt us. Even though this attack vector has been well-publicized and well-documented for well over a decade (and then some), failure to account for it continues to pop all the time—even in catastrophic places....More