SQL Server – Different Ways to Check Object Definition
sp_helptext is widely used for checking object definition in SQL Server. sp_helptext can be used to check definition of various...
2014-04-14
1,065 reads
Blog Posts
SQL Server – How To Find SQL Virtual Name From Host Name in SQL Failover Clustering Using PowerShell
Often times it is required to find out the SQL name from the host names in a clustered environment so you...
2014-04-14
1,175 reads
SSIS XML Task
The XML Task in SSIS allows you to parse through an XML file and read the nodes in the XML....
2014-04-14 (first published: 2014-04-07)
3,344 reads
Using BMC Control-M to Automate Tasks
My largest client recently purchased BMC Control-M to use as our enterprise scheduler. Since this product went live in our...
2014-04-14 (first published: 2014-04-04)
4,000 reads
Hortonworks Data Platform 2.1 New Features
What is Hortonworks Data Platform
Hortonworks recently announced their release of the HDP 2.1 their Hadoop Big Data platform. If you...
2014-04-13
903 reads
Using the T-SQL MERGE Statement
In SQL Server 2008, Microsoft added a new SQL query type: the MERGE statement. This flexible query provides the ability...
2014-04-13
5,681 reads
Reasons why your plans suck : No 56,536
I have been working with SQL server for more years than I really care to mention and like to think...
2014-04-12
388 reads
An Open Letter to Brogrammers
It’s not in the language I would write it in and it’s not necessarily safe for work, but it gets...
2014-04-11
784 reads
Call for Speakers – SQLSaturday #324 Baton Rouge
Baton Rouge is now on its 6th SQLSaturday and the event grows year after year. It all started with Patrick...
2014-04-11
650 reads
Friday Followup For April 11, 2014
It’s Friday, time to look back at the most popular RealSQLGuy posts of the week. Because it’s Friday and you’re...
2014-04-11
408 reads
Blogs
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...
PowerPoint to HTML with Claude AI
By Steve Jones
I had an idea for an animated view of a sales tool, and started...
Forums
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...
Changing the AG Listener
Comments posted to this topic are about the item Changing the AG Listener
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