Pre-certification Tests
Apr 23, 2007Anyone know of a site or company that provide good pre-tests for certification?
I don't mind paying for downloadable test either.
Peter Larsson
Helsingborg, Sweden
ADVERTISEMENT
SQL 7.0 Admin Tests
May 19, 1999Has anyone who has taken and passed the SQL 7.0 test for SQL Admin
have any recommendations on the best sources to help pass?
Speed Tests (in Vs. Specified)
Jul 30, 2007Hi Everyone -
We were discussing select speeds the other day,
the question comes in at...
what is faster, a standard query with specifies the search critera
i.e. select * from xyz where a='A' or a='B'
or is the IN a better way to go....
select * from xyz where a in ('A', 'B')
we ran the tests in performance analyzer,
but they were the same results....
maybe i'm smoking the stuff - but i thought the
useage of the IN causes a full table scan for each
of the items in the in clause
please advise
take care
tony
IT Tests. SQL, XML, ASP.NET, C, C++, C#, VB.NET, HTML...
Feb 17, 2006http://www.testyourabilities.com/it/IT tests. SQL, XML, ASP.NET, C, C++, C#, VB.NET, HTML...
View 2 Replies View RelatedTransact SQL :: Last X No Of Tests
Jun 3, 2015I have one requirement where i have multiple tests conducted on different dates where i have to calculate last 'x' no of tests
Test Date
Test Seq
Subject
1/12/2014
1
English
[code]....
If i enter @testcount=2 then it should pull the data for only data related to test date 1/12/2014 & 10/06/2014...Above data is only sample data but logic should be dynamic..
SQL Sever Performance Tests
Jul 28, 1998I am currently investigating tools that are available that would enable us to performance test SQL tables/databases- can anyone recommend any?
Thanks
Web Tests Of Reports Working For Anyone?
Feb 11, 2007Has anyone been successfull in creating a Web Test with Team System to test a Reporting Services report? I can record the test just fine but I can't run the test without errors being reported. I suspect that the session state has to be parameterized but I have no clue how to do this.
Why is this so hard? Why aren't there samples for this kind of thing? I've been all over the SSRS and Team Test forums and the MSDN site and can't find anything about Reporting Services reports being tested with Team System Web Tests.
How To Modify This Code So That It Also Tests For NULL
Aug 2, 2004Hi,
I'm trying to extend the usage of the code below. This method returns a variable of type SQLParameter and what I want is to accomodate even a check for a null in the parameter. This is a code which I got from one of my co-workers who isn't anymore working here. Any help would be appreciated. I do not want to throw an exception here when a field's type doesn't fall into one of the categories below. The method where this methos is called is the first part of my below code. Any help would be appreciated.
Part 1
private void AddCommandParameters(SqlCommand Comm, string sProcName, ArrayList aParams)
{
string sSQL = "sp_helptext @objname = '" + sProcName + "'";
SqlDataReader dr = this.GetDataReader(sSQL);
int i = 0;
if(dr.Read())
{
while(dr.Read())
{
//CLOSING PARENTHESIS
//When at the closing paren of the stored procedure's variable
//declaration, quit adding parameters.
if(dr[0].ToString().Trim() == ")")
{
break;
}
//ENDING PARENTHESIS
//When at the closing paren of the stored procedure's variable
//declaration, do nothing and skip to next record.
else if(dr[0].ToString().Trim() == "(")
{
//Nada
}
//PARAMETERS
//Add all the parameters listed in the stored procedure's variable
//declaration.
else
{
string [] sParamDef = dr[0].ToString().Trim().Split(Convert.ToChar(" "));
int cs = sParamDef.Length;
string st = sParamDef[0].ToString().Trim();
SQLParameter s = GetSQLParameter(sParamDef[0].ToString().Trim());
Comm.Parameters.Add(sParamDef[0], s.Type, s.Size);
Comm.Parameters[sParamDef[0]].Value = aParams[i];
i++;
}
}
}
else
{
throw(new Exception("Stored Procedure: " + sProcName + " NOT FOUND."));
}
dr.Close();
}
Method being called
private SQLParameter GetSQLParameter(string sVarTypeDec)
{
SQLParameter oParameter;
//VARCHAR
if(sVarTypeDec.IndexOf("varchar") >= 0)
{
int iOpen = sVarTypeDec.IndexOf("(");
int iClose = sVarTypeDec.IndexOf(")");
int iSize = Convert.ToInt16(sVarTypeDec.Substring(iOpen + 1, iClose - iOpen - 1));
oParameter = new SQLParameter(SqlDbType.VarChar, iSize);
}
//CHAR
else if(sVarTypeDec.IndexOf("char") >= 0)
{
int iOpen = sVarTypeDec.IndexOf("(");
int iClose = sVarTypeDec.IndexOf(")");
int iSize = Convert.ToInt16(sVarTypeDec.Substring(iOpen + 1, iClose - iOpen - 1));
oParameter = new SQLParameter(SqlDbType.Char, iSize);
}
//SMALLDATETIME
else if(sVarTypeDec.IndexOf("smalldatetime") >= 0)
{
int iSize = 4;
oParameter = new SQLParameter(SqlDbType.SmallDateTime, iSize);
}
//DATETIME
else if(sVarTypeDec.IndexOf("datetime") >= 0)
{
int iSize = 8;
oParameter = new SQLParameter(SqlDbType.DateTime, iSize);
}
//FLOAT
else if(sVarTypeDec.IndexOf("float") >= 0)
{
int iSize = 8;
oParameter = new SQLParameter(SqlDbType.Float, iSize);
}
//REAL
else if(sVarTypeDec.IndexOf("real") >= 0)
{
int iSize = 4;
oParameter = new SQLParameter(SqlDbType.Real, iSize);
}
//SMALLMONEY
else if(sVarTypeDec.IndexOf("smallmoney") >= 0)
{
int iSize = 4;
oParameter = new SQLParameter(SqlDbType.SmallMoney, iSize);
}
//MONEY
else if(sVarTypeDec.IndexOf("money") >= 0)
{
int iSize = 8;
oParameter = new SQLParameter(SqlDbType.Money, iSize);
}
//BIT
else if(sVarTypeDec.IndexOf("bit") >= 0)
{
int iSize = 1;
oParameter = new SQLParameter(SqlDbType.Bit, iSize);
}
//TINYINT
else if(sVarTypeDec.IndexOf("tinyint") >= 0)
{
int iSize = 1;
oParameter = new SQLParameter(SqlDbType.TinyInt, iSize);
}
//SMALLINT
else if(sVarTypeDec.IndexOf("smallint") >= 0)
{
int iSize = 2;
oParameter = new SQLParameter(SqlDbType.SmallInt, iSize);
}
//BIGINT
else if(sVarTypeDec.IndexOf("bigint") >= 0)
{
int iSize = 8;
oParameter = new SQLParameter(SqlDbType.BigInt, iSize);
}
//INT
else if(sVarTypeDec.IndexOf("int") >= 0)
{
int iSize = 4;
oParameter = new SQLParameter(SqlDbType.Int, iSize);
}
else
{
throw(new Exception("Parameter type not supported."));
}
return oParameter;
}
Thanks,
Remote Connection Tests Fine, But Nothing Works On The Page Itself.
Mar 26, 2008If this post belongs somewhere else I appologize. I have spent several days trying to solve this problem with no luck. My site is online. Hosted at NeikoHosting. I can connect to the database remotely when adding a datacontrol. It tests fine. But when running the page it won't connect. Even if I go in and change the Web.Config connection string to a local Data Source provided to me by Neiko, it still won't work. It just won't connect. Here are the two connection strings in the Web.Config, minus my login info: Only the remote string will pass testing. Neither works on the site. <add name="yourchurchmychurchDBConnectionString" connectionString="Data Source=MSSQL2K-A;Initial Catalog=yourchurchmychurchDB;Persist Security Info=True;User ID=me;Password=pwd" providerName="System.Data.SqlClient" />
<add name="yourchurchmychurchDBConnectionString2" connectionString="Data Source=66.103.238.206;Initial Catalog=yourchurchmychurchDB;Persist Security Info=True;User ID=me;Password=pwd" providerName="System.Data.SqlClient" />
Here is the stack trace, if that helps.
[DBNETLIB][ConnectionOpen (Connect()).]SQL Server does not exist or access denied.
Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code. Exception Details: System.Data.OleDb.OleDbException: [DBNETLIB][ConnectionOpen (Connect()).]SQL Server does not exist or access denied.Source Error:
An unhandled exception was generated during the execution of the current web request. Information regarding the origin and location of the exception can be identified using the exception stack trace below. Stack Trace:
[OleDbException (0x80004005): [DBNETLIB][ConnectionOpen (Connect()).]SQL Server does not exist or access denied.]
System.Data.OleDb.OleDbConnectionInternal..ctor(OleDbConnectionString constr, OleDbConnection connection) +1131233
System.Data.OleDb.OleDbConnectionFactory.CreateConnection(DbConnectionOptions options, Object poolGroupProviderInfo, DbConnectionPool pool, DbConnection owningObject) +53
System.Data.ProviderBase.DbConnectionFactory.CreateNonPooledConnection(DbConnection owningConnection, DbConnectionPoolGroup poolGroup) +27
System.Data.ProviderBase.DbConnectionFactory.GetConnection(DbConnection owningConnection) +47
System.Data.ProviderBase.DbConnectionClosed.OpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory) +105
System.Data.OleDb.OleDbConnection.Open() +37
System.Data.Common.DbDataAdapter.FillInternal(DataSet dataset, DataTable[] datatables, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior) +121
System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior) +137
System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, String srcTable) +83
System.Web.UI.WebControls.SqlDataSourceView.ExecuteSelect(DataSourceSelectArguments arguments) +1770
System.Web.UI.DataSourceView.Select(DataSourceSelectArguments arguments, DataSourceViewSelectCallback callback) +17
System.Web.UI.WebControls.DataBoundControl.PerformSelect() +149
System.Web.UI.WebControls.BaseDataBoundControl.DataBind() +70
System.Web.UI.WebControls.FormView.DataBind() +4
System.Web.UI.WebControls.BaseDataBoundControl.EnsureDataBound() +82
System.Web.UI.WebControls.FormView.EnsureDataBound() +163
System.Web.UI.WebControls.CompositeDataBoundControl.CreateChildControls() +69
System.Web.UI.Control.EnsureChildControls() +87
System.Web.UI.Control.PreRenderRecursiveInternal() +50
System.Web.UI.Control.PreRenderRecursiveInternal() +170
System.Web.UI.Control.PreRenderRecursiveInternal() +170
System.Web.UI.Control.PreRenderRecursiveInternal() +170
System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +2041
So....... HELP!!!!
Thank you!
SQL 2012 :: No Disks Were Found On Which To Perform Cluster Validation Tests
Sep 9, 2014I am getting following errors in my Cluster Validation report when trying to create a Windows Cluster.
I have 2 nodes DB01 and DB02 . Each has 1 public ip, 1 private ip (for heartbeat), 2 private ips for SAN1 and SAN2. The private ip's to SAN are directly connected via Network Adaptor in DB01 and DB02.
Validate Microsoft MPIO-based disks
Description: Validate that disks that use Microsoft Multipath I/O (MPIO) have been configured correctly.
Start: 9/9/2014 1:57:52 PM.
No disks were found on which to perform cluster validation tests.
Stop: 9/9/2014 1:57:53 PM.
[Code] ...
SqlDataSource Set To Stored Procedure, Tests OK In Wizard, Does Not Return Data When Executed
Apr 27, 2007With a Gridview Control, I set the SqlDataSource to be a stored procedure in a Sql Sever database.
Using the wizzard to configure the datasource, the test returns lots of rows. After completing the wizzard, the gridview control does not show the column names in the VS2005 designer. For the gridview column headers the values are Databound Col0, Databound Col1, Databound Col2, ....) This tells me I have a problem.
I tried the same thing with a simpler stored procedure. This test stored procedure does not call anything else, takes several input parameters, returns rows. The column names show in the gridview control as expected.
So I am trying to figure out why the first case of gridview with sqldatasource is not working and the second case works . The stored procedure that is not working with my gridview calls multiple inner stored procedures and has #TEMP tables. My complex stored procedure ends with Select * from #Temp.
Could the calling of other inner stored procedures and use of #temp tables contribute to the problem? If yes then what is the strategy for using a gridview and loading it with the data that the complex stored procedure returns?
SQL 7 Certification
May 14, 1999Does anyone know where to get practice tests for the new SQL 7.0 Admin exam?
TIA
Certification
Jan 12, 1999Where can I find information on the MCSDBA certification, when the exam is coming
out, is it for SQL 7.0, etc.
Certification !!!!!!!!!!!!
Feb 11, 2008Hi Experts,
I have a question in one of the interviews relates to MS Certification.
Is it require to have the MCDBA in SQL Server 2000 certification or required 2005 version certification?
If so, What is the main difference in having that over 2000 version.
Then it went like What the difference it makes having certification and what are the general comments about it.
I know 2005 definetely have the edge over the 2000 certification but I didnt understand what the major advantage in having and have not such certification.
Thanks in advance.
About Microsoft Certification
Jun 26, 2007hi.
iam learing Ms server 2005 i want is there any MicrosoftSoft certification for Microsoft Sql server 2005 alone
Resources For MS Certification
Jun 19, 2002I was thinking of doing certification from Microsoft. I was first intending to write exam 70-229 which is :
Designing and Implementing Databases with Microsoft SQL Server 2000 Enterprise Edition.
The Microsoft site http://www.microsoft.com/traincert/exams/70-229.asp#TOOLS has a list of topics that I need to be familiar with in order to pass the exam, but it does not have the detailed information.
Can someone guide me to a place where I can go to get the detailed information about these topics so that I can prepare better for the certification exam?
thanks
Aslam
Certification: Looking For Advise
Oct 1, 2004Hi All
I have been working with Ms access Database the last four years and have gained a lot of experience which help me to have extensive knowledge of Jet, Dao and Ado. Since The Begining of this year i hv been migrating to SQL server server and for that i bought two books :Programming Access project file with Microsoft Sql server and Access Developers Guide to Ms sql server : Chipman & Baron ( this oner is simply a great achievement ). They help me out in the very near past to complety migrate a two database approch Jet Application to a reliable (Adp/ SQL Server client server ) where major parts of the code business logic has been transfered to run on the server as stored procedures and all forms re-built as unbound. these merely leads to a great enhancement of the applications.
My goal now is register to MCDBA and get the certification. I am not interested by classroom training from Microsoft Parterns or online training. I am looking for books that can help to get well prepared for the exams.
Have found this two books in Amazon:
1 - MCAD/MCSE/MCDBA Self-Paced Training Kit: Microsoft SQL Server 2000 Database Design and Implementation, Exam 70-229, Second Edition
2- MCSA/MCSE/MCDBA Self-Paced Training Kit: Microsoft SQL Server 2000 System Administration, 70-228, Second Edition
However their rating didn't encourage me to place directly my orders.
Does someone have any experience with them ?
Do you think they will considerably help me to add value to my knowledge of SQL Server and get ready for the exam ?
Do you know some others books you woul rather encourage me to buy ?
Any advice in this regards really appreciated.
SQL Server Certification
Feb 17, 2006Hi,
I am interested in doing SQL server certification.
I don't know any information abt this.
It would be gr8 if u ppl could give some details as to
how many levels of certification are there,
how much is the cost of certification,
is there any pre-requiste for the same and so on...
Thanks,
Vatsan
SQL 2005 Certification
Nov 9, 2007Hello everyone. This is my first post on this board. I've been working for an investment bank in London (via an IT services company) as a DBA for a year now. It's pretty much my first real job since graduating from university. I did a bit of SAP before this job but it didn't really work out.
The work has been almost entirely on SQL Server 2000. I've done a bit of 2005 such as installs, backing up/restoring databases, setting up security.
I was thinking of doing an MCITP course in SQL 2005 in India early next year (my company will not pay for training - cheapos). The bank has recently been taken over by another bank and I don't know what the future holds beyond February, it's probably likely that the DBA's from the other bank will take over.
Do you think certification is needed? Would it be hard for me to get another job with the experience I currently have?
I find it difficult to study at home and the idea of going to India and getting the certification in 2 weeks appeals to me. Has anyone else ever been to a boot camp in India or elsewhere? Just how important is certification?
If you could provide me with some advice I would be most grateful.
Certification Question
Aug 23, 2005I am reading Administering SQL Server, a study guide for 70-228on page 27, it says:"INSTEAD OF triggers are useful when a DML operation is unsuccessful."I think this is nonsense. Any comments?
View 5 Replies View RelatedSSIS: MCP Certification
Dec 5, 2006Is there a mcp certification exam for SSIS? I have been using google to find information about SSIS exam but with out success.
Please help.
Certification Question
Jan 17, 2007Hi all,
I am new to Sql Server 2005
I planning to take exam MCTP exam 70-445
is the cert 70-431 a pre-requisite for certs 70-445 and 70-446?
Thanks and regards
Sql Server Certification 70-229
Mar 18, 2008Hi All,
I have planned to take up the exam 70-229 "Designing and Implementing Databases with Microsoft SQL Server 2000 Enterprise Edition" as a select exam for MCAD".
Any links to sure shot Dumps avialable for the above exams OR any good E books.
Please Help....
Thanks
2008 Certification ?
Feb 13, 2008Hi There
I know this is not the forum for this question however i dont know where else to post it.
I am about to write my MCITP DBA Admin for Sql server 2005, however now that 2008 is being released this year i was thinking about maybe waiting and just writing 2008.
But i have had little luck finding out how the certifications will work.
Does anyone know if it will still be MCITP DBA Admin and Dev certifications but for 2008. Or will it be a whole new kind of certification path ?
Bottom Line is it worth while to do 2005 MCITP right now ? Perhaps 2008 certifications will only be available in 2009 ?
If anyone has info onthis please let me know.
Appreciated, Thanx
SQL Server Certification Exam
Aug 3, 2004Hello,
My employer has recently offered to pay for my certification exam (70-229) so I am about to start preparing/revising. Having visited numerous sites to get an idea of what is needed, I am now overwhelmed with info.
Has anyone out there successfully completed the exam and if so can you recommend any sites/resources that you found useful (or any to avoid).
Regards
Simon
SQL Server Certification (MCAD)
Nov 1, 2004Hello,
I am about to start revising for exam 70-229 as part of my MS certification and was wondering if anyone has any advice/tips etc on revision material.
Having visited a number of sites I am now overwhelmed with the amount of study material. There are hundreds of sites offering exam training, others offering braindumps and others selling practice tests.
Does anyone know the best place to start and what material will get me up to speed the quickest. (Time is of the essence and I cannot afford to pay for training)
Any advice would be appreciated.
Simon
MCDBA Certification: Exam 70-228
Feb 6, 2004I'll be taking this test and was hoping for some input, please.
1. How long is it ?
2. Anything in particular I should look out for ?
3. Should you only spend a certain amount of time on each question ?
4. Any place I can find any coupons for the heavy $125 fee ?
5. What company did you sign up through ?
6. Any other input, would greatly be appreciated !!
Thank you
SQL Server 2005 Certification
May 14, 2007Hi has anyone taken the SQL Server 2005 Certification test yet???
View 5 Replies View RelatedMicrosoft Certification Test 70-229
Jul 20, 2005Pls Help if somebody has taken this test...70-229(MS SQL Server 2000)I want to pass this desperately.Pls suggest some good question banks.
View 1 Replies View RelatedCommon Criteria Certification
Dec 18, 2006I see that part of SP2 is the new CC certification -- can anyone give me some more details. What level is it at? EAL4? I can't seem to find the certificate on the CC Web site but it could be because it's not SP2 yet.
View 3 Replies View RelatedAny Certification In Ssrs 2000
Jul 2, 2007Hi all,
Is it any Microsoft certification is there for Sql Reporting service ,If is there means please send me the related link to me!!!
Regards,
P.Veera Vinod.
SQL Server 2005 Certification
Oct 6, 2007I am new to SQL Server 2005. What is the best certification to start with? What training resources should I use?
View 3 Replies View RelatedAbout Microsoft SQL Server Certification Exam
Jun 24, 2006Hi all,
Is there any On-line Resource available to prepare for Microsoft SQL server Certification Exam . Or from which site i can get the Dump?
Regards
Magesh