Tags » SQL Security

SQL SERVER - The DBA goes to MARS - Maintenance, Architecture, Research and Support - Notes from the Field #063

: This is a 63rdth episode of Notes from the Field series. Storytelling is an art very few have mastered in their life. When I requested Stuart to share his ideas about his famous blog about MARS, I really had not expected the response which I have received in this episode of Notes from the field. 852 more words

SQL Authority

SQL SERVER – How to Find Weak Passwords Using T-SQL?

Recently one of my blog reader emailed me below question.

Hi Pinal,
Need your urgent help. In recent past, we have been attacked by the hacker who was able to get in to our SQL Server via sysadmin account and made big damage to our data.
292 more words

SQL Authority

SQL SERVER - Iterating over Metadata with BimlScript - Notes from the Field #061

: This is a 36th episode of Notes from the Field series. One of the common question I receive every other day is – I have learned BI but I feel that there is no automation in the BI field, what should I do? 727 more words

SQL Authority

SQL SERVER - Performance Tuning - Is It Really A Top Skills for a SQL Server Consultant? - Notes from the Field #059

: This is a 59th episode of Notes from the Field series. I get over 100 emails everyday and out of 100 emails nearly 90 of them are really related to performance tuning. 900 more words

SQL Authority

SQL SERVER - Beginning with SQL Server Security Aspects

SQL Server Security Aspects

This article is the high-level overview of the SQL Server security best practices and aspects. Ensuring SQL Server security is an important task that may be successfully solved by applying best practices and proven solutions described further in this article. 1,750 more words

SQL Authority