The default template in SQL profiler doesn’t trace the dynamic SQL executed by the stored procedure. In order to trace the Dynamic SQL, you need to turn on these 2 options in your tracing profile
SP:stmtstarting and SQL:stmtstarting
AI engineer and solution architect in Sydney. Agents, MCP, RAG, Azure, .NET, EV charging. I write about what breaks after go-live.
Business Case: We have a need where we have an existing database from a legacy app and we really enjoyed how easy and fast it is to use Power Apps (Model Driven app) to access entities…
Below is the snippet for using Power Shell to execute list of SQL scripts under a specific folder. I use this script in Octopus deployment to deploy database changes (* for this particular case, we don’t…
Select Node value This is a simple explanation on how to select a particular node from xml data type of a record in SQL server. Sample XML 00003479 Brodie’s HomeSton NULL AU941170 2010-07-22T09:42:20 vcAuditorDesc,chUpdateStaffCode,dtUpdateDateTime,dtUpdateDateTime So what…
UPDATED: I’ve added one function to write from BLOB in SQL Server table to the disk straight away I thought this article might be useful for anyone that wants to implement .NET code to SQL server…
One of the new TSQL feature in SQL Server 2012 is TRY_CONVERT, basically it’s a function that will return null if the object passed is not compatible with the expected casting. In earlier version of SQL…
This is a query to find all the indexes in your table including when it was last updated Find all indexes on all tables SELECT OBJECT_NAME(OBJECT_ID) AS ‘Table Name’, [name] as ‘Statistic’, STATS_DATE(object_id, index_id) AS ‘Last…