Viewing 15 posts - 646 through 660 (of 1,518 total)
Roger L Reid (4/22/2009)
__________________________________________________________________________________
SQL Server 2016 Columnstore Index Enhancements - System Views for Disk-Based Tables[/url]
Persisting SQL Server Index-Usage Statistics with MERGE[/url]
Turbocharge Your Database Maintenance With Service Broker: Part 2[/url]
April 22, 2009 at 12:17 pm
Thank you for the help, I will try your script.
Much appreciated!
__________________________________________________________________________________
SQL Server 2016 Columnstore Index Enhancements - System Views for Disk-Based Tables[/url]
Persisting SQL Server Index-Usage Statistics with MERGE[/url]
Turbocharge Your Database Maintenance With Service Broker: Part 2[/url]
April 21, 2009 at 1:50 pm
Drew Salem (4/21/2009)
That completely passed me. I was asking Steve Jones of SQLServerCentral.com what I should call the artcles and he suggested using the acronym. I hope people haven't thought...
__________________________________________________________________________________
SQL Server 2016 Columnstore Index Enhancements - System Views for Disk-Based Tables[/url]
Persisting SQL Server Index-Usage Statistics with MERGE[/url]
Turbocharge Your Database Maintenance With Service Broker: Part 2[/url]
April 21, 2009 at 7:56 am
Drew,
Thanks for the article. Looking forward to the upcoming installments.
When I first saw the title of your article, I actually thought it was about using Microsoft System Center Operations Manager...
__________________________________________________________________________________
SQL Server 2016 Columnstore Index Enhancements - System Views for Disk-Based Tables[/url]
Persisting SQL Server Index-Usage Statistics with MERGE[/url]
Turbocharge Your Database Maintenance With Service Broker: Part 2[/url]
April 20, 2009 at 6:42 pm
So I have backed up my certificate (certificate protecting the private key of a symmetric key through which I en(de)crypt data):
use encryption_test;
BACKUP CERTIFICATE ct_data_access
TO FILE = 'C:\_MARIOS\BACKUPS\encryption_test_db_ct_data_access'
WITH PRIVATE KEY
(
FILE =...
__________________________________________________________________________________
SQL Server 2016 Columnstore Index Enhancements - System Views for Disk-Based Tables[/url]
Persisting SQL Server Index-Usage Statistics with MERGE[/url]
Turbocharge Your Database Maintenance With Service Broker: Part 2[/url]
April 14, 2009 at 3:53 pm
Mike Good (4/13/2009)
One question I have right away, though: was...
__________________________________________________________________________________
SQL Server 2016 Columnstore Index Enhancements - System Views for Disk-Based Tables[/url]
Persisting SQL Server Index-Usage Statistics with MERGE[/url]
Turbocharge Your Database Maintenance With Service Broker: Part 2[/url]
April 13, 2009 at 10:04 am
Mike, thanks again for your insightful article, and thanks all for this discussion. I have learned a lot.
Lately, I have been able to research the subject of database encryption extensively...
__________________________________________________________________________________
SQL Server 2016 Columnstore Index Enhancements - System Views for Disk-Based Tables[/url]
Persisting SQL Server Index-Usage Statistics with MERGE[/url]
Turbocharge Your Database Maintenance With Service Broker: Part 2[/url]
April 12, 2009 at 6:22 am
I found the answer! Instead of converting the decrypted result to NVARCHAR, I should be converting it to VARCHAR; since I enter it as VARCHAR into the table in the...
__________________________________________________________________________________
SQL Server 2016 Columnstore Index Enhancements - System Views for Disk-Based Tables[/url]
Persisting SQL Server Index-Usage Statistics with MERGE[/url]
Turbocharge Your Database Maintenance With Service Broker: Part 2[/url]
April 10, 2009 at 6:57 pm
What do the other 2 letters stand for in C-I-A?
__________________________________________________________________________________
SQL Server 2016 Columnstore Index Enhancements - System Views for Disk-Based Tables[/url]
Persisting SQL Server Index-Usage Statistics with MERGE[/url]
Turbocharge Your Database Maintenance With Service Broker: Part 2[/url]
April 9, 2009 at 12:18 pm
K. Brian Kelley (4/9/2009)
Marios Philippopoulos (4/9/2009)
Thank you, but it seems to me that being able to export them makes certificates less secure than asymmetric keys. Isn't that the case?
Yes and...
__________________________________________________________________________________
SQL Server 2016 Columnstore Index Enhancements - System Views for Disk-Based Tables[/url]
Persisting SQL Server Index-Usage Statistics with MERGE[/url]
Turbocharge Your Database Maintenance With Service Broker: Part 2[/url]
April 9, 2009 at 12:16 pm
K. Brian Kelley (4/9/2009)
Marios Philippopoulos (4/9/2009)
In practice, Certificate objects are always recommended over AsymmetricKey objects
Can...
__________________________________________________________________________________
SQL Server 2016 Columnstore Index Enhancements - System Views for Disk-Based Tables[/url]
Persisting SQL Server Index-Usage Statistics with MERGE[/url]
Turbocharge Your Database Maintenance With Service Broker: Part 2[/url]
April 9, 2009 at 11:50 am
Thanks all for your input.
If I may add one more point here to what George just mentioned: data encryption and protection of encrypted data.
Who else but the DBAs is better...
__________________________________________________________________________________
SQL Server 2016 Columnstore Index Enhancements - System Views for Disk-Based Tables[/url]
Persisting SQL Server Index-Usage Statistics with MERGE[/url]
Turbocharge Your Database Maintenance With Service Broker: Part 2[/url]
April 6, 2009 at 3:42 pm
I posted the question on http://www.sqlservercentral.com/Forums/Topic691281-361-1.aspx.
Thanks in advance for all the feedback.
__________________________________________________________________________________
SQL Server 2016 Columnstore Index Enhancements - System Views for Disk-Based Tables[/url]
Persisting SQL Server Index-Usage Statistics with MERGE[/url]
Turbocharge Your Database Maintenance With Service Broker: Part 2[/url]
April 6, 2009 at 11:19 am
Steve Jones - Editor (4/6/2009)
I'd actually ask you start a new thread for that. It's a great question, and I think it deserves some debate. If you post a URL...
__________________________________________________________________________________
SQL Server 2016 Columnstore Index Enhancements - System Views for Disk-Based Tables[/url]
Persisting SQL Server Index-Usage Statistics with MERGE[/url]
Turbocharge Your Database Maintenance With Service Broker: Part 2[/url]
April 6, 2009 at 11:09 am
With the advent of third-party enterprise-level backup solutions, such as Symantec or CommVault, how justifiable is it to maintain that DBAs should still be the owners of the database-backup/restore process?...
__________________________________________________________________________________
SQL Server 2016 Columnstore Index Enhancements - System Views for Disk-Based Tables[/url]
Persisting SQL Server Index-Usage Statistics with MERGE[/url]
Turbocharge Your Database Maintenance With Service Broker: Part 2[/url]
April 6, 2009 at 10:57 am
Viewing 15 posts - 646 through 660 (of 1,518 total)