Fast-Track Data Warehouse for Windows Azure
Microsoft has introduced an image into the Windows Azure Virtual Machine Gallery that is pre-optimized for a Fast Track Data...
2013-11-05
1,422 reads
Microsoft has introduced an image into the Windows Azure Virtual Machine Gallery that is pre-optimized for a Fast Track Data...
2013-11-05
1,422 reads
Windows Azure SQL Reporting was the new name of the reporting services component (which was formerly known as SQL Azure...
2013-11-01
6,474 reads
From Microsoft, SSDT is now available for SQL Server 2014:
We’d like to announce the availability of SSDT that supports SQL...
2013-10-31
1,582 reads
Not much news came out of the PASS Summit 2013 from last week, but boy did I have a blast! I...
2013-10-29
1,128 reads
Microsoft has released SQL Server 2014 CTP2 (download):
What’s new in SQL Server 2014 CTP2?
New Mission Critical Capabilities and Enhancements
Enhanced In-Memory...
2013-10-24
1,823 reads
As a consultant I am often starting from the ground floor on a new data warehouse/business intelligence project, and usually...
2013-10-22
760 reads
Thanks to everyone who attended my session “Building an Effective Data Warehouse Architecture” at the PASS Summit 2013. The abstract is below. It...
2013-10-21
766 reads
Thanks to everyone who attended my session “Transitioning to a BI role” at the PASS SQL Saturday Charlotte. The abstract is below. Another...
2013-10-21
695 reads
The PASS Summit 2013 is almost here! Check out all the great sessions and speakers. I feel very fortunate to be able to speak...
2013-10-10
630 reads
I have talked about the Business Intelligence Maturity Model (see Business Intelligence Maturity Assessment), but I wanted to dig further into...
2013-10-08
2,207 reads
By Vinay Thakur
I wrote about TempDB Internals and understand that Tempdb plays very important role on...
By Vinay Thakur
continuing from Day 1 where we covered the history of AI and GPT family,...
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