FORMAT() is nice and all, but…
Aaron Bertrand compares multiple date formatting techniques, demonstrating again that SQL Server's FORMAT() is not worth the convenience.
Data Mining Part 30: System Views
Sometimes we need to retrieve system information from our data mining models. In this chapter, we will show how to do it using system views.
Data Mining Part 30: System Views
Sometimes we need to retrieve system information from our data mining models. In this chapter, we will show how to do it using system views.
How to Unlock Your Team's Creative Power with SQL Prompt and a VCS
Extend SQL Prompt's functionality by connecting your snippets to version control
Is the Golden Age of Information Technology Almost Over?
Andy Warren wonders if our industry is moving to a new era today.
In-Memory OLTP – Common Workload Patterns and Migration Considerations
In-Memory OLTP is a high performance, memory-optimized engine integrated into SQL Server 2014 and designed for modern hardware trends. In-Memory OLTP allows users to move data into memory resident tables while keeping other data in traditional, disk-based table structures.
The Poster of the Plethora of PowerShell Pitfalls
One of the downsides of learning a new computer language is that transfer of training doesn't always work to your advantage. In fact, the habits you picked up in the past may now cause confusion. In this poster or wall-chart for long walls, Michael Sorens selects the thirty-six most common causes of confusion for anyone getting to grips with PowerShell.
Translating reports with Analysis Services and MS-Excel
Translating reports with Analysis Services 2012 and MS-Excel 2013 in a multilingual environment
Why Can't We Code?
Today Steve Jones talks about the ways in which we interview new developers. Are they working or do we need a new way? Should we be considering those people that have actually accomplished something?
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