This month, Robert Pearl is helping to host a Performance Story contest. The contest is being sponsored by Safe Peak, and you can see more about it – here. The timing on this contest actually […]
Tag: SQL
T-SQL Tuesday #22 – Data Presentation
Data Presentation is not just about the look of a report. Data Presentation involves performance, accuracy, display and the business requirements. By giving proper attention to each of these facets, the Data presented will be both remarkable and acceptable to the end-user.
Bitwise and Derived Table revisited
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 […]
Bitwise Operations
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 […]
Derived Table Column Alias
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 […]
Top 5 Oracle Nuances I learned Today
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 […]
SSRS Export En Masse
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 […]
T-SQL Tuesday #18 – CTEs
To CTE or not to CTE, that is the Question So my post really has nothing to do with the title. This is not a post to help you determine whether a CTE is appropriate […]
Meme Monday – “I got 99 problems but a disk ain’t one”
Today is Meme Monday and is a little thing that Thomas LaRock (Blog | Twitter) has started. Today he has started things off with a list of things that could cause a Database to go […]
A SQL Experiment – Mentoring
News Flash The SQL Community is about to get stronger. Why? There is a great new initiative that was recently launched. Steve Jones and Andy Warren are teaming up to conduct this initiative. As they […]