SQL Saturday #172 in Portland Oregon
Its going to be a great day! Ready for SQL Saturday 172 in Portland today, looking forward learning lots, and sharing my CTE Presentation… Read More »SQL Saturday #172 in Portland Oregon
New Logo for Me
Here is my new logo for my SQL Saturday sponsorship.
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