<img height="1" width="1" style="display:none" src="https://www.facebook.com/tr?id=931099456970389&amp;ev=PageView&amp;noscript=1">

Category: Sql Server

23 Results

All About SQL Server 2016!

Posted May 31, 2016 by Liz Hamilton

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.

Exciting Features of SQL Server 2016

Posted May 12, 2016 by John Welch

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.

Migrating from Oracle to SQL Server 2016

Posted Apr 18, 2016 by Sean Werick

There is been plenty of activity and excitement recently concerning Microsoft’s aggressive move to obtain a large portion of Oracle’s marketshare.  There are always pros and cons to any situation, so I’m going to illustrate both, although as a Microsoft partner, we see more pros than cons.

SQL Server 2016 Polybase Setup

Posted Mar 31, 2016 by Ginger Grant

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.

Top 5 Reasons to Consider HP’s Superdome X

Posted Feb 17, 2016 by Bradley Ball

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.

Walk Around and Be Nosy

Posted Jan 28, 2016 by Phillip Labry

Many years ago when I was a team lead in a Finance IT shop I got into the habit of walking around to check on my clients. I popped into Joe's office and he was doing something odd and here's how our conversation went:

Table Partitioning in SQL Server – Partition Switching

Posted Apr 29, 2015 by Cathrine Wilhelmsen

Inserts, updates and deletes on large tables can be very slow and expensive, cause locking and blocking, and even fill up the transaction log. One of the main benefits of table partitioning is that you can speed up loading and archiving of data by using partition switching.

Table Partitioning in SQL Server – The Basics

Posted Apr 21, 2015 by Cathrine Wilhelmsen

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.

Flashback Friday-SSIS ETL for Beginners

Posted Jan 16, 2015 by Tammye Michau


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. 

Flashback Friday-The T-SQL Golden Egg

Posted Jan 02, 2015 by Tammye Michau


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.  

Blog Comments

Need help with this topic? Ask the author below.


Subscribe to Blog Updates