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.
Insert, Update, and Delete Indexes: Stairway to SQL Server Indexes Level 13
What happens to your indexes during normal database activity?
The Cloud is good for your career
Is the cloud good for your career? Steve Jones thinks so, and gives you a few reasons you might want to learn more about it.
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.
Configuring Service Account Privileges for SQL Server
How to grant Windows privileges to the SQL Server's service account.
Taking a Sabbatical
Today we have a guest editorial from Andy Warren as Steve is on vacation. Today Andy discusses sabbaticals, and a change in his life.
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.
Call That a Database? This is a Database.
If only the English language had a range of words to describe all the different types of database, there would be so much less confusion in the industry.
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.
Blogs
ISACA AI Material/Exam Prep Discount (May 18 – June 30, 2026)
By Brian Kelley
If you are considering any of the ISACA AI certs like the Advanced Artificial...
A Fabric solution can be very cost effective
By ChrisJenkins
Are you currently using Microsoft Fabric or considering migrating to it? If so, there...
Track SQL Server Configuration Changes Using the Error Log
By SQLPals
Track SQL Server Configuration Changes Using the Error Log If you...
Forums
We Are Eating Our Own Seed Corn
Comments posted to this topic are about the item We Are Eating Our Own...
Before Using AI with Business Data, Read This
Artificial intelligence tools are quickly becoming part of daily business operations, from document analysis...
Designing SQL Server ETL Pipelines That Don't Break at Scale
Comments posted to this topic are about the item Designing SQL Server ETL Pipelines...
Question of the Day
Detecting Deadlocks Quickly
In the Database Engine, when a deadlock is detected, what does the detection interval shrink to (in time)?
See possible answers