Distributed Writes
In SQL Server, scaling out reads (i.e. using Active secondary replicas via AlwaysOn Availability Groups) is a lot easier than scaling out...
2017-09-21
736 reads
James Serra's Blog
Azure Archive Blob Storage
Last week Microsoft released a public preview of a new service called Azure Archive Blob Storage, offering customers a lower-cost...
2017-08-31
1,032 reads
Data Virtualization vs Data Warehouse
Data virtualization goes by a lot of different names: logical data warehouse, data federation, virtual database, and decentralized data warehouse....
2017-08-24
909 reads
Microsoft Big Data Certification Exams
I previously blogged about Microsoft certification changes, and since then there have been some new Microsoft Big Data certifications exams released:
Already...
2017-08-08
682 reads
Azure Analysis Services web designer
Microsoft has released a preview of the Azure Analysis Services web designer. This is a browser-based experience that will allow...
2017-08-02
687 reads
Azure SQL Data Sync 2.0
Azure SQL Data Sync has been ignored for quite some time, but has finally gotten an update (it’s in public...
2017-07-20
591 reads
4TB disk sizes for Azure IaaS VMs available
Microsoft has introduced two new disk sizes for Azure IaaS VMs in P40 (2TB) and P50 (4TB) for both managed...
2017-07-07
1,037 reads
Data lake details
I have blogged before about data lakes (see What is a data lake? and Why use a data lake?), and wanted to provide...
2017-06-29
4,578 reads
Azure DevTest Labs
I have been working at Microsoft now for 3 years and 4 months (side note: it’s by far the best...
2017-06-21
841 reads
Data Science Virtual Machine
The Data Science Virtual Machine (DSVM) is a customized VM image on Microsoft’s Azure cloud built specifically for doing data...
2017-06-23 (first published: 2017-06-14)
2,452 reads
Blogs
Learn about Modern Microsoft Apps in San Diego
By Steve Jones
I wrote about learning today for the editorial: I Can’t Make You Learn. I...
How To Deploy Fabric SQL and Azure SQL Databases with Azure DevOps
By ReviewMyDB
Fabric has CI/CD built in, but if you've tried to use it for database...
A New Word: Attriage
By Steve Jones
attriage – n. the state of having lost all control over how you feel...
Forums
SSRS Reminded Me of the Time Microsoft Retired TMG
Comments posted to this topic are about the item SSRS Reminded Me of the...
Getting results from a Procedure to join to a query
I have a need to execute a stored procedure and return the results to...
Upgrade 2016 Standard to 2022 Express
Title pretty much says it all - can this be done? I've tried several...
Question of the Day
BIT_COUNT II
In SQL Server 2025, I have a table (dbo.UserPermission) that contains this data:
UserID UserPermissions 15 23 37 4 NULLWhat is returned when I run this code:
select bit_count(UserPermissions) as PermissionCount from dbo.UserPermission where UserID = 4;See possible answers