Adam Machanic, Boston-based independent database consultant, writer, and speaker, shares his experiences with programming, performance tuning, and optimizing SQL Server 2000, 2005, and 2008, in conjunction with related technologies such as .NET.
Browse by Tags
All Tags »
T-SQL Tuesday (RSS)
-
There I was. A freshly printed bachelor's degree in Computer Science tucked under my arm, I walked into my First Real Job. I'd never touched the technologies I was going to work with--ASP 3.0 and SQL Server--but my employer knew that, and I figured I'd Read More...
|
-
“This ugly hack is only temporary,” you think. Six months later, a coworker curses your name, sacrificing a chicken to any deity that will help expedite your getting struck down by lightning, a school bus, or both. Crap code. We’ve all seen it. We’ve Read More...
|
-
Just over a year ago I kicked off T-SQL Tuesday , "a recurring, revolving blog party." The idea was simple: Each month a blog will host the party, and about a week before the second Tuesday of the month a theme will be posted. Any blogger that wishes Read More...
|
-
Apologies for the late reminder; tomorrow is T-SQL Tuesday. This month's event is hosted by Robert Davis over at SQL Server Central and the theme is "Gettin' Schooled." How do you learn? Or how do you teach? Have you learned anything interesting recently Read More...
|
-
Just a quick note for those of you who may not have seen Michael Coles's post (and a reminder for the rest of you): The topic of this month's T-SQL Tuesday is LOB data . Get your posts ready; next Tuesday we go big! Read More...
|
-
Reports. They're supposed to look nice. They're supposed to be a method by which people can get vital information into their heads. And that's obvious, right? So obvious that you're undoubtedly getting ready to close this tab and go find something better Read More...
|
-
This month's T-SQL Tuesday is hosted by Aaron Nelson of SQLVariations . Aaron has picked a really fantastic topic: Reporting . Reporting is a lot more than just SSRS. Whether or not you realize it, you deal with all sorts of reports every day. Server Read More...
|
-
Hey bloggers! Wake up and get your favorite editor ready. T-SQL Tuesday is back again, this time with a great topic hosted by Mike at StraightPath Solutions . Stop reading this blog and go read his. And then post! As I mentioned to a few Indian MVPs at Read More...
|
-
According to T-SQL Tuesday rules as ratified by me in the first and second T-SQL Tuesday posts, the T-SQL Tuesday host is supposed to post a roundup within two days of the end of the event. So a reasonable person should expect a roundup to be posted by Read More...
|
-
The query optimizer is a finicky thing , and sometimes it doesn't understand exactly what you're trying to do until you give it a bit more information. The situation I'm going to describe in this post is one such case. By providing the optimizer with Read More...
|
-
Welcome to the second installment of T-SQL Tuesday, the monthly SQL Server blog party! Last month's kickoff event was a great success , and I'm really excited for this month's theme. I hope that we see even more bloggers, with even more great posts this Read More...
|
-
When working with time intervals, we often want to ask a couple of basic questions: Which time periods are not covered by our intervals? These are known as "gaps". What are the time ranges that we are fully covering? These are known as "islands". If you're Read More...
|
-
T-SQL Tuesday is the SQL Server blogosphere's first recurring, revolving blog party . The idea is simple: Each month a blog will host the party, and about a week before the second Tuesday of the month a theme will be posted. Any blogger that wishes to Read More...
|