T-SQL Tuesday #156–Ready for Production
It’s a busy time for me, but it’s also T-SQL Tuesday blog party day. I’m rushing a bit as I forgot about this (thanks for the reminder, Deb) and...
2022-11-08
26 reads
Testing the code (T-SQL Tuesday #156)
Foreword
Even though I picked the question, I struggled to answer it.
Following my train of thought - production code should be of the highest quality. To enforce quality, we use...
2022-11-23 (first published: 2022-11-08)
280 reads
Deciding to Submit to Conferences–#NewStarNovember
I wrote about getting started last week, with invitations from others. I think the first time I actually made my own submission was to the Indy Tech Fest in...
2022-11-08
37 reads
What is production grade code? : T-SQL Tuesday #156
It’s that time of the month again! It’s T-SQL Tuesday and this month Tom Zika (blog|twitter) is hosting. Tom would ... Continue reading
2022-11-23 (first published: 2022-11-08)
375 reads
Daily Coping 8 Nov 2022
Today’s coping tip is to set a goal that brings a sense of purpose for the coming month. For me, I’m going away from primary work to secondary work....
2022-11-08
18 reads
Tales From The Field Weekly Wrap Up for the Week of 10-31-2022
Hello Dear Reader! Last week was Halloween and I hope you all had a fantastic time. Halloween has long been my favorite holiday. The cost of participation is imagination,...
2022-11-18 (first published: 2022-11-07)
117 reads
Data Manipulation with Word and Excel
Recently I had to go through some training that asked me to evaluate some text. I needed to tally some data up, and decided Word and Excel were quick...
2022-11-18 (first published: 2022-11-07)
422 reads
Daily Coping 7 Nov 2022
Today’s coping tip is to identify three things that give you hope for the future. The creativity and passion of youth The drive from many people who build software...
2022-11-07
18 reads
Moving dates to a weekending date
In publishing, and Im sure many other industries, we get data at both the daily level and the weekly level. To properly tie these two pieces of data you...
2022-11-16 (first published: 2022-11-05)
328 reads
Goal Progress for Oct 2022
I set goals at the beginning of the year, and I’m tracking my progress in these updates during 2022. Another month of busy stuff. Prepping for the Data Community...
2022-11-04
20 reads
Blogs
T-SQL Tuesday #201 Invitation: Temp Tables, Friend or Foe?
By ReviewMyDB
My T-SQL Tuesday #201 invitation. Do temp tables help performance or hurt it? I...
Monday Monitor Tips: The MCP Server
By Steve Jones
I have been experimenting with MCP servers in a few ways, and pressing on...
Programmatic Tool Calling with the Claude SDK
Programmatic Tool Calling with the Claude SDK Every morning somebody on the team runs the...
Forums
Test topic for spam filtering
A new thread for testing the spam filter. Adding a link: https://www.bbc.co.uk/weather
Removing production permissions when restoring database to non-prod
Hello experts, An application team has asked us to modify a SQL Agent job....
Advanced T-SQL: Replacing Slow Cursors with Window Functions
Comments posted to this topic are about the item Advanced T-SQL: Replacing Slow Cursors...