Viewing 15 posts - 16 through 30 (of 6,105 total)
January 13, 2017 at 2:39 pm
Is antivirus in control of the firewall? I've seen cases where it is and unless you check advanced, it may appear off when it isn't.
January 13, 2017 at 2:34 pm
I just change the password of windows local admin account under which reporting service was running....
January 13, 2017 at 2:33 pm
Is there an efficient way to update backend SQL table through Excel?
I tried in Excel using...
January 13, 2017 at 2:25 pm
No, cross-database ownership chaining is not enabled by default and you couldn't disable it. It used to be, until SQL Server 2000 SP3. After that, you must enable yourself. See...
September 16, 2016 at 11:49 am
I would wait until you see updated guidance from Microsoft indicating it's supported on the new OS. I know it won't work on Nano. Nano doesn't have all the required...
September 16, 2016 at 11:45 am
cyp901 (3/31/2016)
March 31, 2016 at 8:58 am
I would recommend against the Quest (now Dell cmdlets). They don't release memory very well and you can't force garbage collection on them. So while they are great for small...
March 31, 2016 at 7:36 am
Ed Wagner (3/28/2016)
ZZartin (3/28/2016)
Ed Wagner (3/28/2016)
Iwas Bornready (3/28/2016)
Steve Jones - SSC Editor (3/25/2016)
DBA_Rob (3/25/2016)
March 28, 2016 at 2:43 pm
No. The CREATE DATABASE ENCRYPTION KEY command can only specify AES or Triple DES, both with are FIPS 140-2 compliant.
More here:
Instructions for using SQL Server 2008 in FIPS 140-2-compliant mode
November 20, 2015 at 11:41 am
Yes, sp_helprevlogin is the best way. It'll create two stored procedures in your master DB.
Filtering down the logins to extract and putting into a script is easy. Wrote about it...
November 17, 2015 at 11:50 am
November 17, 2015 at 11:42 am
The most overlooked area: "soft skills."
- How clearly you can communicate.
- How well you work with others.
- How organized you are.
DBAs and system administrators generally get a bad rap for...
November 17, 2015 at 11:33 am
This depends greatly on your I/O and very much becomes a question of cost vs. performance. Do you have any kind of numbers around that?
August 14, 2015 at 2:29 pm
According to the preliminary view of Books Online for SQL Server 2016, there is no indication that it has:
About Log Shipping (SQL Server)
Compare this with the article for Database Mirroring...
August 14, 2015 at 2:27 pm
Viewing 15 posts - 16 through 30 (of 6,105 total)