Articles tagged

04 December 2019
04 December 2019

Distractions at Work

Many jobs in technology, especially those that involve writing code, take concentration and focus. It’s often called being “in the zone.” For me, it feels like I’m inside a bubble where time goes at a different pace than the rest of the world. In fact, the rest of the world seems to disappear when I’m … Read more
03 December 2019
03 December 2019

Do You Have REFERENCES?

The logic for referential integrity can be implemented in application code, but to make sure that it is enforced, include foreign key constraints in the database design instead. In this article, Joe Celko talks about the history of references in SQL and the options available today. … Read more
05 March 2019
05 March 2019

Resumable Online Index Create and Rebuild Operations

Index maintenance can be a real headache for database administrators as tables grow larger and maintenance windows shrink. In this article, Greg Larsen demonstrates resumable index operations available with SQL Server 2017 and 2019. This feature helps DBAs work around those small maintenance windows by allowing certain index operations to be paused and restarted again later.… Read more
26 February 2019
26 February 2019

What are Inline Indexes?

New releases of SQL Server arrive at a quick pace, and it's difficult to keep up with the many features introduced in each version. In this article, Phil Factor reviews a feature you may have missed, inline indexes. He covers the syntax and the many ways they can be used and then performs some performance tests to see if they can make a difference with table variables.… Read more
20 February 2019
20 February 2019

The BI Journey: The Expert’s Advice – Part 1

10
Creating a quick dashboard with a few reports may be the beginning of a BI solution, but unless time is spent on the underlying model, it won't be adaptable enough to grow. In this article by Gogula Aryalingam, you'll see how the advice of a mentor helped a newbie understand how to create a flexible model that will lead to a valuable BI solution. … Read more