Month: October 2012

Unleashing Common Table Expressions

On the next two Saturdays I will be presenting the Unleashing Common Table Expressions presentation at SQL Saturday 172 in Portland Oregon, and SQL Saturday 166 in Olympia Washington. As part of refreshing the presentation I have added a few

Tagged with: , , , ,

TSQL Rounding or Truncating DateTime to Nearest Day, Hour, Minute or Second

One thing that I end up having to look search on regularly is rounding of dates and times in Transact SQL, having looked this up too many times I finally realized that it is time for me to do my

Tagged with: , ,

Using a CTE in a Function to Split Up a Database Connect String

I came across this example when preparing my CTE presentation for SQL Saturday in Portland OR in 2 weeks. Which produces the following output.

Tagged with: , , , ,

Database Health Reports – Historic Waits Report Sneak Preview

Coming in the next beta of the Database Health Report is a new feature called the Historic Reports which installs a small database to track database statistics over time.  This has an extremely light load on the overall database performance,

Tagged with: , , , ,

Recursive CTE to Calculate Dates for the Last 30 Days

Have you ever needed to generate a list of dates for the last 30 days.  There are lots of different ways to do this with TSQL, but one way is with a CTE, where you can then left join against

Tagged with: , , , , ,

Adventureworks2012 data to Google GeoChart Visualization

There are so many cool tools available today for data visualization.   This posting covers pulling data from the AdventureWorks2012 database running on SQL Server 2012, and then using the Google Visualization tools to display geographic data. The final outcome

Tagged with: , ,

2 Sessions Accepted for SQL Saturday 166 in Olympia Next Month.

I just found out that two of the sessions that I proposed for SQL Saturday #166 in Olympia next month have been accepted.  These presentations are: Exploring TSQL Enhancements in SQL Server 2012 Unleashing Common Table Expressions in SQL Server These are

Tagged with: , ,

Added a TSQL Wiki

Today I created a TSQL Wiki.  There is not much there yet, but over time it will grow. The wiki address is:

Bellingham has switched from summer to winter.

In the Pacific Northwest theme of 2 seasons, the weather shifted from Summer weather to Winter weather yesterday and today.  Its official Bellingham WA is now in the wet season.  It was a good summer.

Tagged with:

Now that Database Health Beta 2 is out, whats next…

Now that Beta 2 of the Database Health Project is out, and people are using it, I am going to focus my attention on 2 areas. Fixing any bugs that are reported in Beta 2 of the Database Health Project. Adding

Tagged with: , , ,