More of the same with the next Expert Performance Indexing for SQL Server book giveaway. So far, I've sent out six copies of the book based on comments from the past six (1, 2, 3, 4, 5, and 6) posts. I've made a small change to the title of the series (week vs. part), mainly because getting a kid off to … Continue reading SQL Server Indexing Book Giveaway – Part 7
SQL Server Indexing Book Giveaway – Week 6 (Index Myths)
And now for something not so different with week 6 of the Expert Performance Indexing for SQL Server book giveaway. So far, I've sent out five copies of the book based on comments from these (1, 2, 3, 4, and 5) posts. Expert Performance Indexing for SQL Server is a book I co-wrote with Grant Fritchey (Blog | @gfritchey) last summer, which … Continue reading SQL Server Indexing Book Giveaway – Week 6 (Index Myths)
SQL Server Indexing Book Giveaway – Week 5
It's time for week 5 of giving out some copies of Expert Performance Indexing for SQL Server. So far, I've sent out four copies of the book based on comments from those posts. You can find the previous weeks' posts to review those topics here: 1, 2, 3, and 4. Expert Performance Indexing for SQL Server is a book … Continue reading SQL Server Indexing Book Giveaway – Week 5
SQL Server Indexing Book Giveaway – Week 4 (the late edition)
So... it's Saturday night and I missed getting this out on Friday morning... But, in past three weeks' posts (1, 2, 3), I talked about how I've got a few copies of Expert Performance Indexing for SQL Server to give away. This is a book that I co-wrote with Grant Fritchey (Blog | @gfritchey) last summer, which I think … Continue reading SQL Server Indexing Book Giveaway – Week 4 (the late edition)
SQL Server Indexing Book Giveaway – Week 3
In past two weeks' posts (1, 2) I talked about how I've got a few copies of Expert Performance Indexing for SQL Server to give away. This is a book that I co-wrote with Grant Fritchey (Blog | @gfritchey) last summer, which I think can be a valuable resource to anyone building indexes on SQL Server. To give … Continue reading SQL Server Indexing Book Giveaway – Week 3
How To Get A Free SQL Server Indexing Book – Week 2
Free Book! Another free indexing books, more awesome! In last week's post, I talked about how I've got a number of copies of Expert Performance Indexing for SQL Server; that I co-wrote with Grant Fritchey (Blog | @gfritchey). Since these books don't help anyone sitting on my desk, I'm giving them away over the next … Continue reading How To Get A Free SQL Server Indexing Book – Week 2
Book Review: Sapiens: A Brief History of Humankind
Sapiens: A Brief History of Humankind, by Yuval Harari, made it on my reading list after hearing about Mark Zuckerberg's list of books everyone should read. And since then, I've seen other recommendations for reading it, such as the recommendation from Bill Gates. Having now read Sapiens, I'm recommending people read it as well. Sapiens … Continue reading Book Review: Sapiens: A Brief History of Humankind
How To Get A Free SQL Server Indexing Book – Week 1
Free indexing books, awesome! Before I tell you how, lets start with what we are talking about here. If you weren't aware, last summer I worked with Grant Fritchey (Blog | @gfritchey) to update Expert Performance Indexing for SQL Server. The new edition jumps from 10 to 15 chapters and contains a bunch of new … Continue reading How To Get A Free SQL Server Indexing Book – Week 1
Why Do I Write? And Should I Continue?
It's been about six months now since my career to a sharp right turn. At the request of my kids, I left a decade of consulting for a role as a full-time work in as a database architect with a financial services company. Since this change, I've spent a lot of time evaluating what I … Continue reading Why Do I Write? And Should I Continue?
Using SELECT INTO with UNION Statements
On occassion, I need to take a number of different result sets and combine them into a single output, which I then want to store in a temporary table. I've done this while developing solutions for business needs and when analyzing performance for different environments. Sometimes I just need to store stuff. What makes this … Continue reading Using SELECT INTO with UNION Statements
Strate SQL 