Articles filed in category 'SQL Server 2014'

Kevin learns the hard way how to estimate a process’ duration and he uses a clever bit of code to figure it out.

If your call to services times out after four minutes, you can have a problem if the process needed to retrieve the data or a fire-and-forget operation takes longer than that. What if the user makes a request and then wanders away from the computer? Mike solves it for you, with WebJobs in Azure Skyline.

Kevin shows us how to solve tangles in SQL Server, and in this article, he looks at some questions that have come up since his last article on ETL practices in Data Warehousing.

If you’ve got large datasets, you don’t want to slow the system down every time you save them to your SQL Server database. Rod shows you an uncomplicated way to keep your records zipping along.

The point of showing data in graphical form is to make things clear, right? Keven shows you how the best of intentions can go wrong and how to repair the damage.

Kevin looks at his favorite reporting tool (SSRS) and shows you how to maximize your users’ experience.

You already know that SQL Server’s Reporting Services tools are useful. Kevin shows you some nifty work-arounds and extra-credit tricks that will make your reports sing.

Kevin leaves his SQL Server-focused Baker’s Dozen behind and launches into a new series looking at the various stages of data warehousing. His first installment includes a look at reporting and storage layers, handy tips, and dealing with the business side of development.

In this first installment of his ETL articles, Kevin shows you what to do—and even what not to do—when designing your Data Warehouse.