SQL Server Migration Strategies and Planning
- February 12, 2019
Cloud data warehouses see serious data transformation work moving to the cloud. Talend's first integration with Stitch, which it recently bought, reflects the trend.
- November 30, 2018
Microsoft is updating SQL Server and Azure SQL Database more quickly than it did in the past -- and keeping up with the new releases can be a tough task for DBAs.
- November 29, 2018
Microsoft released a second preview of SQL Server 2019 and said users can now run applications in either on-premises SQL Server systems or its Azure SQL Database cloud service.
- November 08, 2018
Microsoft is adding functionality to Azure SQL Database to enable users to migrate more SQL Server applications to the cloud platform and run bigger databases on it.
- October 31, 2018
This year's PASS Summit comes as SQL Server 2019 looms and the cloud becomes a bigger factor. PASS board member Tim Ford talks about key trends ahead of it.
- September 25, 2018
A SQL Server 2019 preview brings Hadoop and Spark into the fold, positioning the database as an all-purpose data portal. Azure Cosmos DB also gets an update.
- August 29, 2018
Talend released software that does bulk data uploads to Microsoft's Azure SQL Data Warehouse. The goal is to streamline data integration and support real-time analytics.
- May 16, 2018
The ability to provision Azure Cosmos DB throughput at the database level could come with pricing sticker shock for some users of Microsoft's multimodel database.
- March 21, 2018
Count ObjectRocket among those pursuing Azure MongoDB deployments. This open source NoSQL database continues to find traction on the web and in the cloud.
- September 26, 2017
Microsoft SQL Server 2017 becomes available in October. In addition to a version that runs on Linux, new features include support for Python-based analytics.
- July 27, 2017
SQL Server for Linux has gained added features on its way to general availability as part of the almost-ready SQL Server 2017. Meanwhile, its Windows-based brother is upping its high availability quotient.
- April 21, 2017
Python is no longer a database outsider at Microsoft. The programming language is riding alongside R for analytics uses as SQL Server 2017 moves to its second preview release.
- March 22, 2017
So far, data has been left out of the DevOps discussion. But DevOps for databases could grow if tools like Redgate's bundle embedded in Visual Studio 2017 carry through on their promises.
- May 25, 2016
Microsoft wants to make Oracle customers an offer they can't refuse: free SQL Server licensing if they switch over. The question is whether or not the deal is as good as it looks.
- April 28, 2016
Two database industry experts discuss infrastructure and analytics trends to consider for database upgrades following the end of SQL Server 2005 extended support.
- April 28, 2016
Two database experts explain how to take advantage of the opportunity created by SQL Server 2005 end of life and how to build a better database.
- March 04, 2016
SQL Server 2005 end of life is coming next month. Experts explain which version of SQL Server to upgrade to, and where in the migration process organizations need to be.
- May 12, 2015
Microsoft CEO Satya Nadella announced the SQL Server 2016 preview for this summer. Its new features model the ethos of "mobile first, cloud first."
- March 24, 2014
Consultant Denny Cherry talks changes, misconceptions and what people really want from SQL Server 2014, which is generally available on April 1.
- October 17, 2013
This is the last Community Technology Preview (CTP) for SQL Server until it becomes generally available in the first half of next year.
- October 04, 2013
Microsoft has upped the ante, releasing new SQL Server versions at a quicker pace. How will you adapt?
- June 21, 2013
In this issue of SQL in Five, Mark Kromer lists usual features of the upcoming SQL Server 2014, but also highlights a different one: Data Explorer.
- June 12, 2013
Ovum analyst Tony Baer says that most database platforms are moving toward in-memory features, and SQL Server 2014 is no different.
- June 03, 2013
Microsoft announced that the next version of its database, SQL Server 2014, will have in-memory features and be generally available in late 2013.
- June 12, 2012
With Microsoft broadcasting the importance of its cloud computing platform, some SQL Server pros want to use the cloud database service as a backup to their on-premises SQL Server databases.
- April 18, 2012
One of the strongest versions Microsoft has put out in years, SQL Server 2012 first needs to accomplish a monumental task -- overcome database inertia, industry watchers say.
- April 11, 2012
SQL Server 2012 is here, and the Apache Hadoop integration is making the biggest wave, according to some users.
- March 14, 2012
With SQL Server 2012 released in a “virtual launch” this month, Microsoft data platform specialist Mark Kromer tells us what his favorite features of the new release are.
- March 12, 2012
Are you considering moving your database to Azure? Concerned about complexity? Read this tip from expert Denny Cherry. Migrating to SQL Azure might be the easiest move ever.
- February 14, 2012
Microsoft database platform specialist Mark Kromer talks in this Q&A about Microsoft SQL Server 2012 “big data” capabilities, as well as what SQL Server has in store for open source and cloud computing this year.
- February 13, 2012
With SQL Server 2012 coming out and the growing influence of the SQL Azure cloud and “big data,” the SQL Server landscape could see some major changes in the coming months.
- January 18, 2012
With tool sets still evolving, developers face stiff challenges in integrating data in hybrid SQL Server-SQL Azure environments.
- October 13, 2011
Microsoft said it will release SQL Server 2012, formerly Denali, next year and detailed its Hadoop-based strategy for handling the explosion of big data at the PASS 2011 conference.
- June 07, 2011
It was cloud, cloud, cloud at Microsoft TechEd 2011. Microsoft’s Mark Kromer discusses the SQL Azure, what’s new with the cloud database offering and what’s to come.
- August 04, 2010
Microsoft’s Mark Kromer offers his thoughts on the current state of cloud-based BI and what technologies like SQL Azure and PowerPivot can do for organizations.
- January 04, 2010
Customers can now upgrade their CTP accounts to new paid subscriptions of Microsoft's cloud-based database service.
- October 23, 2009
Cost and scalability benefits might make data warehousing seem like a perfect fit for cloud computing, but storage limitations with Azure could slow deployments.
- October 19, 2009
DBAs and developers have concerns about cloud computing , but enhancements to Microsoft's SQL Azure Database could ease those worries.
- July 14, 2006
The best practices for improved database management include a combination of the right people, processes and products.
- December 12, 2005
As databases become more alike and all of them have the capability to pull data from multiple sources, dare to be different! Moving everything to a single platform can make things less complicated.
- April 08, 2005
Learn how to deploy hotfixes in this SQL Server patch management guide.
- April 08, 2005
This guide will walk you through SQL Server patch deployment and the various patching options available to you.
- March 21, 2005
So you've decided to secure your SQL Server infrastructure and you don't know where to start. This first guide in a two-part series on SQL Server patch deployment will help you track down those pesky servers before getting them properly patched.
- March 21, 2005
Learn how to prepare a set of IP address ranges to scan for SQL Server instances in this SQL Server patch management guide.