Viewing 15 posts - 9,211 through 9,225 (of 9,725 total)
You can pretty much start anywhere. Here's a link to all the SQL Server certs: http://www.microsoft.com/learning/mcp/mcitp/default.mspx
Only three of the certs on that page are relevant to SQL Server....
December 10, 2007 at 4:14 am
You should at least know the syntax to the basic commands and some of the newer stuff. There are multiple choice questions which ask you about syntax and what...
December 10, 2007 at 4:05 am
Odd. In so far as I know, the install of Visual Studio does not automatically install SQL Express. It certainly didn't on mine.
Anyone else see this behavior?
December 7, 2007 at 7:19 am
When SQL 2k5 installs, it goes through a list to check components. Did you see any errors or warnings from that part of the install?
December 7, 2007 at 4:26 am
Have you tried the BackupDeviceList object yet?
http://msdn2.microsoft.com/en-us/library/microsoft.sqlserver.management.smo.aspx
December 6, 2007 at 11:03 am
Actually, how far have you gotten in your coding? Do you already have the connections set up? Or are you starting from scratch right now?
December 4, 2007 at 7:28 am
Given 3rd party tools like Litespeed can do P.I.T. restores and they do it by accessing Microsoft .dlls, I would think that you can do it.
I'm not sure...
December 4, 2007 at 7:26 am
Thanks for the info! I appreciate it!
December 4, 2007 at 4:59 am
The way I learn is to not only take notes of keypoints while I'm studying, but to have 2005 set up on a test server where I can try the...
December 4, 2007 at 4:53 am
Dan,
How are you backing up? T-SQL or with a maintenance plan? Or are you using a third party tool?
Where are you backing up? Tape Drive, disk drive,...
December 4, 2007 at 4:48 am
Stupid question, but when you upgraded your software, did you upgrade your hardware too?
I've noticed on some boxes that if the hardware remains at 2000 levels, that 2005 can run...
December 4, 2007 at 4:45 am
It's a sad truth that it doesn't matter if your users are athenticated or not. Don't go the 5 seat route. If you get caught, you could get...
December 4, 2007 at 4:42 am
I hate to break it to you, dr_csharp, but all SQL Server 2005 have some limitations on what OS they will use. At minimum, any Windows 2000 OS has...
December 4, 2007 at 4:35 am
We actually have a T-SQL script which uses XPCmdShell to read a list of the backup files from a specific directory. Then we parse the name down to pull...
December 4, 2007 at 4:26 am
Viewing 15 posts - 9,211 through 9,225 (of 9,725 total)