PolyBase, a data virtualization feature for SQL Server, allows users to seamlessly query data from various external sources directly using T-SQL (Transact-SQL) without the need for separate client ...

We have an ancient AS/400 730 system that still houses some old budget/financial data. We'd like to decommission this box, and migrate the data to a SQL server. The data won't be modified or ...

Moving SQL Server 2005 data will be the easy part compared to the app migrations.

Microsoft capped off a week of high-profile announcements related to SQL Server with an aggressive migration offer aimed at Oracle database customers. Here's the bottom line, from Microsoft's ...

Microsoft SQL Server version migrations are one of the more difficult activities for a DBA to execute, yet they are a very common change to the infrastructure. Databases eventually have to be migrated ...

Code Focused Deleting All Data from a SQL Server Database There are times as a developer that you will want to be able to delete all the data from a database as efficiently as possible. Unfortunately, ...

An interesting session I attended at the PASS Summit in Seattle was one concerning dealing with VLDBs in SQL Server. It was called “Big Data – Working with Terabytes in SQL Server” presented ...

Migration Advice Microsoft offered painful advice for organization eyeing the end of the SQL Server 2019 Big Data Clusters add-on and the PolyBase Scale-Out Groups feature.

This article provides an introduction to the most commonly used, nonstandard extensions in Oracle and how you can convert them for SQL Server compliance.