This is the 1st post out of my 10 post series of my 10th book – SQL Basics. Today will show the importance of data and information.
SQL SERVER – Puzzle #1 – Querying Pattern Ranges and Wild Cards
Note: Read at the end of the blog post how you can get five Joes 2 Pros Book #1 and a surprise gift. I have been blogging for almost 7 years and every other day I receive questions about Querying Pattern Ranges. The most common way to solve the problem…
Read MoreSQL SERVER – New SQL Server 2012 Functions – Webinar by Rick Morelan
My friend Rick Morelan is a wonderful speaker and listening to him is very delightful. Rick is one of the speakers who can articulate a very complex subject in very simple words. Rick has attained over 30 Microsoft certifications in applications, networking, databases and .NET development, including MCDBA, MCTS, MCITP, MCAD,…
Read MoreSQL SERVER – XML Data Type- SQL Queries 2012 Joes 2 Pros Volume 5 – XML Querying Techniques for SQL Server 2012
This chapter is abstract from the Beginning SQL 2012 – Joes 2 Pros Volume 5. Book On Amazon | Book On Flipkart Kit on Amazon | Kit on Flipkart Why buy this Book: SQL is full of relationship data with one to many relationships and so is XML. The Marriage between XML and SQL…
Read MoreSQL SERVER – Executing Dynamic SQL – SQL Queries 2012 Joes 2 Pros Volume 4 – Query Programming Objects for SQL Server 2012
This chapter is abstract from the Beginning SQL 2012 – Joes 2 Pros Volume 4. Book On Amazon | Book On Flipkart Kit on Amazon | Kit on Flipkart Why buy this Book: As you get further into SQL you will discover areas you like more than others. Maybe your good at queries or…
Read MoreSQL SERVER – Introduction to GUIDs – SQL Queries 2012 Joes 2 Pros Volume 3 – Advanced Query Tools and Techniques for SQL Server 2012
This chapter is abstract from the Beginning SQL 2012 – Joes 2 Pros Volume 3. Book On Amazon | Book On Flipkart Kit on Amazon | Kit on Flipkart Why buy this Book: We often learn good practices from the people that come before us. Sometimes we later learn why those practices make sense.…
Read More
SQL SERVER – Identity Fields Review – The SQL Query Techniques Tutorial for SQL Server 2012
In this blog post we are going to learn about Identity Fields Review.
Why buy this Book: The beta of this book actually existed for a year and was tested and used in my classroom. Its purpose back then was to help the students do the steps individually that led to the skills where they could all pass the Microsoft test. It worked and then many went out for their SQL interview. They did good enough to get the job, but they told me about one or two questions they were not able to answer. A year of collecting this data and turning them into lessons doubled the size of this book of 300 pages to 600 pages. This book is designed to make the query question and query skills in the professional work must seem easier. Let us learn about Identity Fields Review.