My latest presentations
I frequently present at user groups, and always try to create a brand new presentation to keep things interesting. We all know technology changes so quickly so there is...
2019-03-11
14 reads
James Serra's Blog
Azure Data Lake Store Gen2 is GA
Azure Data Lake Store (ADLS) Gen2 was made generally available on February 7th. In short, ADLS Gen2 is the best of...
2019-02-19
805 reads
Azure Data Lake Store Gen2 is GA
Azure Data Lake Store (ADLS) Gen2 was made generally available on February 7th. In short, ADLS Gen2 is the best of the previous version of ADLS (now called ADLS Gen1)...
2019-02-19
106 reads
Storage options for SQL Server database files in Azure
If you are using SQL Server in an Azure VM (IaaS) you have a number of options of where to...
2019-01-29
1,071 reads
Storage options for SQL Server database files in Azure
If you are using SQL Server in an Azure VM (IaaS) you have a number of options of where to store the database files (.mdf, .ldf, and .ndf). Most...
2019-01-29
414 reads
What product to use to transform my data?
If you are building a big data solution in the cloud, you will likely be landing most of the source...
2019-01-08
400 reads
What product to use to transform my data?
If you are building a big data solution in the cloud, you will likely be landing most of the source data into a data lake. And much of this...
2019-01-08
9 reads
Azure Data Factory Data Flow
Azure Data Factory v2 (ADF) has a new feature in public preview called Data Flow. I have usually described ADF...
2018-12-17
535 reads
Azure Data Factory Data Flow
Azure Data Factory v2 (ADF) has a new feature in public preview called Data Flow. I have usually described ADF as an orchestration tool instead of an Extract-Transform-Load (ETL)...
2018-12-17
76 reads
Should I load structured data into my data lake?
With data lakes becoming very popular, a common question I have been hearing often from customers is, “Should I load...
2018-11-27
479 reads
Blogs
Monday Monitor Tips: AI Query Analysis
By Steve Jones
AI is everywhere. It’s in the news, it’s being added to every product, management...
AI: Blog a Day – Day 8: RAG – Retrieval Augmented Generation
By Vinay Thakur
RAG — Retrieval Augmented Generation. we have covered so far — embeddings, vectors, vector...
AI: Blog a Day – Day 7: Vector and Vector Databases
By Vinay Thakur
Continuing from Day 6 we learned Embeddings, Semantic Search and Checks, on Day 7...
Forums
I'm thinking about submitting some articles
I've written some documentation on using different Markdown types of files on GitHub. It's...
Not Just an Upgrade
Comments posted to this topic are about the item Not Just an Upgrade
Restoring On Top I
Comments posted to this topic are about the item Restoring On Top I
Question of the Day
Restoring On Top I
I am doing development work on a database and want to keep a backup so I can reset my database. I make some changes and want to restore over top of my changes. When I run this code, what happens?
USE Master BACKUP DATABASE DNRTest TO DISK = 'dnrtest.bak' GO USE DNRTest GO CREATE TABLE MyTest(myid INT) GO USE master RESTORE DATABASE DNRTest FROM DISK = 'dnrtest.bak' WITH REPLACESee possible answers