Service Broker Sample – Asynchronous Triggers
Introduction
Service Broker is a cool feature new since SQL Server 2005. Yes, SQL 2014 is just around the corner so...
2013-12-04
2,482 reads
Introduction
Service Broker is a cool feature new since SQL Server 2005. Yes, SQL 2014 is just around the corner so...
2013-12-04
2,482 reads
Introduction
Service Broker is a cool feature new since SQL Server 2005. Yes, SQL 2014 is just around the corner so...
2013-12-04
3,459 reads
Today I’ll show you a special script which will let you “take a snapshot” of your table’s data, and apply...
2012-12-23
1,562 reads
For your convenience, below is a download link to get the presentation and relevant materials for the SSIS Tips & Tricks...
2012-10-23
857 reads
Before I became a SQL Server DBA, I used to be a web developer in ASP3. Since then, I sometimes...
2012-08-04
624 reads
SQL Injection is a widely known issue with databases that work as back-ends for websites and applications. In the most...
2012-08-01
647 reads
In my previous blog post: Suggestion: “USE” Keyword with Linked Servers, I talked about the suggestion I’ve posted on Microsoft...
2012-05-20
523 reads
Using special functions for querying and executing commands at linked servers is not very convenient, and sometimes even very problematic.
For...
2012-05-16
550 reads
Introduction
Service Broker is a cool new feature since SQL Server 2005. Yes, SQL 2012 just came out so it’s hardly...
2012-05-07
511 reads
Introduction
Service Broker is a cool new feature since SQL Server 2005. Yes, SQL 2012 just came out so it’s hardly...
2012-05-07
1,659 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