Effective Permissions on a Database
written by David Postlethwaite
Ever wondered who has what access to your database or a particular object within? With the ever...
2011-07-14
2,335 reads
Send SSRS subscription files to (Secured FTP) SFTP
We have set up subscription for customer which used to send mails to the customers periodically. Recently one of the...
2011-07-14
3,925 reads
Do you use T-SQL debugging?
T-SQL debugging is not 100% in SQL Server. It has few bad drawbacks starting from difficulties when setting it up...
2011-07-13
1,219 reads
BI Documenter: Impact Analysis and Object Lineage
Are you considering making a change to your view or stored procedure? Or possibly you are considering moving your database...
2011-07-13
2,683 reads
SSSOL July 2011 Reminder
This is just a quick note to remind anybody who may be interested of the upcoming Las Vegas User Group meeting. As I posted here, we will be learning...
2011-07-13
10 reads
SSSOL July 2011 Reminder
This is just a quick note to remind anybody who may be interested of the upcoming Las Vegas User Group...
2011-07-13
605 reads
SSIS package taking forever to load when you open it?
When you open a SQL Server Integration Services (SSIS) package in SSIS Designer or add components to a package, SSIS...
2011-07-13
2,592 reads
Simple Database User-Access Security Validation & Granting Elevated Access Temporarily Using the Execute As Statement
If you ever want to validate what level of access a user has within a database OR wish to temporarily...
2011-07-13
1,125 reads
How to move the MSDB database
First we need to know the name and file location of the MSDB database files. When you change the location, make...
2011-07-13
961 reads
Make It Simple With Policy-Based Management
At work recently, I explained to a coworker the reasons and benefits of having databases in Simple mode in your...
2011-07-13
958 reads
Blogs
Demo for Parameter Sniffing and Memory Grant Feedback
Disclaimer: The following is built with Claude Code. Just need to justify my $100/mo...
My Social Media Rules
By Brian Kelley
I developed these rules a while back, before COVID. I had a period of...
Why Use TRY_PARSE(): #SQLNewBlogger
By Steve Jones
Someone asked why I would use TRY_PARSE after I posted a question at SQL...
Forums
The SQL Server MCP Server
Comments posted to this topic are about the item The SQL Server MCP Server
The Hidden Danger of Wildcard Operators In Join Operations
Comments posted to this topic are about the item The Hidden Danger of Wildcard...
A Worse Computer; A Better Car
Comments posted to this topic are about the item A Worse Computer; A Better...
Question of the Day
The SQL Server MCP Server
How do I get an MCP server for my SQL Server 2025 database from Microsoft?
See possible answers