As IT leaders, you have most likely experienced the huge costs associated with a “Data Warehouse” implementation. The level of complexities can grow quickly and leave you asking yourself many difficult questions such as:
So many questions with high associated costs can negatively affect your projects and budgets. This leads us to the next question.
What if you could affordably store your data offsite and still connect to the database? Would that even be possible?
Great news! You absolutely can, and it’s very affordable!
Microsoft SQL 2016 has a new feature called SQL Server Stretch Database, or STRETCH, which allows us to extend our “cold” data to Azure. With STRETCH, we can still query the data through our regular OLTP (Online Transaction Processing) world, but can also store and access mass amounts of historical data on our OLTP server. I know I slipped Azure in there but isn’t that where we need to be looking?
Here is a fantastic opportunity to get started. Currently, it will cost less than $1000/month and you’re still able to keep your archived data tied to your OLTP server.
STRETCH is database specific and has some restrictions, no computed columns, defaults, check constraints or foreign keys. This all makes sense for cold data tables, but why would you want “historical” data to have a computed column or a default column? This is data that is moved once a month or once a quarter, mostly for compliance, but can certainly have the reporting server access it for those occasional historical reports.
Contact Interlink today to learn more about SQL Server Stretch Database or to have one of our SQL 2016 Certified engineers build the right solution for you.
Ken has worked with Fortune 500 companies and small businesses for the last 30+ years. Working both as a consultant and a Microsoft instructor for the past 21 years, Ken is well versed in many aspects of technologies specializing with Microsoft. He currently has 38 Microsoft certifications. Ken has worked on many technologies in the Microsoft arena, but his area of focus has been on SQL Server. He has been certified since SQL 6.0 (1997) and recently passed the BETA SQL 2016 Admin exam.
All content provided on this blog is for informational purposes only. The owner of this blog makes no representations or warranties regarding the information from our partners or other external sources.