Database Table Documentation with a Data Dictionary
Why table and column documentation is useful and some SQL for setting up the data dictionary tables.
At Boston Public Schools,...
2011-06-10
1,924 reads
Blog Posts
Easier way to view SQL Server job history
Ever get a timeout error when using the “View History” for a SQL Server Agent job? I find this happens...
2011-06-10
4,383 reads
How Query execute
*This is my Opinion Whenever you execute any query…. Everything will be on Memory unless data is not available from...
2011-06-10
477 reads
June Meeting - Data Architecture VC
June Meeting - Data Architecture VC
Data Architecture VC presents Karen López:
Subject:You've Just Inherited a Data Model: Now What?Start Time:Thursday, June 16,...
2011-06-10
695 reads
Microsoft TechDays 2011 in Kosova, Prishtina
It's late but I need to say some words about our local tech event, it is the only one that...
2011-06-10
1,994 reads
Planes Trains and Automobiles
I was going to write a short post showing some useful queries that can help you manage your vCentre environment,...
2011-06-10
474 reads
Re-blog – June 3-June 9
As I mentioned in the introductory post, I’m summarizing posts from previous years in the the past week. Some posts...
2011-06-10
544 reads
Slides & samples from my DevConnections sessions
As announced in both of my SQL Server sessions at DevConnections in Karlsruhe/Germany
you can find here the slides & samples for...
2011-06-10
900 reads
SQL Dream Cars
A mini debate on Twitter the other day got me thinking about cars. People that know me know I like...
2011-06-10
1,519 reads
SSIS Webinar Recording Is Up
I want to say a huge thank you to everyone who attended the webinar from Pragmatic Works (website) that I...
2011-06-10
678 reads
Blogs
Claude AI Convinced Me Not to Build an iPad App
By Steve Jones
I coach volleyball and I do a lot of stat stuff on paper. I...
A New Word: Dolorblindness
By Steve Jones
dolorblindness – n. the frustration that you’ll never be able to understand another person’s...
Claude Code Helps Analyze Test Data Manager Log Files
By Steve Jones
I had a customer ask about analyzing their Test Data Manager (TDM) usage to...
Forums
Data Warehouse Toolkit meets Star Schema: The Complete Reference
Is there a good syllabus for reading these two together? (Yes, it's called the...
GPX distance and time analysis in SQL Server
Comments posted to this topic are about the item GPX distance and time analysis...
The DBA is Dead; Long Live the DBA
Comments posted to this topic are about the item The DBA is Dead; Long...
Question of the Day
Changing the AG Listener
In SQL Server 2025, if I want to remove an IP from a listener, what do I do?
See possible answers