SQL Server 2012 – Articles (Denali)
–> SQL Server 2012 Certification Path
– Exam 70-461: Querying Microsoft SQL Server 2012
– Exam 70-462: Administering MS SQL Server 2012 Databases
– Exam 70-463: Implementing a Data Warehouse with MS SQL Server 2012
–> New Features in SQL Server 2012 (aka Denali)
– The Fantastic 12 of SQL Server 2012
– Use new TRY_PARSE() instead of ISNUMERIC()
– CONCAT() & FORMAT() functions
– OFFSET-FETCH Clause and Pagination
– Enhanced OVER() Clause – Part 1, Part 2
– Temp Tables are created with negative Object IDs
– Using FileTables to store your files and docs
– Using FullText search with FileTables in SQL Server 2012
– New THROW statement in SQL Server 2012 (vs RAISERROR)
– Another reason to use THROW clause instead of RAISERROR
–> Behavior Changes:
– With IDENTITY property in SQL Server 2012
– Temp tables are created with negative object IDs
–> Depricated Features:
– SQL Server 2012 does not support Linked Server to SQL Server 2000
– SET FMTONLY ON/OFF | New SPs and DMFs introduced in replacement
–> SQL Server 2012 Upgrade:
– Technical Guide and Why Upgrade
–> My YouTube videos on SQL Server 2012:
Hi Manoj,
Could you please help me how to handle the the space in the sheet value ( Budget Administrative Code in the following example)
SELECT *
FROM OPENDATASOURCE(‘Microsoft.ACE.OLEDB.12.0’,
‘Data Source= C:\testing Country.xlsx;
Extended Properties=”Excel 12.0″‘)…[Budget Administrative Code$];
What do mean by space in sheet value & how do you want to handle it?
Can you please explain.
how to use vb function to sql query function
ex:
function emp()
str=”select * from employ”
set rs=conn.execute(str)
do while rs.eof=false
for i= 1 to 6
if sex=’m’ then
update status=’male’ where empcode=’1000′
else
update status=’female’ where empcode=’1000′
next
loop
end function
Check this:
UPDATE employ
SET status=’male’
WHERE sex=’m’
and where empcode=1000
UPDATE employ
SET status=’female’
WHERE sex’m’
and where empcode=1000
I am planning to prepare for SQL 2012 certification (Business Intelligence). Could you give me some idea how to setup the lab environment to cover 40-461, 462, 463, 466 & 467.I do not have access to server machines, so it would be good if you can provide me some info about simulating the environment using my desktop machine.
Thanks.
Sorry @Mayank for replying so late on your comment.
You can install the Express Edition of SQL Server 2012 on your Desktop machine and start practicing for test tests.
Check this link for complete Certification Path: https://sqlwithmanoj.wordpress.com/2013/11/06/sql-server-2012-certification-path/
Hi Manoj,
Ur website is having lot information.But i am new to work with sql server 2008 R2 and newly learning T-sql.. Could you please suggest me some books or some links where i can refer..
Thanks
Hi @Nikki, as you said you are new to learning T-SQL, so start with the latest version of SQL Server, i.e. 2012. You can check the basic Certification book for SQL Server 2012, check this link: https://sqlwithmanoj.wordpress.com/2012/11/16/passed-70-461-exam-querying-microsoft-sql-server-2012/
For books you can refer to: http://www.amazon.com/Microsoft-Server-2012-T-SQL-Fundamentals/dp/0735658145/ref=sr_1_3&tag=651998669-20
and: http://www.amazon.com/Training-Kit-Exam-70-461-Microsoft/dp/0735666059?tag=651998669-20
Hi Manoj,
I am writing to explore some volunteer opportunities in SQL Server. I have been unemployed for more than a year due to some visa issues. I am trying my best to get hands-on experience in T-SQL programming or Microsoft BI field while I am unemployed. Any inputs in finding online volunteer work related to SQL. I am also preparing for Exam 70-461 and would take the exam pretty soon.
I would greatly appreciate your inputs in this regard.
@Poonam, thanks for writing to me and I really appreciate your dedication towards technology.
As far as Volunteer work is concerned I’m not aware of any, but you can dedicate your time and knowledge on answering Questions on various forums like MSDN TSQL, SQLServerCentral, StackExchange, which will also let you learn new things and clear your doubts.
Also you can start your own blog like this or volunteer by writing blog posts on beyondrelational, codeproject, etc. blogging forums.
For preparing 70-461 you can check my blog post: https://sqlwithmanoj.wordpress.com/2012/11/16/passed-70-461-exam-querying-microsoft-sql-server-2012/
~Manoj
Hi manoj could you please suggest me solution for the error ” the given key was not present in the dictionary ” during installation of sql server 2012 Std edition.
Thanks in Advance,
Mangesh.
Hi, am simon.
please i dearly need your help.
i am very familiar working with RDBMS, have a very solid foundation on Relational Databases, SQL standard language and T-SQl. i have a solid background knowledge working MS SQL Server. i have great interests getting certified for the 70-463 exams.
i have very few video tutorials to assist me.
please can you email me a soft copy of your
TRAINING KIT(EXAM: 70-463): Implementing a Data Warehouse with SQL Server 2012/2014.