My latest presentations
I frequently present at user groups, and always try to create a brand new presentation to keep things interesting. We...
2019-03-11
362 reads
I frequently present at user groups, and always try to create a brand new presentation to keep things interesting. We...
2019-03-11
362 reads
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 (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
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
413 reads
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
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
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 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
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
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
By James Serra
I’m honored to be hosting T-SQL Tuesday — edition #192. For those who may...
By Vinay Thakur
Continuing from Day 2 , we learned introduction on Generative AI and Agentic AI,...
Quite the title, so let me set the stage first. You have an Azure...
Comments posted to this topic are about the item A Quick Restore
Comments posted to this topic are about the item Guarding Against SQL Injection at...
I have a quick question on Ola Hallengren Index Optimize Maintenance . Do we...
While doing some testing of an application, I wanted to reset my environment after doing some testing with this code:
USE DNRTest BACKUP DATABASE DNRTest TO DISK = 'dnrtest.bak' GO /* Bunch of stuff tested here */RESTORE DATABASE DNRTest FROM DISK = 'dnrtest.bak' WITH REPLACEWhat happens if this runs, assuming the "bunch of stuff" isn't anything affecting the instance. See possible answers