Skip to main content

Murach's SQL Server 2008 for Developers

by Bryan Syverson and Joel Murach
22 chapters, 778 pages, 336 illustrations
ISBN: 978-1-890774-51-6

When we published the first edition of this book, we heard from plenty of developers who were just starting out using Microsoft SQL Server and found this to be a great book for training.
But we also heard from a lot of experienced developers who read it and were amazed to discover how much they didn't know about SQL. That's why we've dubbed this book "the SQL book that most developers don't even know they need."
So whether you're new to SQL...or whether you've been squeaking by with the SQL you know, never realizing how much you're missing out on...this is the book for you.

 For example, you'll learn:
  • How to create complex inner and outer joins, summary queries, and subqueries that do more of the database processing for you so that your applications can do less
  • What the different data types are and how to handle the common problems you run into with various types of data
  • How to work with XML data
  • How to take advantage of powerful backend database features like views, scripts, stored procedures, and triggers
  • How to deal with database control features like cursors, transactions, and locking
  • The basics of database design and implementation using the Management Studio or SQL DDL statements (you can write more efficient queries when you know something about how databases are set up…and you can start to see what your DBA has to think about, if that's a career path that interests you)
  • How to use the CLR integration feature to create database objects using C# or Visual Basic code 

What's NEW in this 2008 edition

This new edition now covers the 2008 features that make a developer's job easier:
  • The FILESTREAM storage feature allows you to work more efficiently with binary large objects (BLOBs) such as image, sound, and video files.
  • The MERGE statement allows you to use a single statement to make multiple updates and insertions.
  • The date, time, datetime2, and datetimeoffset data types give you more flexibility and precision for working with dates and times.
  • The user-defined table type allows you to pass a table as a parameter to a stored procedure or a function - a feat that previously required custom coding and often resulted in code that was difficult to maintain.
  • In terms of database design, the SPARSE attribute can help you work with NULL values more efficiently, and filtered indexes can allow you to retrieve data more quickly.
Beyond that, this book covers many other 2008 features that you'll find useful in specific situations. And, of course, the code presented in this book has been thoroughly updated and tested against SQL Server 2008.

Ready to master all of this?

Then let SQL Server 2008 for Developers quickly boost you to a new level of competence and professionalism.



Related Posts Plugin for WordPress, Blogger...

Popular posts from this blog

LG G5 Review In-Depth

Can LG take on the Galaxy S7 with a metal design, dual-cameras and an accessory slot? Here's our first LG G5 review, focusing on LG G5 design and build, LG G5 specs, LG G5 cameras and LG G5 software and apps.
Alongside the Galaxy S7, the LG G5 is one of the biggest phones (not literally) to launch in 2016 – and we're not just talking in the Android world. It's one of the heavyweights and LG will be looking to set the market alight with the G5's alternative and innovative modular design.

2019 BMW i8 Review

The 2019 BMW i8 is a head-turner for its looks, which hides its plug-in powertrain. That’s good or bad, depending on your priorities.Even among six-figure cars with two doors, the 2019 BMW i8 steals stares. That could be because of the dramatic wing doors and futuristic shape, its laser headlights at night, or the 2019 i8’s silent propulsion for up to 18 miles.
Or it may steal attention because, even after more than four years on sale, it’s a very rare sight.

Apple iPhone XR Review

If you aren't sure you are ready to leave the Home button behind and embrace Face ID, think again. We'll tell you why the iPhone XR is worth the sacrifice - especially because it's just as good (if not better than) the iPhone XS. Find out more in out full review.
Should I Buy The Apple iPhone XR?
The iPhone XR brings Face ID to the masses. We’re sure people will continue to rebel against the lack of Home button, but eventually we expect them to come round and embrace the larger screen, Portrait mode (front and back), animoji and memoji.We have no doubt that this will be a popular iPhone and it deserves to be. The only question is why would anyone buy an iPhone XS when the iPhone XR is just as powerful and has a bigger screen.

Google Pixel Review

Not everyone wants a phone with a big screen, but most small-screen phones compromise on performance and cameras. Not so with Google’s latest flagship Android phone: Here’s our Google Pixel review.
Joining the ranks of the Pixel C and Chromebook Pixel are Google’s new Pixel phones. We’re reviewing the smaller 5in Pixel here, but you can read our separate Pixel XL review if you’re after a bigger phone.

BlackBerry KEYone Review

BlackBerry soliders on with a curious Android device that gets nearly everything right. It’s not for everyone though, in fact, it’s not really for anyone. But if you want a physical keyboard you will absolutely love it.
Should I Buy The BlackBerry KEYone?
But then, the KEYone is the best BlackBerry phone for years. It has (finally) successfully melded classic BlackBerry design with the necessary mix of Android and nostalgia. Importantly, the latter is only faint this time – this is a device for 2017, not 2007.If you love your iPhone or Samsung, you’ll hate the KEYone and won’t even consider buying it. But if you’ve made it to the end of this review, chances are you’re weighing up a buy. If you think you’ll love the BlackBerry KEYone, then I’m pretty certain you won’t be disappointed. You’re part of a minority, but finally BlackBerry has a phone for you that doesn’t force you to compromise.

Like Fan Page