Agents, agents, agents! (that is to say recruitment agents and not SQL Server agents LOL)

Great respect for your vision, persistence and achievements.

I have served 43 years in enterprise IT coming into the industry as a refugee Ph.D. biochemist during the recession of the early...

Thanks for the article. In my experience (15 years SQL Server, 25 Oracle) there have been so many instances where despite hours of research and hacking the T-SQL, an...

Really enjoyed the article. Thanks. Great demo for my advanced training labs. Have done this in Oracle several times and is interesting to see how SQL server...

The guru's name should read - Pinal Dave. My humble apologies.

Here is a message queue example which we use. There is a need keep the reporting load off the day time production window where on-line has the priority.

A...

Here is the scenario:-

access-list 101 permit tcp host 10.5.6.23 0.0.0.255 host 172.16.1.1 ## all portnumbs admitted ##

The server is exposed to packets from a single ip.

An...

When a sqlserver client app connects to the default instance of the sql server the connection goes to the TCP port 1433. However I agree the named instance port...

Much preferring the hardware security appliance approach, here are a few comments on securing SQL server using firewalls/router ACLs. The discussion is dependent on the user population and what...

Simple, elegant and easy to follow. Thanks for the technique. Can I ask how we would get round NAT masking the true IP address - or I guess...

I assiduously read half the article on SQL functions - SELECT vague(n,m) and others - LOL - and spotted the spoof before climbing into BOL and GOOGLE. However, almost...

Fair comment. Thanks for the workout!

Joined the fray to make exactly the same point as previous contributors ref. a clustered index has to be created first, then other indexes may follow. As an Oracle...

Many thanks for the recommended MSDN forum. Have posted the problem there. Will update this thread if anything useful come of it.

Not sure we are scenting the right trail with this discussion.

Proc works when run in studio but not when called from php.

SQLServer2008 has 1000 transaction limit - test...