A couple days ago I was playing around with some Event Notifications and the Certificate that I’d created for them on my development machine. Low and behold I’d made a classic mistake and forgotten to write down the password for the certificate. Thus I was left without a critical component necessary for signing my procedures. … Continue reading Getting Rid of a Certificate
Part of being in the technology industry requires a constant dedication to learning. The world is a constantly changing place and the things you know today aren’t going to be cutting edge tomorrow. Those that stay in place and don’t change with the times can sometimes appear to be zombies. Just drooling along from one … Continue reading Free Brains… I Mean Beta Exams
Last week I presented at the March Minnesota SQL Server User Group (PASSMN) meeting on using CTEs in SQL Server. The session is meant as an overview and introduction to CTEs with some examples of their use and what some of the effects can be. Overall the session was well received and I got the … Continue reading ABCs of CTEs at PASSMN
Every now and then I work with people that just use the default trace templates available within SQL Server Profiler. Using the default traces and you end up being limited to just some performance stats on procedures and batches that have completed. There isn't exactly an issue with doing this, except that there is so … Continue reading There Is Much More to Profiler
The SSWUG Spring 2010 Virtual Conference is coming up. On April 7, 8, and 9, attend a conference from the comforts of your living room, office, or couch. And while you are at it you’ll get to sit on on some incredible presentations, interaction with speakers, chat with other attendees, make new contacts, lots of … Continue reading SSWUG Spring ’10 Ultimate Virtual Conference
After setting up backups on a client’s servers, I started to get the error message below each night at approximately the same time. Sometimes on the same database and other times on other database. The only constant appeared to be the time in which the error occurred. Processed 1 pages for database 'MyDatabase', file 'MyDatabase_log' … Continue reading Interesting Backup Failure
A while ago I had read about the hidden threat of forwarded records. These silent killers are like storm troopers in the bush waiting to get you when you least expect it. And then the other day I saw a T-SQL Tuesday post by Sankar Reddy on (blog – twitter) on determining if your SQL … Continue reading Find Tables with Forwarded Records
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.
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
Strate SQL 