Archives: March 2016
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 with slide decks and videos in some cases. Here are… Read more
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 a SMP data warehouse.
To help… Read more
I’m sure you are aware of Microsoft Azure, but are you aware there is special version of Azure for U.S. governments?
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 of the product (via Linux VMs).… Read more
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 just use the three-part name syntax DatabaseName.SchemaName.TableName. Instead, you… Read more