ScriptDom Visualizer
Writing code to generate TSql using the ScriptDom is hard. There is a seemingly bewildering array of objects you can...
2015-11-03
517 reads
Blog Posts
ScriptDom Visualizer
Writing code to generate TSql using the ScriptDom is hard. There is a seemingly bewildering array of objects you can use and where you use different types is unclear,...
2015-11-03
6 reads
SQL New Blogger Challenge, Week 1: Just write!
It’s already time for week 1 of this round of the SQL New Blogger Challenge! I have to admit that...
2015-11-03
368 reads
The Whirlwind That Is October – Part 3
October has been such a whirlwind of PASS activity for me. Two SQL Saturdays and the PASS Summit. This post...
2015-11-03
509 reads
Where’s my Team Explorer 2015?
Team Explorer is a client software that can be used to integrate Visual Studio with an instance of Team Foundation...
2015-11-03
413 reads
10 DAX Calculations for your Tabular or Power Pivot Model (Part 2)
This is part two of my 10 DAX Calculations blog series. In this series I’ve blogged ten different DAX calculations...
2015-11-02 (first published: 2015-10-21)
2,409 reads
Administrative Logins and Users
If you’ve ever worked through an audit you have probably gotten a request that looks a lot like this:
Please give...
2015-11-02
504 reads
Consequences of Timeout/Error on a Delete statement
Hello Guys,
Lately, one of my friend asked me a Question, “If Delete is in progress and query get erred out or...
2015-11-02 (first published: 2015-10-21)
5,378 reads
Hekaton Part 10: Things Hash Indexes Can do
Hash Indexes on "In memory" tables are best suited for equality searches. Reason is obvious, as they are based on...
2015-11-02
487 reads
PASS Summit 2015: Wrap-up
WHOOP!
Another PASS Summit is complete. This one was amazing. It’s my first time ever as a member of the Board...
2015-11-02
460 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