Backup SQL Server to Amazon S3 with CloudBerry Backup
In this sponsored article from Cloudberry, learn how you can backup your SQL Server data to the Amazon EC3 cloud.
2010-05-13
2,112 reads
sponsored article
Monitoring Your Servers : Data Collection vs. Performance Advisor
An article sponsored by SQL Sentry that compares how the Data Collector in SQL Server 2008 and SQL Sentry's Performance Advisor can be used with your SQL Server. Written by MVP Aaron Bertrand.
2009-03-19
6,583 reads
An Extra Defense For SQL Injection Attacks
TDSe-cure is a proxy service to SQL Server to block SQL injection attacks.
2009-01-07
2,996 reads
Invoking Stored Procedures through a One Line Native .NET Method Call
Calling stored procedures from your application should be easy. Mark Frishman of ActiveDB talks about what he's done to help you build applications quicker.
2008-11-12
4,341 reads
RE: Error 927 Database test cannot be opened
You can not force a restore over a restoring database. You must use sp_dbremove or sp_detach_db.
2003-07-11
RE: Data Referential Integrity - when do you use it?
Referential Integrity maintained by the Server is much more performant than RI maintained by triggers, stored procedures or an application.
2003-06-13
1 reads
RE: Clustered SQL Server backup & local drives
Brian, Not to labour the point too much but if the intention of the question was to elicit an answer to 'why can't Enterprise Manager see the local drives' then I reckon the answer was phrased wrong SQL Server CAN see local drives in a cluster EM CANNOT see local drives in a cluster
2003-06-12
1 reads
RE: SQL SERVER STALLED
I would consider maybe looking at converting the logic in the VB app to a stored procedure so that it runs inside SQL Server and can be a job. If you need help post the code here.
2003-06-05
1 reads
Blogs
Set a Runtime Variable in an Azure DevOps Pipeline
By Steve Jones
Note: I DO NOT recommend this. Any changes to a pipeline should be in...
A New Word: Symptomania
By Steve Jones
symptomania – n. the fantasy that there’s some elaborate diagnosis out there that neatly...
Query Store Keeps Switching Itself Off, Getting it Moving Again
I recently received a complaint that Query Store for a particular database was turned...
Forums
7 sept, scheduled book
Comments posted to this topic are about the item 7 sept, scheduled book
7 sept, schedlued article
Comments posted to this topic are about the item 7 sept, schedlued article
6 sept, published book
Comments posted to this topic are about the item 6 sept, published book
Question of the Day
Azure Data Lake Storage Gen 2
Azure Data Lake Storage Gen 2 is built on ...?
See possible answers