Archive for category SQL Server

SQL Server 2016 is coming: What to Expect?

SQL 2016

Hello from Solartech on this wonderful sunny day in May (or depending on when and where you are reading this)!  It’s getting closer to that time of the year when vacations start and we get to have fun in the sun! But who cares about fun when you have SQL 2016 to prepare for? Ha! Just kidding… Kind of.

Ok, really SQL Server 2016 is coming soon so let’s talk about what new features we can expect.

Let’s take a quick recap of SQL Server 2012 and 2014 (recent versions that have come out).

SQL Server 2012’s features included a set of options to improve database availability, contained databases which simplified the moving of databases between instances, programmability enhancements, metadata discovery, improved role management, etc.

SQL Server 2014 on the other hand, provided a new in-memory capability for tables that can fit entirely in memory (something called Hekaton?) Apparently this was a great feature?! And, this version of SQL also provided new hybrid disaster recovery and backup solutions with Windows Azure (training we also offer, of course!), which allowed customers to use existing skills with the on-premises version of SQL server to take advantage of Microsoft’s global datacenters – and you know a whole bunch of other IT stuff that makes my head spin – (I did not understand any of that, but if you did my friend, you are in the right field of work!)

Now, introducing SQL Server 2016! So what are the updates you can look forward to here!? Well say hello to Always Encrypted – a new feature which protects your data at rest and in motion! (I did not the laws of physics applied to data?) – and Stretch Database which lets you dynamically stretch your warm and cold transactional data to Microsoft Azure (once again, is there something that data does that we don’t know about?, I feel like I’m Russell Crowe in A Beautiful Mind and I should be seeing numbers and data figures floating around me!)

But if you want to know more about this version of SQL, click here to read all about this new upgrade courtesy of the team at Microsoft!

*Also just a selling point here: we will offer this training as well once it’s released, because you know, we’re cool and hip like that*

Ah, now that it’s Friday, and I’ve wracked my brain trying to comprehend all this information – once again courtesy of Microsoft articles – that you IT people do day-to-day, I’m going to sit back and relax and daydream about the Bahamas.

Cheers from Solartech and Enjoy SQL Server 2012, um 14, er… I mean 16!

, , , , ,

Leave a comment

New Microsoft SQL Server Course! 55144 SQL Server 2014 Performance Tuning and Optimization

55144 SQL Server 2014 Performance Tuning and Optimization

Join us September 14th for 55144 SQL Server Performance Tuning & Optimization training!

This five day training course by Solartech is designed to give the right amount of Internals knowledge, and wealth of practical tuning and optimization techniques, that you can put into production. The course offers a comprehensive coverage of SQL Server architecture, indexing and statistics strategies, optimize transaction log operations, tempdb and data file configuration, transactions and isolation levels, and locking and blocking. The course also teaches how to create baselines and benchmark SQL Server performance, how to analyze workload and figure out where performance problems are, and how to fix them. Coverage of in-memory tables and stored procedures along with an introduction to this exciting new technology is included.

To view the full course outline please click here.

Attend in-person or online and Microsoft Software Assurance training Vouchers are accepted!

, , , ,

Leave a comment

What is SQL Server 2008?

SQL Server 2008 is Microsoft’s latest version of SQL Server.

SQL server originated as Sybase SQL server. It, according to Microsoft’s Senior VP of server applications, Paul Flessner, “can be a data storage backend for different varieties of data: XML, email, time/calendar, file, document, spatial, etc as well as perform search, query, analysis, sharing, and synchronization across all data types.”

SQL Server 2008 strives to have zero downtime through being a self-sufficient server. It does so through the development of SQL Server Always On technologies. This technology makes data management self-tuning, self organizing and self maintaining.

If your organization is looking to upgrade your server , SQL Server 2008 is a great option and according to Microsoft it provides a trusted, productive, and intelligent data platform that enables you to run your most demanding mission-critical applications, reduce time and cost of development and management of applications, and deliver actionable insight to your entire organization.“

For more information regarding SQL Server 2008 please visit:

Microsoft SQL Server 2008 Page

Or if you’re interested in taking classes on SQL Server 2008, you can find a list of classes here or you can email me, Michael Hacker at mhacker@solartechnj.com  for additional information.

, , , , , , , , ,

Leave a comment