Understanding Triggers
A trigger is a specialized stored procedure that activates (executes) in response to an event. There are two basic trigger...
2013-12-14
701 reads
Possible ways to secure SSIS Packages
SQL Server Integration Services (SSIS) security is based around several layers that provide a rich and flexible security environment. These...
2013-12-14
719 reads
T-SQL Tuesday #49: Wait For It Roundup
A huge round of applause and my thanks to all of the participants and spectators for this month’s edition of...
2013-12-14
1,667 reads
Enabling High Performance Power Plan via PowerShell
One of the projects I’ve been working on recently was to automate our production SQL Server installs including our standard...
2013-12-13
1,967 reads
Android Annoyances
I wrote last week that I had switched back from Android to iOS, but I didn’t list out specific gripes...
2013-12-13
893 reads
Using Power Query to Parse your Inbox
One of the nice new features that was added to Power Query with the latest update in December is the...
2013-12-18 (first published: 2013-12-13)
2,686 reads
Reblog: December 6 to December 12
I’ve always been a fan of the feeling when I find an old blog post that’s got just the information...
2013-12-13
487 reads
Friday Followup For December 13, 2013
It’s Friday, time to look back at the most popular RealSQLGuy posts of the week. Because it’s Friday and you’re...
2013-12-13
463 reads
Keeping Up With Training: Day 5
Let's keep this talk going about what you can do. We know I'm rather big on user groups and SQL...
2013-12-13
447 reads
Throwback Thursday #3: SQL Server & Disks
I hope everyone is having a good time gearing up for the holidays. Throwback Thursday is a bi-weekly blog series where...
2013-12-12
702 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