I was recently asked to append some leading zeros to a column in a data set. I found one solution which was quick and simple....
Posts by Author [ davejenkins ]
WhoIsActive
I thought that I would just share a little stored procedure that I've been using in my day job since becoming an accidental DBA! It's the WhoIsActive stored procedure by Adam Machanic. This stored procedure pulls together ALOT of information... Read More
Index Rebuild or Index Reorganize
You've just discovered that your indexes are fragmented, so you decid to do something about it. You know you need to do something to your indexes, but you're stuck wondering what the difference is between REBUILD and REORGANIZE.
...
T-SQL Divide by Zero Error
Someone in my day job this week asked me how to deal with Msg 8134, Level 16, State 1, Line 3 Divide by zero error encountered error that they were receiving. It's second nature for me to add the below...
Read MoreHow to find the expiry date for SQL Server 2012 Evaluation
Did you install SQL Server 2012 Standard Edition for evaluation purposes on your PC and forgot to write down when your six months is up? Yep, you're right, I'm talking from experience here! So I needed some T-SQL magic to...
Read MoreBeginning SSRS – Part 3 Datasources and Datasets
The third part of our Beginning SSRS series. An important lesson covering the embedded and shared datasources and datasets, as these are the bedrock for all...
Read MoreBeginning SSRS – Part 2 Basic expressions / Conditional Formatting
This is the second video in our Beginning SSRS Series. In this video we show you how to carry out basic expressions to change font colours, font weights, alternating row...
Read MoreBeginning SSRS PT 1 – Our first report
This is the first video in a series entitled "Beginning SSRS" - we are going to show you how to start with the basics of SSRS and work our way through to more advanced SSRS topics. If you want to...
Read MoreDynamic date range based on todays date
I had the challenge of putting together a T-SQL statement that's going to be used in a few stored procedures. The stored procedures will build data based on what todays date is, if today is greater than second Tuesday of...
Read MoreInstalling AdventureWorks 2012 & Chinook databases
Here's a little video on installing the AdventureWorks 2012 & Chinook databases, we're going to be using them in future videos. The video is intended for new SQL Developers or DBA's that haven't had much experience in installing databases before.