SQL Server Security Archives - Page 25 of 47 - SQL Authority with Pinal Dave

SQL, SQL Performance, SQL Server, SQL Tips and Tricks

[Note from Pinal]: 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. The emails I get is from various different IT professionals. There are quite a few application developers…

SQL SERVER – Beginning with SQL Server Security Aspects

December 3, 2014

Devart, SQL Server Security

SQL

SQL Server Security Aspects

SQL SERVER – Common Sense Data Security – Notes from the Field #055

November 20, 2014

[Note from Pinal]: This is a 55th episode of Notes from the Field series. Common sense is not as much as common as we think. I am sure you agree with it from your real world experience. However, when it is about data and its security, there has to be…

SQL SERVER – Validation Rules: Code or Database? – Notes from the Field #054

November 13, 2014

BIML, Notes from the Field, SQL Server Security

[Note from Pinal]: This is a 54th episode of Notes from the Field series. Where do we blame for a mistake or error in the system? Well, developer blames DBA and DBA blame developers. Sometimes there is no solution to the catch 22 situation. I have been there and I…

SQL SERVER – Using Bitwise And (&) Instead of a Junction Table – Notes from the Field #053

November 5, 2014

[Note from Pinal]: This is a 53rdth episode of Notes from the Field series. Everyday I get 100s of emails and most of the emails have a similar request. Everyone wants to get maximum performance, but they want to make the least amount of changes in their code. Well, though…

SQL SERVER – Beginning Table Valued Constructors – Notes from the Field #052

October 30, 2014