Articles filed in category 'Database'

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

Mike looks at the technology that allows multiple teams to connect and scale their data despite disparate data storage methods.

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.

With this release, EF Core has really matured. Julie takes you on a tour and points out some of the highlights of this labor-simplifying tool.

The latest release of Entity Framework gets it geared up for some big future changes. Julie shows you that the changes are nothing to sneeze at.

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.

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.

If you’ve got multiple data stores, you have to keep them synced or you’ve got trouble on your hands. Joydip makes it look easy using Sync Framework.

All eyes were on Microsoft when the latest version of SQL Server came out a couple of months ago. If you want to know what’s so great about it, you need to read Kevin’s handy summary.

Whether you’re new to T-SQL or not, you’re sure to find something interesting among Kevin’s tips for using it, no matter which version of SQL Server you’re using.

Kevin uses his experience on both sides of the interview table to help you wow at your next interview. Not only that, but you’ll probably pick up a few pointers, too!

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.