Sqlserver-dba.com - SQL Server support and SQL Server Performance Tuning
    SQL Server DBA:Everything | DBA Scripts | Powershell Scripts | DBA checklists | SQL Antipattern | Wait Stats

November 29, 2021

How to detect if the guest account is disabled

Regular scans to find enabled guest ids lead to questions of identifying the status Read more →

Posted at 03:01 AM in Security Management | | Comments (0)

November 25, 2021

How to get last logon of user on Domain Controllers using Powershell

How to get use last logon on Active Directory Domain Controllers using Powershell Read more →

Posted at 08:15 AM in Powershell | | Comments (0)

November 23, 2021

How to INSERT INTO EXEC with extra column

The truth about INSERT INTO EXEC and adding extra data Read more →

Posted at 08:59 AM in T-SQL | | Comments (0)

November 19, 2021

Microsoft Ignite Book of News

The Microsoft Ignite Book of News is a guide to key news items that announced at Microsoft Ignite. Read more →

Posted at 09:11 AM in SQL Azure | | Comments (0)

November 18, 2021

Run SSMS as a different user

SSMS - Run as different user through GUI and command line Read more →

Posted at 07:49 AM in SQL Server Management Studio | | Comments (0)

November 16, 2021

Automatically Indexing Millions of Databases in Microsoft Azure SQL Database

Automated SQL Server Indexing at massive scale Read more →

Posted at 06:38 AM in Indexes, Locking, Performance, SQL Blocking, SQL Optimizer, SQL Query Tuning, SQL Server Tuning | | Comments (0)

November 10, 2021

My Top 4 sessions at PASS Data Community Summit 2021

Attending PASS Data Community SUMMIT 2021 Read more →

Posted at 08:53 AM in DBA | | Comments (0)

Next »