Scenario: A user complains that a batch job that is critical for the month end business processing is taking more time than expected. As a DBA you quickly check and identify the sql statement that is running, compare the current execution plan with the previous plans and come to the conclusion that it has picked up a wrong plan. Instead of a Hash Join, it is doing a Nested Loop or did not pick the parallel threads and instead does a single threaded full table scan.
ref="magnificPopup" href="http://d1kgm347lql2s5.cloudfront.net/blog/wp-content/uploads/social-media-icons.png"> class="alignnone size-medium wp-image-79597" src="http://d1kgm347lql2s5.cloudfront.net/blog/wp-content/uploads/social-media-icons-300x174.png" alt="social-media-icons" width="300" height="174" />
This Log Buffer Edition collects and then showers around some of the information-rich blog posts from Oracle, SQL Server and MySQL.
style="font-weight: 400;">We’re pumped to be sponsoring our first href="https://reinvent.awsevents.com/" target="_blank"> style="font-weight: 400;">AWS re:Invent style="font-weight: 400;"> show on October 6-9 at The Venetian in Las Vegas!
style="font-weight: 400;">As an AWS Advanced Consulting Partner with AWS accredited experts on our team, we’ve helped our clients design, architect, build, migrate, and manage their workloads and applications on AWS.
style="font-weight: 400;">My job is almost completely reliant upon my ability to perform work in lab of virtual machines. Almost every action plan I write is tested locally. When I need to troubleshoot an issue for a client one of the most common first steps I’ll perform is attempting to recreate the issue in a virtual environment so I can work on it there without the risk of impacting client data.
Hello and welcome to our second episode of SQL On The Edge! On this episode we’re going to focus on a new feature of SQL Server 2016 called Temporal Tables.
What’s a Temporal table?
Temporal tables allow us to go back in time and see what the data looked like at some point in the past and are also referred to as “system-versioned” tables. This has several different uses, some of which are:
/> b) Quickly fix mistakes
/> c) Data trending
This blog post is a quick introduction to Containers in the Windows world, and a walk-through on installing SQL Server in a Windows Container.
This Log Buffer Edition dives deep into the ocean of blogosphere and surfaces with some cool blog posts from Oracle, SQL Server and MySQL.
ref="magnificPopup" href="http://d1kgm347lql2s5.cloudfront.net/blog/wp-content/uploads/goldfish.jpg"> class="alignnone size-medium wp-image-79085" src="http://d1kgm347lql2s5.cloudfront.net/blog/wp-content/uploads/goldfish-300x278.jpg" alt="goldfish" width="300" height="278" />