How difficult can it be to produce a simple hierarchical list in JSON, YAML, XML and HTML from a SQL Server table that represents a simple hierarchy within an organisation. Well once you know, it is easy and William Brewer is on a mission to tell you how.
Matteo Lorini shows how to setup a project in SSMS to organize files.
In Azure SQL Data Warehouse we can use BCP to export or import the data. In this article, we will show how to do it.
Brent Ozar, Erik Darling, and Tara Kizer think about what they would change or fix if they had access to SQL Server’s source code.
A bug in SQL Server needs patching right away if you use TDE. Some data security issues concern Steve as well.
Does it make sense for a DBA to be a job that moves from project to project? Steve Jones has some thoughts.
A note of caution on the use of sp_helptext to script out objects.
SQLCLR is now considered a robust solution to the few niche requirements that can't be met by the built-in features of SQL Server. Amongst the legitimate reasons for avoiding SQLCLR, there is the fear of getting bogged down in code with special requirements that is difficult to debug. Darko takes a real example, extending the features of sp_send_dbmail, to demonstrate that there need be few terrors in SQLCLR.
Lots of work is going into making software more helpful. This week Steve Jones wonders what you want from these assistants.
By Brian Kelley
My most recent bout with imposter syndrome was with ISACA’s Digital Trust Ecosystem Framework...
By Steve Jones
“On the way to a grand goal, celebrate the smallest victories as if each...
Materialized lake views (MLVs) in Microsoft Fabric are an effective way to implement medallion...
IT's OK I've create a stored procedure ActualExecute which is the TSQL script equivalet...
BCA KCU RAWAMANGUN Tlpn:CS.0853•5504•2311 Jl. Paus No.81, RT.1/RW.8, Wil, Kec. Pulo Gadung, Kota Jakarta...
Komplek Ruko Grand Mall, Jl. Sudirman (Kompeks Ruko Grand Mal, Jl. Jend. Sudirman Kompeks...
How can I alter the deadlock detection interval to 2 seconds instead of 5 seconds on my SQL Server 2025 instance?
See possible answers