Despite the plentiful information in Books Online and on the official “SQL Server 2000 Security” document Microsoft offers online, setting up a truly secure SQL Server remains a difficult task. In ...

Pairing your on-prem SQL Server with a cloud-based instance for high availability has its challenges, but they can be overcome. Here’s how. The geographic distribution of cloud data centers makes it ...

Microsoft is warning users of a zero-day vulnerability discovered in SQL Server, and that exploits of the flaw have already been published. The software giant yesterday issued a security advisory ...

As I understand it if you are using mirroring on SQL server and have failover setup you can adjust the connection strings of your applications that use it so they ...

main office/domain with a local SQL server on the domain, users connect using ODBC connection w/ windows auth 2nd company/domain at a remote location, people vpn (windows pptp) to access file shares ...