Consultando LDAP via SSMS
A query tem o objetivo de consultar o status do usuario AD via Management Studio.
2011-08-22
409 reads
Scripts
Rastreando SysAdmin Habilitado
Script tem o objetivo de encontrar login com a role SysAdmin e informar seu status.
2011-08-22
224 reads
2011-08-18 (first published: 2011-08-04)
1,116 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)
464 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,674 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)
789 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,385 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,408 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
329 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)
807 reads
Blogs
No Shortcuts for the SQLCMD Batch Terminator: #SQLNewBlogger
By Steve Jones
I was messing around with SQLCMD and I realized something I hadn’t known. I’ve...
Where Is My SQL Agent? Running Scheduled Jobs Against Azure SQL Database
By gbargsley
One of the first things I review when I inherit a new SQL Server...
AgentDBA vs Critical SQL Server
By Arun Sirpal
It’s 07:43. Someone’s already left a message. “Something’s wrong with the DB server.” You...
Forums
Increment a number in a SQL Query based on a value
I have an issue where I have a Bill of Material list of items...
Follow Your Hunch
Comments posted to this topic are about the item Follow Your Hunch
What Happens When You Ask a Local AI to Query Your Database?
Comments posted to this topic are about the item What Happens When You Ask...
Question of the Day
Detecting Characters
I have a SQL Server 2022 English default installation on a server. I want to detect if there are any upper case characters in rows and I have this code:
SELECT CustomerNameID,
CustomerName
FROM dbo.CustomerName
WHERE CustomerName = LOWER(CustomerName)
Here is the sample data I am testing with:
CustomerNameID CustomerName 1 John Smith 2 Sarah Johnson 3 MICHAEL WILLIAMS 4 JENNIFER BROWN 5 david jones 6 emily davis 7 Robert Miller 8 LISA WILSON 9 christopher moore 10 Amanda TaylorHow many rows are returned? See possible answers