SQL Data Warehouse reference architectures
With so many product options to choose from for building a big data solution in the cloud, such as SQL...
2017-05-17
794 reads
With so many product options to choose from for building a big data solution in the cloud, such as SQL...
2017-05-17
794 reads
Another Microsoft event and another bunch of exciting announcements. At the Microsoft Build event this week, the major announcements in...
2017-05-12
651 reads
Announced today are some really cool new Power BI features:
Power BI Premium
Previously available were two tiers, Power BI Free and...
2017-05-03
2,073 reads
Yesterday was the Microsoft Data Amp event where a bunch of very exciting announcements were made:
SQL Server vNext CTP 2.0...
2017-04-20
740 reads
There are a number of options for using Azure for free. This is very useful for those of you who...
2017-04-11
587 reads
The new buzzword in the industry is “Artificial Intelligence” (AI). But exactly what is AI and how does it compare...
2017-04-06
1,131 reads
There are various Microsoft tools that you can use to help you migrate your database (updated 8/9/17):
Data Migration Assistant (DMA)...
2017-03-29
1,113 reads
Azure Data Lake Analytics (ADLA) is a distributed analytics service built on Apache YARN that allows developers to be productive immediately...
2017-03-23
486 reads
I previously talked about PolyBase and its enhancements (see PASS Summit Announcements: PolyBase enhancements). There is some confusion on PolyBase use...
2017-03-15
608 reads
Azure SQL Database (SQL DB) has increased its max database size from 1TB to 4TB at no additional cost.
Customers using...
2017-03-10
297 reads
By Steve Jones
It’s a day off for Redgate today. This is our annual wellbeing day, where...
Next Monday, March 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...
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