Monthly Archives: March 2016

My latest presentations

I frequently present at user groups, and always try to create a brand new presentation to keep things interesting.  We all know technology changes so quickly there is no shortage of topics!  There is a list of all my presentations … Continue reading

Posted in Presentation, SQLServerPedia Syndication | Comments Off on My latest presentations

Data loading into Azure SQL Data Warehouse

Azure SQL Data Warehouse (SQL DW) is a new platform-as-a service (PaaS) that distributes workloads across multiple compute resources, called massively parallel processing (MPP).  Loading data into a MPP data warehouse requires a different approach, or mindset, than traditional methods of loading data into … Continue reading

Posted in Azure SQL DW, Data warehouse, SQLServerPedia Syndication | 1 Comment

Microsoft Azure Government

I’m sure you are aware of Microsoft Azure, but are you aware there is special version of Azure for U.S. governments? Microsoft Azure Government is a cloud computing service for federal, state, local and tribal U.S. governments.  It was generally available … Continue reading

Posted in Azure, SQLServerPedia Syndication | Comments Off on Microsoft Azure Government

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

Cross-database queries in Azure SQL Database

A limitation with Azure SQL database has been its inability to do cross-database SQL queries.  This has changed with the introduction of elastic database queries, now in preview.  However, it’s not as easy as on-prem SQL Server, where you can … Continue reading

Posted in Azure SQL Database, SQLServerPedia Syndication | 10 Comments