Why are my permissions missing?
You’d be amazed (or maybe you wouldn’t) how often I hear this: “I used to be able to do xyz ... Continue reading
2021-06-22
132 reads
SQLStudies
#PowershellBasics: Finding a common AD group for a set of users.
A while back (almost 7 years ??) I wrote a post on finding the common AD groups of a set ... Continue reading
2021-06-17
123 reads
Long names vs short names (or aliases)
I remember when I was first learning to code there was always the argument of how long a name should ... Continue reading
2021-06-30 (first published: 2021-06-15)
1,116 reads
CROSS vs OUTER APPLY
I love CROSS APPLY. I also love OUTER APPLY. What’s the difference though? The same difference as with an INNER ... Continue reading
2021-06-21 (first published: 2021-06-10)
1,411 reads
My journey with hybrid technologies. Where it started, how it’s going, and where it ends. : T-SQL Tuesday #139
One of my favorite people is hosting TSQL Tuesday this month. Ben Weissman (blog|twitter). He wants us to talk about ... Continue reading
2021-06-18 (first published: 2021-06-08)
287 reads
Use BCP to create a CSV (comma delimited) file from a table.
This is a pretty handy little tool in your arsenal. I’ve talked about using bcp to transfer data from one ... Continue reading
2021-06-03
234 reads
SQL Homework – June 2021 – SQL Audits
Last month I had you work on Extended Events, so hopefully now you are a bit more comfortable with them. ... Continue reading
2021-06-14 (first published: 2021-06-01)
297 reads
The WITDC Mental Health and Wellness day and why July 2020 really sucked for me.
I recently gave a presentation at the WITDC Mental Health and Wellness day. The recordings are out and here’s the ... Continue reading
2021-06-11 (first published: 2021-05-27)
220 reads
What account is xp_cmdshell using?
It works when I run it this way™ but not when I run it through xp_cmdshell! It’s a permissions issue. ... Continue reading
2021-05-25
145 reads
#PowershellBasics: Writing to the screen
Writing to the screen is a really basic debugging technique. That said, since I’m really new with Powershell this is ... Continue reading
2021-06-04 (first published: 2021-05-20)
629 reads
Blogs
A New Word: Gnossienne
By Steve Jones
gnossienne– n. the awareness that someone you’ve known for years still has a private...
Exploring DiskANN: Part I: Understanding the Algorithm before the disk
How I used AI for this postChatGPT to generate images based on info specifically...
Learning Tool – Deepstash
By Brian Kelley
A few months ago I started using Deepstash. Deepstash breaks books into the key...
Forums
When the Token Meter is Zero
Comments posted to this topic are about the item When the Token Meter is...
Understanding Temp Tables and Table Variables in SQL Server
Comments posted to this topic are about the item Understanding Temp Tables and Table...
The Data API Builder MCP Server Tools
Comments posted to this topic are about the item The Data API Builder MCP...
Question of the Day
The Data API Builder MCP Server Tools
The Data API Builder MCP Server, v2.x, includes a number of tools. What actions can these tools perform in your database?
See possible answers