Category Archives: SQLServerPedia Syndication
Cleaner Code in T-SQL (Part 1 – Naming Stored Procs & Views)
As some of you know I kinda blur the lines between DBA and Dev. It kind reminds me of that half-white/half-black painted guy on that old Star Trek episode sometimes. In any case, to satisfy my Developer “dark side” cravings I’ve been reading an excellent book called “Clean Code” by Robert C. Martin. This book… Read More »
Studying for 70-453: MCITP Upgrade Exam
Over the past couple weeks now I’ve been studying to upgrade my MCITP certification in SQL Server 2005 to 2008. I was surprised to find that there are basically no books/study materials out there for this. Now I know that most DBAs taking this exam live and breathe SQL Server every day and for them… Read More »
Getting Started with SQL Nexus
If your shop is anything like mine SQL Server is the first to blame when something goes wrong. So what can you do? BASELINE! Kevin Kline (blog | twitter) says it best “How do you know what’s abnormal unless you know what’s normal?” Now there are a lot of third party tools that can do… Read More »
SQL Saturday #67: There and Back Again
This SQL Saturday was a star-studded cast of speakers and a host of enthusiastic attendees. This was by far one of the biggest SQL Saturdays I’ve been to with over 300 people in attendance. For me things started off right in Tom LaRock’s (blog | twitter) “Performance Made Easy” talk. Between trading verbal jabs with… Read More »
SQL Saturday #67: Beginnings [pre-con]
Well, I made it. After a long trek through Nebraska, Iowa, and part of Illinios I arrived early into Warrenville and to the Quest offices for Kevin Kline’s (blog | twitter) pre-conference on Performance Tuning & Troubleshooting. Kevin ran us through his “Rocks, Gravel, and Sand” methodology. This is an approach by which you take… Read More »
7-zip Backup Compression for SQL Server Standard
We have a vendor right now that periodically requests a backup file FTP’d to their server. Unfortunately we do not run the Enterprise version of SQL Server to be able to compress the backups, and nobody wants to manually take a backup file and compress it on a regular basis. Because of this I created… Read More »
T-SQL Tuesday #16: PIVOT
First of all a big thanks to Jes Borland (Twitter | Blog) for hosting this month’s T-SQL Tuesday (#16) topic about aggregate functions. Ok. So it’s not *really* an aggregate function, but it uses them and it does aggregate. Yes, I am talking about the PIVOT function in SQL Server 2005+ that’s near and dear… Read More »
SQL Saturday #66
Since the event was to be held at Mr. Biggs Family Fun Center my wife and I decided to make a day of it and pack up the kids and head down to Colorado Springs for SQL Saturday #66. We began the day early and hit the road at 6am to get down there. At… Read More »
Back to Basics: Why Stored Procedures?
A simple explanation is a stored procedure is a bit of T-SQL code that can take input parameters and is intended for use in queries that are regularly executed against SQL Server. It is “stored” within the database engine (hence the name). I’m not going to cover all of the benefits here, but I wanted… Read More »
