Register Now: SSWUG.org Free Expo Event This Friday 9:00 a.m.
In the sessions at this free expo, you’ll learn about query plans and the types of information and tuning help they can provide, numerous monitoring and performance management options and much more. We’ll also be presenting sessions that include information about key setup and operations items for your SQL Servers.
> Register here.
Ben Taylor and SSWUG.ORG
As I’m sure you’ve noticed, Ben has joined the team here at SSWUG.ORG and both he and I will be sharing the overall writing for newsletters. I’m excited about Ben’s involvement; it brings new perspectives, new ideas and some great experience (his!) to the mix.
There will be days where it’s both of us, days where it’s only one of us. We’ll keep it interesting and applicable and always try to give you something to think about for the day. As always, if you have ideas, suggestions, feedback and what-no, just drop us a note:
Ben Taylor – btaylor@sswug.org
Stephen Wynkoop – swynk@sswug.org
We’re here to help, share your real-world experiences and hopefully provide a consistent stream of thoughts, tips, tricks, feedback, trials and tribulations.
Welcome aboard Ben!!!
The Language of SQL
I remember when I first started learning how to write SQL. I found books in the library (yes, you went to a library in those days) and found a book with SQL Syntax. MS SQL wasn’t even released at that time. In fact they hadn’t even started porting SYBASE to OS2.
One of the things I remember was that the book taught SQL with a how to approach. It didn’t walk through the key words like our online help. Online help works great for someone who already knows the language and is looking for syntax; but, for someone trying to learn a new language it is quite painful.
Well, there is a new book just released written with the same approach. The book is titled The Language of SQL (follow the link to Amazon) and comes in both paperback and Kindel. You can read this book without a computer to try things out. It teaches you how to understand the concepts and syntax of SQL. The author, Larry Rockoff, even demonstrates syntax for MS SQL, MySQL and Oracle.
So, for those of you who are developers trying to get a grasp of this database thing, or who have been thrown to the wolves to help with database systems, this book might be for you. I’ll get a copy myself and drop a note for our readers with a bit of a review.
For the rest of us I guess it’s just SQL For Smarties.
Drop me a note with your good reads. I’d like to compile a list and put it online for our readers. Send your comments to btaylor@sswug.org.
Cheers,
Ben
Featured White Paper(s)
Automating DBA Processes for Microsoft SQL Server
Want to save time, reduce errors, get things done without you doing them and standardize preventative maintenance of your SQL… (read more)
Featured Article(s)
New Features in Entity Framework 4
ADO.NET Entity Framework, an extended Object Relational Mapping (ORM) tool from Microsoft promises to be the technology of choice for the next generation of data access using ADO.NET. The primary objective of the ADO.NET Entity Framework is to objectify your application’s data – add a level of abstraction on top of the relational model. In raising this level of abstraction, you can isolate the logical model of your application’s data from the relational model. ADO.NET Entity Framework ships with Visual Studio 2010 and offers a lot of new and exciting features and enhancements. This article discusses the new features and enhancements in Entity Framework 4.