01 October 2018
01 October 2018

Adaptive Query Processing in SQL Server 2017

As new versions of SQL Server have been released, the Query Optimizer has undergone many improvements. Adaptive Query Processing, new in 2017, represents a new direction. This set of features provides some flexibility for varying join types, multi-statement table valued functions, and memory grants. In this article, Robert Sheldon explains the three features that make up Adaptive Query Processing … Read more
27 September 2018
27 September 2018

Extended Events Workbench

The Extended Events (or XEvents) feature has been part of SQL Server since 2008, but many database professionals struggle to get started using it. In this article, Phil Factor demonstrates several useful Extended Event sessions that measure just one thing in each. He then provides the code necessary to parse the resulting XML into something you can use.… Read more
23 September 2018
23 September 2018

Is Certification Worth It?

I was recently asked if I thought getting a Microsoft certification was valuable. I see quite a few benefits. Certifications might help your company become a Microsoft Gold Partner, and certification may be a selling point when assigning consultants to engagements. For me, the big benefits have been about learning new features and getting to … Read more
19 September 2018
19 September 2018

Fifty Different Ways to Enact Data Privacy Laws?

Now that the GDPR has gone into effect, many are wondering what will happen in the United States. California is the first state to enact similar legislation, called the California Consumer Privacy Act of 2018 (CCPA). In this article, William Brewer explains the history of the law, what it means for companies doing business with California residents, and how it compares to the GDPR.… Read more
17 September 2018
17 September 2018

Introducing the Unity Job System

Performance is important to video game players. If a game is slow, the player may experience unintended difficulties in timing, positioning, and much more. Unity added a job system with the 2018.1 update which allows multithreaded code which can improve performance. In this article, Lance Talbert walks you through using the new job system.… Read more
30 August 2018
30 August 2018

Security, Compliance, Data Ethics, and Breaking the “Not My Job” Mindset

Security, compliance, and data ethics are related concepts that everyone who works with software should know about, from the help desk to the C-level office… but almost everyone thinks that worrying about these things is someone else’s problem. As data breaches become increasingly common and data privacy regulations pass in more regions, there are increasing … Read more
20 August 2018
20 August 2018

Giving Back to the Tech Community

Most of us haven’t learned everything we know about technology from books or classes. Instead, when things go wrong, a quick search on Google or Bing typically brings up possible solutions from others who have experienced the same problem. I often wonder about that unfortunate guy who is the first to tackle a difficult issue. … Read more