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
677 reads
James Serra's Blog
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
702 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,939 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,244 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,182 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
597 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,361 reads
Azure SQL Data Warehouse pricing
The pricing for Azure SQL Data Warehouse (SQL DW) consists of a compute charge and a storage charge. For compute, it is...
2016-06-23
912 reads
SQL Server 2016 is here!
Today is the day: SQL Server 2016 is available for download! You can download all the versions (enterprise, standard, web,...
2016-06-01
974 reads
Azure Storage pricing
Azure storage is a great, inexpensive solution for storing your data in the cloud. There are many types of Azure...
2016-05-25
956 reads
Blogs
T-SQL Tuesday #201 Round-Up: Temp Tables, Friend or Foe?
By ReviewMyDB
The T-SQL Tuesday #201 round-up: nine bloggers on whether temp tables are a friend...
Monday Monitor Tips: Configuring Access to the MCP Server
By Steve Jones
I have been experimenting with MCP servers in a few ways, including the Redgate...
The GO Barrier: Why SSMS Multi-Server Query Waits for the Slowest Connection
By Zikato
I deployed a schema change to 30 servers using multi-server query and deploy-at-low-priority. Small...
Forums
Admin Rights for Everyone
Comments posted to this topic are about the item Admin Rights for Everyone
Kerberos Authentication for Aurora PostgreSQL: Mapping AD Groups to Database Roles
Comments posted to this topic are about the item Kerberos Authentication for Aurora PostgreSQL:...
RegEx Functions I
Comments posted to this topic are about the item RegEx Functions I
Question of the Day
RegEx Functions I
Which of these RegEx functions need compatibility level 170 in SQL Server 2025?
See possible answers