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… Read More »Unleashing Common Table Expressions
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… Read More »TSQL Rounding or Truncating DateTime to Nearest Day, Hour, Minute or Second
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.
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… Read More »Database Health Reports – Historic Waits Report Sneak Preview
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… Read More »Recursive CTE to Calculate Dates for the Last 30 Days
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… Read More »Adventureworks2012 data to Google GeoChart Visualization
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… Read More »2 Sessions Accepted for SQL Saturday 166 in Olympia Next Month.
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: http://tsql.SteveStedman.com
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… Read More »Bellingham has switched from summer to winter.
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… Read More »Now that Database Health Beta 2 is out, whats next…