Potential Security Exploit Using CONTROL SERVER Permissions in SQL Server
In this tip we cover what CONTROL SERVER is, how to detect its use and a possible way to exploit this permission.
2012-03-01
2,469 reads
Articles
New User-defined Server Roles in SQL Server 2012
SQL Server 2012 brings new security enhancements, one of which is to create user defined server roles, which simplifies instance wide administration and helps to increase the security of the instance by letting you define different groups with different sets of permissions as per their role and responsibilities.
2012-02-29
3,032 reads
Configuring Service Account Privileges for SQL Server
How to grant Windows privileges to the SQL Server's service account.
2012-02-28
8,635 reads
2012-02-28 (first published: 2010-10-20)
9,599 reads
Automated Script-generation with Powershell and SMO
Phil Factor demonstrates how to generate T-SQL scripts for databases, selected database objects, or table contents from PowerShell and SMO.
2012-02-28
3,400 reads
How to join a local table to a remote table by way of a linked server
Distributed queries on linked servers are not the greatest idea from a performance standpoint, but they can be quite useful.
2012-02-27
23,287 reads
Point in Time Recovery Using New Timeline Feature in SQL Server 2012
SQL Server backups are key to recovering from a disaster or some type of data failure, but the real magic happens when the backup is restored. In this tip we look at a new enhancment in SQL Server 2012 for point in time recovery using the new timeline feature.
2012-02-27
3,196 reads
SQL Saturday #109 - Silicon Valley
Come to a free day of training on Mar 3, 2012 in Mountain View, CA
2012-02-27
1,360 reads
SQL Saturday #123 - Western Cape
Come to a free day of SQL training on Mar 3 in Tyger Valle, Western Cape in South Africa.
2012-02-27
1,265 reads
Using SSIS to Maintain the File System
Integration Services is one of the more flexible tools available on the SQL Server platform. Jason Brimhall shows us a way to remove old files, either backups or flat files, after a configurable period of time.
2012-02-24
7,237 reads
Blogs
A New Word: Dolorblindness
By Steve Jones
dolorblindness – n. the frustration that you’ll never be able to understand another person’s...
Claude Code Helps Analyze Test Data Manager Log Files
By Steve Jones
I had a customer ask about analyzing their Test Data Manager (TDM) usage to...
PowerPoint to HTML with Claude AI
By Steve Jones
I had an idea for an animated view of a sales tool, and started...
Forums
Optimism Without Illusion or Why AI Needs Blunt Technologists
Comments posted to this topic are about the item Optimism Without Illusion or Why...
SSIS with VS2022 64/32 issue with Excel files
Hi all, I'm trying to do classic scenario for loading multiple Excel files into...
Case part is sloooooow
Hi So the case statement is slowing this down - but for the life...
Question of the Day
The String Distance I
In SQL Server 2025, what is returned by this code:
SELECT EDIT_DISTANCE('tim', 'tom')
Assume preview features are enabled. See possible answers