Cortana Intelligence Solutions
Cortana Intelligence Solutions is a new tool just released in public preview that enables users to rapidly discover, easily provision, quickly experiment...
2016-09-29
901 reads
James Serra's Blog
Making sense of Microsoft technology
In my role as a Data Platform Solution Architect (DPSA) at Microsoft, part of my responsibility is to keep up with...
2016-09-21
692 reads
The art of possible with the cloud
One thing I try to do in my role with Microsoft is to get clients to think of possible use...
2016-09-08
508 reads
SQL Server 2016 real-time operational analytics
SQL Server 2016 introduces a very cool new feature called real-time operational analytics, which is the ability to run both...
2016-08-24
648 reads
Azure SQL Database new performance level
A new performance level for Azure SQL Database was recently announced, called P15. This new offering is more than two...
2016-08-17
685 reads
Azure SQL Database vs SQL Data Warehouse
I am sometimes asked to compare Azure SQL Database (SQL DB) to Azure SQL Data Warehouse (SQL DW). The most important...
2016-08-17 (first published: 2016-08-10)
1,929 reads
What is the Lambda Architecture?
Lambda architecture is a data-processing architecture designed to handle massive quantities of data (i.e. “Big Data”) by using both batch-processing and...
2016-08-08 (first published: 2016-08-05)
3,215 reads
Multi-tenant databases in the cloud
For companies that sell an on-prem software solution and are looking to move that solution to the cloud, a challenge...
2016-07-20
1,158 reads
Azure SQL Data Warehouse is now GA
The Azure SQL Data Warehouse (SQL DW), that I blogged about here, is now generally available. Here is the official...
2016-07-13
579 reads
Virtualization does not equal a private cloud
I see a lot of confusion when it comes to creating a private cloud. Many seem to think that by...
2016-07-07
1,348 reads
Blogs
Using Flyway Prepare for State-Based Deployments
By Steve Jones
One of the neat enhancements made to Flyway was the addition of state-based workflows...
How I Migrated to Azure PostgreSQL Flex from Single Server
I did a couple of posts previously on dumping/restoring Azure PostgreSQL databases and also...
Have a Plan for Your Personal Downtime
By Brian Kelley
Most of us know that spending a lot of time on social media and...
Forums
WHERE condition using ='value' returns different results that using IN('value')
Have an interesting scenario - user found a discrepancy with rows returned when running...
Complex Query (Multiple Tables & Joins) - Need to Restrict to Max Date
I am using the query listed below. USE GAGETRAK_26237 SELECT G.Gage_ID 'ID', G.Model_No 'Model',...
Unknown Token Received From SQL Server
I have an issue when a stored procedure is executed from the SQL Server...