Archives: August 2011
Today I am going to revisit two posts from the past couple of weeks. I want to revisit them just to make some minor updates and clarifications. This is nothing earth-shattering but is good info to have.
The two posts to revisit are:
The particular case I was working on was focused on the decimal datatype, and so we… Read more
Since posting that last article on my work on that script,… Read more
SQL Saturday 94 in Salt Lake City is fast approaching. Will you be there? I submitted three sessions in hopes of maybe getting one selected. Last year, I only submitted one at the inaugural SLC SQLSaturday. I even blogged about my experiences with that one (here and here Read more
Some time ago, I wrote an introductory post about bitwise operations in SQL Server. I had fully intended on writing a follow-up to that. Alas the opportunity has passed for the idea I was working on back then.
As luck would have it though, I encountered a new opportunity to… Read more
By now, you have heard of subqueries. You have also heard of Common Table Expressions. I am sure you know what a derived table is and that you get a derived table through either a subquery or CTE. How familiar are you with the subquery flavor of a derived table… Read more
I am a big Sudoku fan. Typically if I need a break, I will break out a Sudoku puzzle from any of a number of different sources (Websudoku, Android Apps, Puzzle Books). Over time, I have come across a solution here or there to solve these puzzles… Read more
I don’t do much with Oracle – at all. Once in a blue moon, I find a little project to do that might involve Oracle. I have never put a lot of thought to the differences between SQL and Oracle. On the pet project I am doing right now, I… Read more
With SQL Server 2005, Microsoft improved the methods available for DBAs to send email from SQL Server. The new method is called Database Mail. If you want to send emails programmatically, you can now use sp_send_dbmail. You can read all about that stored procedure here.
What I am really… Read more
Call me a slacker. I have been postponing registering for Summit 2011. I wanted to be sure that I had the week available in order to attend.
I finally did it! I registered for Summit 2011. I was stoked about it too. Then I got the schedule for my sons’… Read more
Adam Machanic is hosting this month. He thought it would be a good idea to poke and prod us while getting us to torture ourselves.… Read more
Last month I published an update to my Foreign Key Hierarchy script. Today, I am providing a new update for that script. A friend (Rémi Grégoire) helped out with some mods to this script. The change for this month is nothing too intrusive. The script is now updated for those… Read more
I recently published a post about the upcoming meeting for S3OLV. This post is to serve as an update to the post. It is quite important that a more accurate abstract be shared concerning the presentation that will be given.
So, here is the update on that abstract and hopefully… Read more
Have you ever found yourself in need of exporting all of the reports from a Report Server? I have found myself in need of extracting all RDLs from a Report Server on more than one occasion. Reporting Services 2008 would rather have you do that in a rather monotonous and… Read more
Hey Yo!! We are primed and ready for this month down in Las Vegas. We have a return presenter and we are looking to get some speed freak on with our TSQL Code.
From the Invite – one would see these notes:
This month we have a new feature we… Read more
Interesting topic this month posted by Thomas LaRock. This month he has chosen “crap code” as the topic. I think it is interesting because there really are so many different ways to take this.
Knowing that there are so many qualifications for crap code, I personally like that… Read more