I need a secure transfer of data between SQL Servers. What are my options?
You’ve got a few options, none of which are all that easy to setup. 1. Export the data, then encrypt the file, then transfer the file, then decrypt the file, then import the file. 2. Setup IPSec between the two SQL Servers and then transfer the data as normal. 3. Setup a Secure FTP Server […]
SQL Server Experts: MS SQL beats the “ACID” test for Database Technology in Features, Ease & Cost
I was asked to be interviewed for an article on Microsoft SQL Server by OdenJobs.com. They have just posted the interview of myself and Christian Lefter, Andew Fyer, Namwar Rizvi, Brent Ozar, Brian Kelly, Chris Shaw, and Pinal Dave. Part 1: MS SQL beats the “ACID” test for Database Technology in Features, Ease & Cost […]
SQL Server Experts: MS SQL beats the “ACID” test for Database Technology in Features, Ease & Cost
I was asked to be interviewed for an article on Microsoft SQL Server by OdenJobs.com. They have just posted the interview of myself and Christian Lefter, Andew Fyer, Namwar Rizvi, Brent Ozar, Brian Kelly, Chris Shaw, and Pinal Dave. Part 1: MS SQL beats the “ACID” test for Database Technology in Features, Ease & Cost […]
You can’t deploy a SQL 2008 SSRS Report to a SQL 2005 SSRS Server
SQL 2008 and SQL 2005 use different RDL namespaces and so they pretty much aren’t compatible. You can edit SQL 2005 Reports using the SQL 2008 editor, but new reports won’t be able to be deployed to the SQL 2005 report server. With enough major editing of the SQL 2008 report you can convert it […]