Here at Pragmatic Works, we've been looking forward to the release of SQL Server 2016. To show you all the new features we're excited about, we've dedicated an entire month of free training to SQL Server 2016. These session are being hosted by industry experts and Microsoft MVPs. They've spent time working with previews of SQL Server 2016 and are excited to show you what they've discovered.
Category: Sql Server23 Results
The new SQL Server 2016 release is just around the corner (June 1st) and we’re really looking forward to it at Pragmatic Works! It’s also a busy time for the Software team, as we have to make sure all of our products play well with the new SQL Server 2016 features. We have just released the 2016.2 build of all of our products, which is compatible with SQL Server 2016 RC3 and will also work with the 2016 RTM release when it is available.
Thank you to everyone who attended my webinar last week! In that session, I went through all the steps to install SQL Server to be able to use Hadoop, but I thought it might also be a good idea to include them here so you don’t have to watch the video.
Hello Dear Reader! Recently we hosted a webinar for Pragmatic Works, Mission Critical Applications SQL Server and Superdome X. The brilliant engineers over at HP invited Pragmatic Works to be the premier partner working with them to execute proof of concept (POC) engagements for clients. This has allowed us to take a close look at the hardware and see where it can really help people.
There are many benefits of partitioning large tables. You can speed up loading and archiving of data, you can perform maintenance operations on individual partitions instead of the whole table, and you may be able to improve query performance. However, implementing table partitioning is not a trivial task and you need a good understanding of how it works to implement and use it correctly.Table Partitioning is an Enterprise Edition feature only.
I can’t connect my package…never fear Brad Schacht to the rescue!
So you want to connect your SSIS package to Excel, SQL Server, Oracle and some Flat Files but you just can’t seem to get it to work. No worries! Our superhero consultant, Brad Schacht, will help break things down and show you how to make these connections one by one. Brad will show some of his super powers in ways that will assist you with using SSIS to do a simple data dump, how to keep tables in sync, and how to do incremental loads.
Which comes first the Chicken or the Egg?
It doesn’t really matter which comes first in this instance, it’s more about the egg. In this particular webinar Kathy Kellenberger is going to tell us how to cook our egg, in a matter of speaking. Let’s just assume that the webinar, “Get Started with T-SQL SELECT Part 1” teaches about how to take care of the chicken to get her to lay an egg.
Need help with this topic? Ask the author below.