Consultando LDAP via SSMS
A query tem o objetivo de consultar o status do usuario AD via Management Studio.
2011-08-22
420 reads
Scripts
Rastreando SysAdmin Habilitado
Script tem o objetivo de encontrar login com a role SysAdmin e informar seu status.
2011-08-22
235 reads
2011-08-18 (first published: 2011-08-04)
1,143 reads
Change Time Zone on Server without Logging on to Box
Sometimes logging onto a box for a simple change like this is not possible for the business. This allows you to change this directly from T-SQL without having to log on or RDP into the box.
2011-08-17 (first published: 2011-07-28)
478 reads
Tracking processes
This script quick tip for those who will accurately monitor sessions on SQL Server.
2011-08-16 (first published: 2011-08-02)
1,687 reads
Allow distributed transactions
SQL Script to Open DTC for distributed transactions and also configure SQL Server for Distributed Transactions.
2011-08-12 (first published: 2011-08-03)
818 reads
Activity Monitor Script- Head Blocker
This gives you info about blocking, head blocker,wait_type, duration of the queries that are currently running
2011-08-11 (first published: 2011-08-04)
2,407 reads
Reindex - Reorganize or Rebuild
In the first time you execute this procedure, might take a long time, but not in the next time. Later you can execute this procedure daily.
2011-08-10 (first published: 2011-07-06)
2,435 reads
Status de Replicação via E-Mail
Script que envia um relatorio para o seu email com o status de sincronismo de sua replicação.
2011-08-10
342 reads
NetApp Dynamic Backup Script
TSQL Script to backup selected databases. Use this to override the script generated by snapmanager for sql in a sql job which doesn't cater for new or deleted databases
2011-08-09 (first published: 2011-07-27)
836 reads
Blogs
Wait… Could This Be the End of Index Maintenance?
While attending SQLCon and FabCon Europe in Barcelona, there were a lot of announcements...
Copilot on the Power BI Report Canvas vs. Modern Report Builder
By James Serra
(This is the second post in a three-part series on how AI is changing...
The #MS_DatabaseConnector## Role: #SQLNewBlogger
By Steve Jones
I had seen these roles in various instances, but never dug into the new...
Forums
Pay for Performance
Comments posted to this topic are about the item Pay for Performance, which is...
Access + ODBC Driver 18 + SQL Server 2025: ~150–250 ms per request
Has anyone encountered recurring request latency when using Microsoft Access with SQL Server 2025...
The ##MS_DatabaseConnector## User
Comments posted to this topic are about the item The ##MS_DatabaseConnector## User
Question of the Day
The ##MS_DatabaseConnector## User
On SQL Server 2025, I run this code as a sysadmin:
CREATE LOGIN Demo WITH PASSWORD = 'Demo1234567' GO ALTER SERVER ROLE ##MS_DatabaseConnector## ADD MEMBER Demo GOI then login as Demo and run this:
USE sandbox go SELECT CURRENT_USERWhat is returned? See possible answers