Increase in Network I/O when running SQL Profiler
Hi, Just wondering why every time I run the profiler on SQL Server 2008, and I monitor the Activity Monitor’s network I/O it increases and when I stop or pause the profiler the network I/O decreases? This occurs the same when I run the profiler remotely or on the SQL Server instance. What has this [...]

Answer Question   |  June 21, 2011  4:58 AM
I/O errors, SQL 2008, SQL Profiler, SQL Server 2008

Free IT Book: Securing SQL Server
This week’s free IT book is written by one of IT Knowledge Exchange’s very own members, Mrdenny. Securing SQL Server promises to help you “secure your SQL Server database so the outside world can’t access your internal data.” With Mrdenny’s extended experience in simplifying SQL speak via his blog, SQL Server with Mr. Denny, this [...]

Answer Question   |  June 24, 2011  7:56 PM
AS/400, Business Intelligence, Channel, CIO, CRM, Database, DataCenter, Development, Exchange, Giveaways, Linux, Lotus Domino, Microsoft Windows, Mobile, Networking, Oracle, SAP, Security, SQL Server, Storage, Virtualization, VoIP, Windows Server

Open IT Forum: Are you on hacking offense or defense?
Sony isn”t the only company getting hit hard by hackers. Sega just joined the bunch, and Lockheed Martin’s breach is still fresh. How does your company set up a strong offense against hacks and breaches? Or, if your company’s security has been compromised in the past, how did you respond and set up a sufficient [...]

Answer Question   |  June 29, 2011  7:52 PM
AS/400, Business Intelligence, Channel, CIO, CRM, Database, DataCenter, Development, Exchange, Linux, Lotus Domino, Microsoft Windows, Mobile, Networking, Open IT Forum, Oracle, SAP, Security, Sony, Sony PlayStation Network breach, SQL Server, Storage, Virtualization, VoIP, Windows Server

EmployeeNumber query in SQL Server 2008
I am trying to write a query that will generate employee numbers. Employee number = first initial & first 7 characters of last name. UNLESS that is taken, then it’s first initial, first 6 characters of last name, then the number 1. UNLESS that is taken, then it’s first initial, first 6 characters of last [...]

Answer Question   |  June 21, 2011  7:25 PM
IF logic, IF statement, SQL Query, SQL Server 2008

Execute SP through DOS
Can you tell me how to execute the parametrized procedure using DOS or command prompt?

Answer Question   |  August 30, 2011  6:03 PM
DOS Batch, SQL Server, SQL Server 2005

Problem Querying SQL table from PHP
I recently added a new table to an existing database. Data is entered into the db via a web front end, using PHP 5. I am not a php developer. Our developer is trying to build a search query against the new table (there is data in the table). From the page he is working [...]

Answer Question   |  June 20, 2011  2:50 PM
PHP, SQL 2008, SQL Server 2008, SQL tables

I want to dump the contents of the DSPFD command to file and then use FNDSTRPDM to find certain text strings
I am doing some testing with file attributes that I want to automate.  I have been using the DSPFD command to print the attributes of the file.  I would now like to automate that.  I tried dumping the output of the command to an outfile and then using FNDSTRPDM to find out if the attribute [...]

Answer Question   |  June 20, 2011  5:35 PM
AS/400 commands, Database Files, DSPFD, FNDSTRPDM

SQL Server Patch
How do you get notified when Microsoft is doing a SQL Server Patch? Is there a way to be alerted before they do a patch?

Answer Question   |  June 27, 2011  1:56 PM
SQL Server, SQL Server administration, SQL Server alerts

Building new SQL server
had a sql server (2000 I think) built on enterprise 2003 die. Got new hardware and am beginning the guessing game. any good reference articles, step by step of how to build new and restore backups from external hd. Old server won’t even boot.

Answer Question   |  June 15, 2011  12:56 PM
Backup, SQL Server, SQL Server 2000, SQL Server 2000 SP4, SQL Server backup and restore

Select Value question in SSMS
I am trying to select “log_comment” field with the max(“stamp_date”) field from “action_log” table where “field_index” field =’1007′ I am getting more than just the row with the maximum stamp_date. Can someone please tell me what I’m doing wrong? Field_Index    Stamp_Date   Log_Comment 1007             2011-05-12    posting not complete 1007             2011-06-08    Pulled temporarily 1007             2011-04-15    PO needs [...]

Answer Question   |  June 16, 2011  9:22 PM
SQL Server Management, SQL Server Management Studio, SSMS

Open IT Forum: What tech blogs and Twitter feeds do you follow?
Each month, we cast the net asking what [Insert tech topic here] Twitter feeds and blogs you read, but this month is a free for all! We want to know any and all tech blogs or Twitter feeds you trust, admire, and follow religiously. We want links and we’d love to hear why you love [...]

