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
946 reads
James Serra's Blog
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
896 reads
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...
2016-05-26 (first published: 2016-05-18)
3,146 reads
Azure Speed Testing
Have you ever wondered what Azure region would be the fastest to host your applications when those applications are accessed from your...
2016-05-11
1,510 reads
New Azure storage account type
In Azure, there previously has been only one kind of storage account, which is now called a “General Purpose” storage...
2016-05-04
1,068 reads
SQL Server 2016 available June 1st!
Woo hoo! Microsoft has announced that SQL Server 2016 will be generally available on June 1st. On that date all four...
2016-05-02
641 reads
Big Data architectures
Over the last few years I have been involved in reviewing the architectures of various companies that are building or have...
2016-05-12 (first published: 2016-04-29)
3,106 reads
Azure SQL Database pricing
Pricing Azure SQL database is difficult because various database service tier options such as database transaction units (DTU’s), max database size,...
2016-04-22
2,042 reads
Analytics Platform System (APS) AU5 released
The Analytics Platform System (APS), which is a renaming of the Parallel Data Warehouse (PDW), has just released an appliance update (AU5),...
2016-04-14
865 reads
Scaling Azure VM’s
There are so many benefits to the cloud, but one of the major features is the ease of use in...
2016-04-05
648 reads
Blogs
Finding fields used in a Power BI report in PBIR format with Semantic Link Labs
Have you ever wondered where a certain field is used in a report? Or...
Adding Test data to msdb.sysjobhistory
By Steve Jones
One of our internal people was looking to test some process in (I assume)...
Microsoft Ignite Announcements Nov 2024
By James Serra
Announced at Microsoft Ignite last week were some new product features related to the...
Forums
Import data from json file with special characters
I am using the following script to import data from a json file. This...
% processor Time in Activity monitor is greyed out
When I connect to my SQL Server using SQL Server Management Studio (SSMS) from...
Tools for MySQL memory estimations and optimization?
Hi all! I’ve been using MySQLCalculator.com for memory calculations, but I’m looking for alternatives...
Question of the Day
The Hash Join II
Which of these inputs is the smaller input to a hash join?
See possible answers