Wait Time - Query\Client
Script helps to get the client and queries that generate longer waiting time.
2011-11-07 (first published: 2011-10-14)
1,529 reads
Consultando LDAP via SSMS
A query tem o objetivo de consultar o status do usuario AD via Management Studio.
2011-08-22
403 reads
Rastreando SysAdmin Habilitado
Script tem o objetivo de encontrar login com a role SysAdmin e informar seu status.
2011-08-22
222 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,668 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
328 reads
Blogs
Why your data still can’t answer a simple question
Every organization I talk to has the same problem dressed up in different clothes....
T-SQL Tuesday #197 Invitation – An impactful session or two from a conference
By DataOnWheels
I am delighted to host this month’s T-SQL Tuesday invitation. If you are new...
Did You Really Name That Default?
By alevyinroc
Ten years (and a couple jobs) ago, I wrote about naming default constraints to...
Forums
The day-to-day pressures of a DBA team, and how we can work smarter with automation and AI
Comments posted to this topic are about the item The day-to-day pressures of a...
CMS server query & temp tables
I am annoyed. We have a CMS server that has hundreds of servers saved...
The Problem Isn't Always Your Query or Schema... Sometimes It's Hidden Assumptions
Comments posted to this topic are about the item The Problem Isn't Always Your...
Question of the Day
Identity Defaults
What happens when I run this code?
CREATE TABLE dbo.IdentityTest
(
id int IDENTITY(10) PRIMARY KEY,
somevalue VARCHAR(20)
)
GO
See possible answers