TSQL Snippet for viewing basic info on database principals and their permissions
Quick snippet I put together for reviewing basic info on database users/principals, permissions, and members if the principal is a...
2013-05-31
1,520 reads
Quick snippet I put together for reviewing basic info on database users/principals, permissions, and members if the principal is a...
2013-05-31
1,520 reads
Msg 402, Level 16, State 1, Line 67
The data types varchar and void type are incompatible in the add...
2013-05-30
1,367 reads
For sake of future generations, let’s begin to reduce typing and reuse code we’ve built. I think we can all...
2013-05-22
1,294 reads
Snippet to quickly view computed column information. You can also view this by doing a “create table” script. This however,...
2013-05-22
568 reads
If you want to audit your enviroment to look at all your synonyms and see where they are pointing, you...
2013-05-21
804 reads
SQL Server Management Studio (SSMS) is not offered as a standalone download on MSDN.
Installation requires the user to download the...
2013-05-07 (first published: 2013-04-30)
26,597 reads
Handling dates is always a fun challenge in T-SQL! Finding the current end of month and next months beginning of...
2013-05-01
2,216 reads
Snippet to designate a certain time of the day to evaluate in the current day. If you need to limit a...
2013-04-23
351 reads
Intellisense can be a boon to adding quick development. Quick hints on scope specific variables, syntax suggestions, function descriptions and...
2013-04-22
912 reads
Dynamic SQL can be helpful, but a pain to debug. I spent hours today working on figuring out why my...
2013-04-18
422 reads
The post Data Governance: The Invisible AI Accelerator appeared first on Joyful Craftsmen.
On January 9 I have done an online presentation about Exploring PostgreSQL for the...
By Steve Jones
I wanted to experiment a bit with an LLM and training it, so I...
Hi Experts, I have database about 300GB in size with ADR enabled but after...
Comments posted to this topic are about the item Influencing a Local AI
Comments posted to this topic are about the item Data API Builder Operations
What types of database operations does the Data API Builder support?
See possible answers