Category Archives: SQL Server

Migrate from on-prem SQL server to Azure VM IaaS

Hopefully you went through my presentations Should I move my database to the cloud?, Introducing Azure SQL Database and Implement SQL Server on an Azure VM and are convinced to move your databases to the cloud.  If you are going to migrate to Azure … Continue reading

Posted in Azure, SQL Server, SQLServerPedia Syndication | 1 Comment

SQL Server on Linux!

Looks outside: pigs are flying! In an announcement yesterday, SQL Server will be made available on Linux.  The private preview of SQL Server on Linux is available now, and Microsoft is targeting availability in mid-2017.  Microsoft will offer both on-premises and cloud versions … Continue reading

Posted in SQL Server, SQLServerPedia Syndication | 1 Comment

Migrate from on-prem SQL server to Azure SQL Database

This blog describes the various approaches you can use to migrate an on-premises SQL Server database to Azure SQL Database. In this migration process you migrate both your schema and your data from the SQL Server database in your current … Continue reading

Posted in Azure SQL Database, SQL Server, SQLServerPedia Syndication | 1 Comment

SQL Server 2016 public preview arriving this summer

SQL Server 2016 was recently announced.  Top new features include: Always Encrypted protects data at rest and in motion.  With Always Encrypted, SQL Server can perform operations on encrypted data and best of all, the encryption key resides with the … Continue reading

Posted in SQL Server, SQL Server 2016, SQLServerPedia Syndication | 1 Comment

24 Hours of PASS videos online

All the videos for the sessions at 24 Hours of PASS (Spring 2014) are available for free.  Check the session schedule for a complete list.  Also, many of the PASS virtual chapters have recordings of their meetings online.  Enjoy!

Posted in PASS, SQL Server, SQLServerPedia Syndication, Videos | Leave a comment

24 Hours of PASS: Business Analytics Edition videos online

On February 5, 2014 business intelligence experts took to the virtual stage for the 24 Hours of PASS: Business Analytics Edition to deliver a series of one-hour webcasts, digging deep into the world of business analytics.  All session recordings and slide presentations … Continue reading

Posted in PASS, SQL Server, SQLServerPedia Syndication, Videos | Leave a comment

TechEd Europe 2013 videos online

Microsoft has posted ALL the session videos for TechEd Europe 2013 and they are available for free!  Some great videos on the latest products and versions.  Check them out here.  There are four videos on SQL Server 2014: Microsoft SQL Server … Continue reading

Posted in SQL Server, SQL Server 2014, SQLServerPedia Syndication, Videos | Leave a comment

TechEd North America 2013 videos online

Microsoft has posted ALL the session videos for TechEd North America 2013 and they are available for free!  What a great way to learn all about SQL Server 2012 and Business Intelligence (some sessions have hands-on labs).  Check them out here. … Continue reading

Posted in SQL Server, SQLServerPedia Syndication, Videos | Leave a comment

Visual Studio 2012 now supports BI!

My most popular blog has been Visual Studio 2012 does not support BI.  In short, this means VS 2012 does not support SSAS, SSIS, or SSRS.  Well, not anymore!  Just released is Microsoft SQL Server Data Tools – Business Intelligence for … Continue reading

Posted in Business Intelligence, SQL Server, SQLServerPedia Syndication, SSAS, SSDT/Juneau, SSIS, SSRS, Visual Studio 2012 | 9 Comments

24 Hours of PASS: Business Analytics Edition videos online

On January 30, BA and BI experts took to the virtual stage for the 24 Hours of PASS: Business Analytics Edition to deliver a series of one-hour webcasts, digging deep into the world of business analytics over five tracks.  All session recordings … Continue reading

Posted in PASS, SQL Server, SQLServerPedia Syndication, Videos | Leave a comment