User Profile

Collapse

Profile Sidebar

Collapse
rkeith27
rkeith27
Last Activity: Aug 1 '08, 07:20 PM
Joined: Mar 21 '08
Location:
  •  
  • Time
  • Show
  • Source
Clear All
new posts
  • rkeith27
    replied to IIS on Virtualized Server
    in IIS
    I certianly don't want a single point of failure on the physical hardware of the virtual server. With that said do you load balance it just like you would normal physical web servers? I'm really looking for the "best practices". My gut says hardware load balancer with 2 virtual servers.
    See more | Go to post

      Leave a comment:

    • rkeith27
      replied to SQL Server 2005 native client ODBC query
      in SQL Server
      If you are talking about the Bulk Insert utility, I imported the data to a temp table (every field varchar(200)) and then I validated the data in the temp table before moving it into production tables. If no errors occurred, I deleted the temp table record. Finally, I moved to the next record and repeated until I was done.

      Hope this helps.
      See more | Go to post

        Leave a comment:

      • rkeith27
        replied to query for duplicates
        in .NET
        If I understand it correctly...
        I didn't try the query but it should be correct, if not it's real close.


        SELECT userID,
        COUNT(userID) AS userID_NumOccur rences, weekEndingDate,
        COUNT(weekEndin gDate) AS weekEndingDate_ NumOccurrences
        FROM tableA
        GROUP BY userID, weekEndingDate
        HAVING ( COUNT(userID) > 1 AND COUNT(weekEndin gDate) > 1)
        See more | Go to post

          Leave a comment:

        • rkeith27
          started a topic Deadlock issue... (not the average deadlock)
          in SQL Server

          Deadlock issue... (not the average deadlock)

          Okay, here goes... deadlocks have been occurring since Dec 17, 2007 on database; however, no changes were made to the code or the database. The application had been in production for 1 1/2 years before the deadlocks began occurring. On Dec. 17, 2007 two KB updates from Microsoft were installed but neither was SQL related. One for Daylight Savings and the other for a Macrovision driver exploit. Also, our ISP was changed and a new database that had...
          See more | Go to post
          • rkeith27
            started a topic IIS on Virtualized Server
            in IIS

            IIS on Virtualized Server

            I was approached and asked about virtualizing my web farm. I currently have 3 servers in the farm. What is the consense on this forum regarding virtualization of a web server (IIS)? Also, what about SSL sessions and sesiion persistance; will it be the same as it was with a load balanced web farm? Looking for any guidance on this. Thanks.
            See more | Go to post
            • rkeith27
              started a topic List web servers on the domain
              in .NET

              List web servers on the domain

              In VB.NET, how can I get a list of Windows 2003 Servers that have IIS installed/running on them? I can get the computer list from AD but I don't know which ones are servers with 2003 and which ones have IIS installed/running on them. Thanks.
              See more | Go to post
              No activity results to display
              Show More
              Working...