Quick Survey: PostgreSQL in Your Organization
Do you use PostgreSQL in your organization? Are you thinking about using it? Take our short survey and tell us about what you think about it.
2014-09-02
8,411 reads
Articles
SQL Monitor Custom Metric: Time Since Last Restore
If your log restores aren't happening when they’re meant to, you want to know about it. You’ll be relying on restoring from logs should anything happen to your databases, and if you can’t restore to a certain point in time, you risk losing valuable data.
2014-09-02
7,671 reads
New toys in SQL Server 2012
In this article we are going to look two new enhancements: the Insert snippet menu option and the surround with option.
2014-09-01 (first published: 2012-05-15)
18,722 reads
Using the Script Task in SSIS to Process Data Files When They Arrive
Learn how you can process data files with SSIS as soon as they arrive using the Script Task.
2014-09-01 (first published: 2012-10-25)
45,821 reads
More Text Analysis with the SSIS Term Lookup Component
As mentioned before, we will use the same use case in this tip as used with the Term Extraction component, which is an archive of all my tweets I've downloaded from Twitter. Using this archive and the Term Extraction transformation I found out which topics I particularly tweeted about in the past years or which persons I mentioned the most.
2014-09-01
7,063 reads
A TDD Journey: 2 - Naming Tests; Mocking Frameworks; Dependency Injection
Test-Driven Development (TDD) relies on the repetition of a very short development cycle starting from an initially failing automated test that defines the functionality that is required, and then producing the minimum amount of code to pass that test, and finally refactoring the new code.
2014-08-29
7,571 reads
Free SQL in the City Seminar Cambridge, MA – Oct 8, 2014
SQL Server MVP Grant Fritchey and Steve Jones will present the Stairway to Continuous Delivery in Cambridge this October in place of the NESSUG meet-up. Learn how to build an efficient development and deployment process for your organization. Register for this free event.
2014-08-29
6,871 reads
SQL Server AlwaysOn Availability Groups Fail the Initial Failover Test
The first test of AlwaysOn in SQL Server 2012 is successful, but after testing to swing back again to your primary replica, you find out that automatic failover works only the first time. How come? Carla Abanes explains.
2014-08-28
7,981 reads
2014-08-27
435 reads
Questions about T-SQL Expressions You Were Too Shy to Ask
Nobody seems to ask questions about SQL Expressions in forums, even though expressions can cause all sorts of problems. It's time for some straight-forward Q&As, and who better than Robert Sheldon to give the A?
2014-08-27
12,876 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