DDL Trigger Event Groups
- Posted in:
- SQL Server
- Database Administration
A "compact" query showing DDL trigger event group hierarchies.
[...Read More]A "compact" query showing DDL trigger event group hierarchies.
[...Read More]Implementing a SQL Server temporal table led to a couple of gotchas. But the end result was really good.
[...Read More]Write files to cloud storage with SQL Server's Machine Learning Services
[...Read More]T-SQL has no native support for parquet files. It's R, Python, and Machine Learning Services to the rescue!
[...Read More]External Python and R scripts for SQL Server Machine Learning Services have limited access to the file system.
[...Read More]A walkthrough for installing R packages for SQL Server Machine Learning Services
[...Read More]How to find unused INCLUDE columns in nonclustered indexes for SQL Server.
[...Read More]There are performance implications when choosing between the Default Schema and an Explicit Schema for SQL Server's OPENJSON rowset function.
[...Read More]Options for backing up SQL Server database schemas
[...Read More]Can the performance of PIVOT be beaten with newer T-SQL features?
[...Read More]