Microsoft SharePoint Online
Microsoft SharePoint Online is a cloud-based service that is part of the recently released Microsoft Office 365. For those of us...
2011-08-17
927 reads
Microsoft SharePoint Online is a cloud-based service that is part of the recently released Microsoft Office 365. For those of us...
2011-08-17
927 reads
If you are using a SSIS lookup transformation editor and the reference dataset is large (millions of rows) and you...
2011-08-15
12,287 reads
There is a very interesting new Microsoft program that started back in January, called the SSAS Maestro Program. It is a five-day,...
2011-08-12
1,117 reads
Released today, the SQL Server code name ‘Denali’ Community Technical Preview 3 (CTP3) Product Guide download contains the latest datasheets, white...
2011-08-11
1,259 reads
Replaying multiple threads of a captured trace in SQL Profiler is difficult, and you are limited to replaying the workload from...
2011-08-10
1,588 reads
For those of you who use MDX, I’m sure you share my opinion that MDX is a lot harder to...
2011-08-08
784 reads
I take it for granted that everyone knows all about Microsoft certifications and Microsoft MVP’s. But a few years ago,...
2011-08-05
1,643 reads
As a consultant or contractor, many times the client we are at does not provide us with a laptop, so we must...
2011-08-03
1,378 reads
Project Apollo is a new feature in CTP3 of SQL Server Denali that enables a new columnstore index that offers...
2011-08-01
1,667 reads
Here is a tip that could make you much more productive: At home, I have a desktop computer with dual-monitors...
2011-07-29
2,290 reads
By Vinay Thakur
it has been a year since i have not written much on the blog...
By Steve Jones
on tenderhooks – adj. feeling the primal satisfaction of being needed by someone, which...
By DataOnWheels
I have been active in the data community throughout my career. I have met...
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