Would like to learn SQL. Which vendor should I go for and what certification should I get?
Hi All, I would like to learn SQL but was wondering shich SQL package should I go for? I am looking for emplyment in the finance industry as an analyst and thus looking for the right SQL package to learn and get the right certification. Could somone please advise me accordingly. cheers! Jeevan

Answer Question   |  February 14, 2011  2:29 AM
SQL, SQL certifications, SQL Server, SQL Server certifications

Contest Bounties: Last chance to win an iPad!
The end of the iPad contest is drawing near – next Wednesday, February 16th to be exact – and we want to see more of you in the final drawing. In order to help push you over the 500 knowledge point requirement, we assembled some last chance bounties to get you in the running: 1. [...]

Answer Question   |  February 15, 2011  3:48 PM
AS/400, Channel, CIO, CRM, Database, DataCenter, Development, Exchange, ITKE Contests, Linux, Lotus Domino, Microsoft Windows, Mobile, Networking, Oracle, SAP, Security, SQL Server, Storage, Virtualization, VoIP, Windows Server

un-format object viewer sql tab
Hi experts, Can someone tell me, how can I turn off automatic code formating on the Object viewer’s SQL tab (i.e. the sql code in the SQL tab of an opened view is automatically formated compared to the code I used to create it) Thnx in advance for yr answers

Answer Question   |  February 11, 2011  8:13 AM
Oracle SQL, Oracle SQL Developer, SQL, SQL Server

SQL Server 2005 Reporting Services Move
I am trying to move an entire report server to a different server. When I move the databases and config files all of my shared data sources do not have a connection string and credentials in them. How can I move SSRS data sources with connections strings and credentials to another server?

Answer Question   |  February 11, 2011  9:12 PM
Report Server, Reporting Services 2005, SQL Server 2005, SQL Server migration, SQL Server Report Server

Open IT Forum: Security Worst-Cases
Have you had rogue employees deploying to the cloud without your knowledge, that is, until something went wrong? Share your worst-case experiences including how you rectified the situation. We want to hear your security horror stories to help other members and potential rogue employees avoid the same pitfalls. The best stories get 200 knowledge points [...]

Answer Question   |  February 17, 2011  5:57 PM
AS/400, Channel, CIO, Cloud Security, CRM, Database, DataCenter, Development, Exchange, Linux, Lotus Domino, Microsoft Windows, Mobile, Networking, Open IT Forum, Oracle, SAP, Security, SQL Server, Storage, Virtualization, VoIP, Windows Server

SQL 2005 Database instance
Hi there i have a windows 2003 domain in our school, i have a problem with my sql 2005 database. im trying to uninstall a instance from the database engine. it wont uninstall. i believe that this is corrupt. im trying to reinstall sophos but as the old database will not uninstall sophos wont reinstall. [...]

Answer Question   |  April 12, 2011  12:13 PM
Database Instances, SQL 2005, SQL Server 2005, SQL Server 2005 Database, Windows Server 2003 Domain, Windows Server 2003 SP2

Search: Error with SQL : Login failed for ‘SA’.
I’m using a softawre written in VB(.net). It runs normal on XP and 2003 server. it supports both Access and SQL 2000 and 2005. but I recently upgraded my OS to Win7+SQL 2008, and I’ve been having the following error anytime a call for a screen in the software”Search: Error with SQL : Login failed [...]

Answer Question   |  June 28, 2011  11:53 PM
SQL Server 2000, SQL Server 2005, VB.NET, Visual Basic, Windows Server 2003

What are your favorite cloud security blogs?
You told us what your favorite IT blogs are, now we want to get a little more specific. Do you have any security blogs or cloud security blogs that you go to for the latest threats and solutions? Share your pick by Wednesday, February 9, 2011, and we’ll give you 50 knowledge points!

Answer Question   |  December 30, 2011  8:43 PM
AS/400, Channel, CIO, Cloud Computing, Cloud Security, CRM, Database, DataCenter, Development, Exchange, Linux, Lotus Domino, Microsoft Windows, Mobile, Networking, Open IT Forum, Oracle, SAP, Security, Security bloggers, SQL Server, Storage, Virtualization, VoIP, Windows Server

Storage Area Network Certification
is there a certification for SAN admin? I am a beginner and want to be a SAN admin where do i start?

Answer Question   |  August 9, 2011  5:46 PM
SAN, SAN certificate, SQL Server, Storage Area Networks

Free IT Book: Drupal’s Building Blocks
Today’s free IT book is an essential addition to any developer’s library: Drupal’s Building Blocks. Learn how to quickly build web sites with CCK, Views, and Panels, all by answering one of five questions and posting the link to your answer in the discussion area below. A particular IP range cannot access internet through ISA [...]

Answer Question   |  February 7, 2011  3:35 PM
AS/400, Channel, CIO, CRM, Database, DataCenter, Development, Drupal, Exchange, Giveaways, Linux, Lotus Domino, Microsoft Windows, Mobile, Networking, Oracle, SAP, Security, SQL Server, Storage, Virtualization, VoIP, Windows Server

