Happy Pi Day

by Jason S, posted in Geek, Off Topic

Sometimes you have to be this geeky.  Here’s a Pi Pie for Pi Day… If you aren’t hungry… here’s another slice of Pi 3.141592653589793238462643383279502884197169399375105820974944592307816406286208998628034825342117067982148086513282306647093844609550582231725359408128481117450284102701938521105559644622948954930381964428810975665933446128475648233786783165271201909145648566923460348610454326648213393607260249141273724587006606315588174881520920962829254091715364367892590360011330530548820466521384146951941511609433057270365759591953092186117381932611793105118548074462379962749567351885752724891227938183011949129833673362440656643086021394946395224737190702179860943702770539217176293176752384674818467669405132000568127145263560827785771342757789609173637178721468440901224953430146549585371050792279689258923542019956112129021960864034418159813629774771309960518707211349999998372978049951059731732816096318595024459455346908302642522308253344685035261931188171010003137838752886587533208381420617177669147303598253490428755468731159562863882353787593751957781857780532171226806613001927876611195909216420198938095257201065485863278865936153381827968230301952035301852968995773622599413891249721775283479131515574857242454150695950829533116861727855889075098381754637464939319255060400927701671139009848824012858361603563707660104710181942955596198946767837449448255379774726847104047534646208046684259069491293313677028989152104752162056966024058038150193511253382430035587640247496473263914199272604269922796782354781636009341721641219924586315030286182974555706749838505494588586926995690927210797509302955321165344987202755960236480665499119881834797753566369807426542527862551818417574672890977772793800081647060016145249192173217214772350141441973568548161361157352552133475741849468438523323907394143334547762416862518983569485562099219222184272550254256887671790494601653466804988627232791786085784383827967976681454100953883786360950680064225125205117392 Also, don’t forget about Daylight Savings if you are one of the those afflicted by this change in the time zone.

Grouping and Rounding Dates

by Jason S, posted in SQL Server, SQL Server 2000, SQLServerSyndication, T-SQL, Tip

Ever need to group dates and round them to intervals?  I had this exact need for a report on wait stats I was working on for an upcoming post.  I wanted the flexibility to be able to group a list of dates by either minute, hour, date, etc.  And then also round those dates within … Continue reading Grouping and Rounding Dates

Please, no TRIM()?

by Jason S, posted in Performance Tuning & Tracing, SQL Server, SQL Server 2000, SQLServerSyndication, T-SQL, Tip

A couple weeks back I was asked “How come Microsoft has yet to put TRIM() in SQL?” I don’t really know why there isn’t a TRIM() function in SQL Server. There is an LTRIM for function removing leading spaces. And an RTRIM function for removing trailing spaces. But there isn’t a TRIM function. Let’s be … Continue reading Please, no TRIM()?

Webcast: High Availability Through SQL Server

by Jason S, posted in High Availability

Looking for an introduction into the different high availability technologies available in SQL Server?  Check out this webcast that I recorded for SSWUG.  It’s being made available on Feb 24th and covers the following: With failover clustering, data mirroring, peer-to-peer replication, and log shipping available there is an option or two for every scenario. While … Continue reading Webcast: High Availability Through SQL Server

SQL Saturday 32 — ABCs of CTEs Deck

by Jason S, posted in Community and Conference, Performance Tuning & Tracing, SQLServerSyndication, T-SQL

I’d like to thank Pam Shaw (twitter as @pamshaw) and Jorge Nunez (twitter as @sqlchicken) for letting me come down to Tampa this past weekend to present at SQL Saturday #32.  Jeez, that picture doesn’t make me look very happy.  For someone like me that tends to forget to take time off, this is a … Continue reading SQL Saturday 32 — ABCs of CTEs Deck

Speaking at Tampa SQL Saturday

by Jason S, posted in Community and Conference, SQL Server, SQLServerSyndication, T-SQL

I've been selected to speak at the Tampa SQL Saturday coming up at the end of January. I'm a bit pumped to be going down there since I woke up this morning to below zero weather for yet another day. Not that I'm complaining, but my feet could definitely use a little bit of heat. … Continue reading Speaking at Tampa SQL Saturday

Wait Stat Categories

by Jason S, posted in Database Administration, DBADiagnostics, Performance Tuning & Tracing, SQL Server, SQLServerSyndication, Wait Stat, Wait Type

A few weeks ago I posted a job that I use to track wait stats in the DBA database that I bring to a number of clients.  I had promised to follow-up with a couple or three reports that could be used to monitor the values that were being aggregated in those tables. Before getting … Continue reading Wait Stat Categories

Pushing Excel Through A Wormhole

by Jason S, posted in Business Intelligence, SharePoint, SQL Server, SQL Server 2008 R2, SQLServerSyndication

With the next release of SQL Server, data analysis is going to go through a major change with the PowerPivot add-in for Excel and SharePoint.  If you haven’t been keeping up with these changes to Business Intelligence, SSWUG.org has an opportunity for you to get up to speed.  On January 22, 2010 there will be … Continue reading Pushing Excel Through A Wormhole

MCM Reading List – A New Years Resolution

by Jason S, posted in Certification, SQL Server, SQLServerSyndication

I’ve blogged about certifications a number of times in the past.  One of the certifications that I really want to obtain in the future is the Microsoft Certified Master (MCM) for SQL Server 2008.  This is a great certification that really dives in deep and requires classroom training and labs as part of the certification … Continue reading MCM Reading List – A New Years Resolution