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,534 reads
Consultando LDAP via SSMS
A query tem o objetivo de consultar o status do usuario AD via Management Studio.
2011-08-22
409 reads
Rastreando SysAdmin Habilitado
Script tem o objetivo de encontrar login com a role SysAdmin e informar seu status.
2011-08-22
224 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
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
Blogs
Microsoft Purview data governance best practices
By James Serra
Microsoft Purview can be the best data governance tool in the world, but it...
AI Insights for Database Monitoring: A DBA’s Perspective
By Arun Sirpal
Second in a series on Ai and databases. One Story, three signals – I...
Crash-Consistent MongoDB Snapshot and Restore with Everpure Fusion
I’ve been working on a project that combines two things I spend a lot...
Forums
PolyBase Trace Flags
Are there any good articles on all the trace flags that are enabled on...
The Data Model Matters
Comments posted to this topic are about the item The Data Model Matters
Understanding SQL Server PARTITION BY with Examples
Comments posted to this topic are about the item Understanding SQL Server PARTITION BY...
Question of the Day
Running SQLCMD I
I run the SQLCMD utility as follows:
lcmd -S localhost -EI then type this (the 1> is the prompt):
1> select @@version goIf I hit enter, what happens? See possible answers