Answer Question   |  March 7, 2012  7:36 PM
AS/400, Business Intelligence, Channel, CIO, CRM, Database, DataCenter, Development, Exchange, IT Blogs, Linux, Lotus Domino, Microsoft Windows, Mobile, Networking, Open IT Forum, Oracle, SAP, Security, SQL Server, Storage, twitter, Virtualization, VoIP, Windows Server

SELECT with LIMIT in AS/400
Hi all, On my AS400, I need to select the first 90 records from one file and insert them into another file, but all the time i got all records in my result file. Is there any way to use the parameter LIMIT with my SQL SELECT INSERT INTO LIB1/FILE1 (FILE1) SELECT DISTINCT                  (substring(FILE1, 1, [...]

Answer Question   |  June 14, 2011  6:40 PM
AS/400 Parameters, AS/400 Records, SQL, SQL Select

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

Answer Question   |  January 21, 2012  6:03 PM
SQL Server 2005, VB.NET, VB.NET 2005, Visual Basic, Visual Basic 2005

Free IT Book: Achieving Extreme Performance with Oracle Exadata
This week you could win a copy of Achieving Extreme Performance with Oracle Exadata from Oracle Press. Chock full of best practices for Oracle Exadata Database Machine deployment and maintenance, this resource covers data warehousing, transaction processing, consolidation strategies, maximum availability, and backup and recovery. To win, simply answer one of five questions and post [...]

Answer Question   |  June 21, 2011  5:55 PM
AS/400, Business Intelligence, Channel, CIO, CRM, Database, DataCenter, Development, Exadata Database Machine, Exchange, IT Books, Linux, Lotus Domino, Microsoft Windows, Mobile, Networking, Oracle, SAP, Security, SQL Server, Storage, Virtualization, VoIP, Windows Server

How to extract database with SQL Developer
Hi there… How do I extract a database created in Oracle APEX, using Oracle SQL Developer tool??? Thanx in advance

Answer Question   |  June 13, 2011  12:38 PM
Oracle, Oracle Apex, Oracle SQL Developer, SQL Developer

The SSIS 2008 R2 job does not complete execution
I have an SSIS package created in 2005 SP2. I have compiled this and is sheculed to run under SQL Server 2008 R2, which connects to a SQL Server 2005 database. What the package does. 1.The package FTP’s some files to the local folder. I verified to confirm the files are downloaded correctly. 2. Truncate [...]

Answer Question   |  June 13, 2011  5:10 PM
SQL Server 2008, SQL Server 2008 R2, SQL Server Integration Services, SQL Server tables, SSIS, SSIS 2008, SSIS Job

Modifying a Stored Procedure
The stored procedure below pulls suspected duplicate records. What I need it to do is return suspected duplicates only if it meets the criteria of having a member record type (GEN) & a non-member record type (WEB). But if the duplicates both have a non-member record type I don’t want it showing up on the [...]

Answer Question   |  June 9, 2011  2:31 PM
Crystal Reports, SELECT statement, SQL, SQL Database, SQL stored procedures, Stored Procedures

Embedded SQL using SUM or some other method to total up qty and display 1 unique record
I have an sqlrpgle pgm setup, I want to add another sql select statement. I have a file that contains barcode label data, where multiple records can be assigned to the same Master serial #. My sqlrpg pgm is display various sorts in a screen inquiry. I want to setup my select, to display one [...]

Answer Question   |  June 10, 2011  11:30 AM
Embedded SQL, SQL, SQL Select, SQL Select statement problem, SQLRPG

Announcing the Symantec Endpoint Protection 12 Scavenger Hunt (sponsored)
Want the chance to win an iPad 2 or Amazon.com gift cards? The Symantec Endpoint Protection 12 Scavenger Hunt is your opportunity to learn about all of the new features of Symantec Endpoint Protection 12 while getting in the running to earn great prizes. Think you know about all of the new features of Symantec [...]

Answer Question   |  June 8, 2011  3:49 PM
AS/400, Business Intelligence, Channel, CIO, Contests, CRM, Database, DataCenter, Development, Exchange, Linux, Lotus Domino, Microsoft Windows, Mobile, Networking, Oracle, SAP, Scavenger Hunt, Security, SQL Server, Storage, Symantec Endpoint Protection 12, Virtualization, VoIP, Windows Server

Free IT Book: The Data Warehouse Mentor
The Data Warehouse Mentor by Robert Laberge will show you how to plan, design, construct, and administer an integrated end-to-end DW/BI solution. He’ll explain how to choose appropriate components, build an enterprise data model, configure data marts and data warehouses, establish data flow, and mitigate risk. Change management, data governance, and security are also covered [...]

Answer Question   |  June 8, 2011  12:43 PM
AS/400, Business Intelligence, Channel, CIO, CRM, Database, DataCenter, Development, Exchange, Giveaways, IT Books, Linux, Lotus Domino, Microsoft Windows, Mobile, Networking, Oracle, SAP, Security, SQL Server, Storage, Virtualization, VoIP, Windows Server