TechEd is now Microsoft Ignite
In case you were wondering what happened to the TechEd conferences, Microsoft is now bringing together the best of previously...
2015-05-04
556 reads
In case you were wondering what happened to the TechEd conferences, Microsoft is now bringing together the best of previously...
2015-05-04
556 reads
A NoSQL database provides a mechanism for storage and retrieval of data that is modeled in means other than the...
2015-04-15
1,760 reads
A “data lake” is a storage repository, usually in Hadoop, that holds a vast amount of raw data in its...
2015-04-08
2,645 reads
Microsoft Azure provides you two options when hosting your SQL Server-based data warehouse: Microsoft Azure SQL Database and SQL Server...
2015-03-30 (first published: 2015-03-19)
7,701 reads
I see a lot of confusion on what exactly is an Operational Data Store (ODS). While it can mean different...
2015-03-12 (first published: 2015-02-26)
9,563 reads
Thanks to everyone who attended my session “Building a Big Data Solution” (Building an Effective Data Warehouse Architecture with Hadoop,...
2015-02-24
978 reads
In an effort to understand Power BI and all the products it encompasses, I have made this slide deck to...
2015-02-18
1,110 reads
Ever wonder about Microsoft’s product roadmap? With Microsoft rapidly releases products and services, they realized the need to provide better...
2015-02-12 (first published: 2015-02-04)
8,351 reads
Advanced Analytics, or Business Analytics, refers to future-oriented analysis that can be used to help drive changes and improvements in...
2015-02-11
1,567 reads
Long has the question been asked “Which Microsoft tool do I use for dashboards?”. SSRS, Excel, PowerView, Report Builder and PerformancePoint...
2015-01-14
2,278 reads
Next Monday, Marchg 9, 2026, my one-day live online training SQL Server 2025 Unleashed:...
By HeyMo0sh
As someone who’s worked with data for over 20 years and with many cloud...
By HeyMo0sh
2025 belongs to the AI startups. If you peek into the tech headlines, you’ll...
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