SQL Server 2005 login error
I am not able to login in SQL SERVER 2005, I am getting error message”The connection was succesfully established with server, but then an error occur during pre-login handshake.(provider:SSL provider error:0- The certificate chain was issued by an authority that is not trusted.)(Microsoft sql error) Please provide me some solution…………… Thanks

Answer Question   |  February 7, 2011  6:05 AM
SQL Server 2005 error messages, SQL Server error messages, SQL Server errors

SQL Server 2005 database installation
i installed sql2005 s/w in my system.but i don’t know how to use it.i don’t know how to create database and manage and all.can u help me?

Answer Question   |  February 7, 2011  5:20 AM
SQL 2005, SQL Server 2005, SQL Server 2005 Database, SQL Server database

Can I install SQL Server 2005 32 bit on 64 bit OS?
can I install SQL Server 2005 32 bit on 64 bit win 2003 OS?

Answer Question   |  February 5, 2011  5:51 AM
SQL 2005 installation, SQL Server 2005, SQL Server 2005 (32-bit), SQL Server installation, SQL Server Installation Options, Windows Operating System, Windows Server 2003

SQL Server 2005 permissions required by public
Our security madates that ALL object permissions be removed from”public”. After doing that, no one can see their tables or do anything. What are the absolutly NEEDED permissions required by public (Execute, Select, etc.)?

Answer Question   |  February 15, 2011  6:46 PM
SQL Security, SQL Server 2005, SQL Server 2005 security, SQL Server permissions

Open IT Forum: Tell us your must-read IT blog or Twitter feed & earn 50 knowledge points!
We’re always looking for great resources to share with the community, so here’s your chance to share what’s in your own bag of tricks! Share your favorite IT blogs or Twitter personalities, what they write about, or a link to a post that taught you something you’ll never forget. Don’t have a favorite tech blog? [...]

Answer Question   |  August 23, 2011  4:25 PM
AS/400, Channel, CIO, CRM, Database, DataCenter, Development, Exchange, ITKE, ITKE Contests, Linux, Lotus Domino, Microsoft Windows, Mobile, Networking, Open IT Forum, Oracle, SAP, Security, SQL Server, Storage, Virtualization, VoIP, Windows Server

Implementing a chat using SQLServer Service Broker – how good an idea it is?
We are designing a chat engine. That’s basically a message queue. When our customers will adopt it, there will be thousands of people chatting. In our company we use SQLServer heavily, and this is an argument for preferring Service Broker over MSMQ. Is Service Broker a good idea? Each chat session will be a new [...]

Answer Question   |  February 3, 2011  4:23 PM
Chat applications, SQL 2008, SQL Server, SQL Server 2008

Earn 50 knowledge points by tweeting out our iPad contest!
We’ll give you 50 knowledge points for sending out a tweet about our iPad contest, happening now through February 16th! Spread the word, earn points, and qualify yourself for an iPad or Amazon.com gift card! Contest details at the Community Blog.

Answer Question   |  February 3, 2011  3:51 PM
AS/400, Channel, CIO, CRM, Database, DataCenter, Development, Exchange, ITKE, ITKE Contests, Linux, Lotus Domino, Microsoft Windows, Mobile, Networking, Oracle, SAP, Security, SQL Server, Storage, twitter, Virtualization, VoIP, Windows Server

SQL 9010 Error when using RUNSQLSTM
I have a CL program having the following RUNSQLSTM RUNSQLSTM  SRCFILE(AMBDEV/MSRCAMB) SRCMBR(AMBJARRVK)            COMMIT(*NONE)                            AMBJARRVK is a SQL member file in MSRCAMB source file having this SQL statment DELETE FROM GDPF WHERE GDUSID = ‘A365′ AND GDOID = ‘JAR’ I am receiving SQL9010 error when running the CL program… Any hint on where is the [...]

Answer Question   |  May 16, 2012  8:03 AM
CL Program, CLPROGRAM, RUNSQLSTM, SQL error messages

Resolving all losing conflicts-Merge Replication in SQL Server 2005 and 2000
The application I support uses SQL Server 2005 as the publisher and SQL Server 2000 at the subscriber. One of our clients went nuts trying to prune his database and deleted a year and a half of sales data. Unfortunately I did not have a backup, but I did have an old copy of the [...]

Answer Question   |  February 2, 2011  5:34 PM
SQL Server 2000, SQL Server 2005, Windows Server 2003 R2, Windows XP

Crystal Reports XI period in database name
SQL Server 2005 database has a period in its name. For example, data.12. I call a crystal report from VS2008. I use ConnectionInfo object to pass connection info to a report. I get errors in formulas. Renaming DB resolves the issue. How can I get it to work with names like data.12?

Answer Question   |  January 13, 2012  12:12 AM
Crystal Reports, Crystal Reports XI, SQL Server 2005, SQL Server 2005 Database