Viewing 15 posts - 9,256 through 9,270 (of 9,725 total)
HTTP Endpoints are much more secure. You can actually dictate the type of traffic you get and, I believe, the network protocol used to access it.
Not to mention you...
November 27, 2007 at 6:39 am
I had originally heard February, but that was like 6 months ago, so I'm not surprised my info is out of date. @=)
November 27, 2007 at 5:00 am
I don't know about demos. Some are good, some are bad. But most of them are canned. Which means the demonstrator is going to show you all...
November 27, 2007 at 4:58 am
In addition to Security (and the auditing available with DDL triggers), the main reasons I would add are SSIS, Solution Explorer, Database Mirroring and Snapshots.
DM & Snapshots are wonderful...
November 27, 2007 at 4:44 am
Are you working in 2000 or 2005?
You posted to the 2k5 forum, but EM is a 2000 tool and in 2k5 you not supposed to be able to...
November 27, 2007 at 4:32 am
First, go into your SQL Server Configuration Manager and verify that NONE of your services are running under the Built-In Administrators account. It doesn't have to be the SQL...
November 27, 2007 at 4:29 am
All, I'm glad my article is generating such positive responses. For those currently going a similar Non-IT to DBA route, I hope my experiences help you along the way.
Nadeem7971,...
November 27, 2007 at 4:07 am
Hey, Jorg, the article Steve pointed out also has info on the 446 exam. You might want to check it out.
November 27, 2007 at 3:55 am
You can also use SUM(ISNULL(Quantity,0)) to do something similar. The difference is that ISNULL simply replaces any NULL values with zero instead of looking for the first non-NULL value.
November 27, 2007 at 3:51 am
Thanks for the blog, Jorg! I appreciate it!
November 26, 2007 at 11:37 am
WANT MORE FEATURES!!!!
Sorry, couldn't resist. @=)
The Scope Creep discussion reminds me of a moment at one job where the developers worked their butts off designing a website solution (tied to...
November 26, 2007 at 11:34 am
Andy Warren said:
Good stuff, even if I don't rank up there with Brian & Steve!
On the contrary, Andy. You definitely rank up there with those two! Your...
November 26, 2007 at 6:18 am
Unfortunately, using the LIKE operator always affects query performance. For one, if you use the wildcard on both sides of the search syntax, then you can inadvertantly generate tablescans.
The...
November 26, 2007 at 5:06 am
What error are you getting with the Flat File Source?
And what datatype is the column you're importing this data into?
November 26, 2007 at 5:00 am
Viewing 15 posts - 9,256 through 9,270 (of 9,725 total)