Microsoft Purview, formally called Azure Purview (see Azure Purview is generally available) has recently released a number of new cool features. I wanted to call out a few of...
2023-02-22 (first published: 2023-02-09)
433 reads
A question I get asked frequently from customers when discussing Data lake architecture is “Should I use one data lake for all my data, or multiple lakes?”. Ideally, you...
2023-02-01 (first published: 2023-01-23)
463 reads
Happy new year to everyone! As I enter my 9th year at Microsoft, I have switched roles, and am now an Industry Advisor in Federal Civilian, helping our Federal...
2023-01-20 (first published: 2023-01-12)
302 reads
Over the years I have presented a ton (see the list), and some of those presentations were recorded. I had put some of them on my YouTube channel, but...
2022-12-15
11 reads
The big announcement at the PASS Data Community Summit 2022 was that SQL Server 2022 is now generally available. See the official announcement. My top 10 list of new...
2022-11-29
52 reads
I have attended and presented at a ton of conferences over the years (see the entire list at Presentations | James Serra’s Blog). If you are looking to learn...
2022-11-10
9 reads
Announced at Microsoft Ignite were some new product features related to data platform and AI. Below are the ones I found most interesting: Azure Cosmos DB adds distributed PostgreSQL...
2022-10-18
17 reads
I have had a lot of conversations with customers to help them understand how to design a data lake. I touched on this in my blog Data lake details,...
2022-09-30
32 reads
I had previously blogged about Azure Synapse Analytics database templates, and wanted to follow-up with some notes and tips on that feature as I have been involved on a...
2022-09-13
22 reads
(Side note: There is a “subscribe” button on the right side of my home page if you wish to receive my blogs updates via email as soon as they...
2022-09-12 (first published: 2022-08-29)
405 reads
By Chris Yates
For decades, enterprises have approached data management with the same mindset as someone stuffing...
Truncate Table Pitfalls Truncating a table can be gloriously fast—and spectacularly dangerous when used carelessly....
You can find all the session materials for the presentation “Indexing for Dummies” that...
Comments posted to this topic are about the item Technological Dinosaurs or Social Dinosaurs?
Comments posted to this topic are about the item DBCC CHECKIDENT
Comments posted to this topic are about the item Distributed Availability Group Health: T-SQL...
What is returned as a result set when I run this command without a new seed value?
See possible answers