Tags » SQL Security

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

: 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. 679 more words

SQL Authority

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

: 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. 822 more words

SQL Authority

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

: 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. 991 more words

SQL Authority

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

: This is a 52th episode of Notes from the Field series. I am very happy that the journey which we started one year ago is a amazing milestone. 651 more words

SQL Authority

SQL SERVER - The Why of BIML - Notes from the Field #051

: This is a 51th episode of Notes from the Field series. In one of the earlier blog post we discussed about BIML and lots of people asked what is actually BIML and why one should use it.  1,161 more words

SQL Authority

SQL SERVER - ​Tuning Queries is Sometimes Waste of Time - Notes from the Field #049

: This is a 49th episode of Notes from the Field series. Every day I get few emails where I am asked how to tune queries so the entire server run faster. 1,218 more words

SQL Authority

SQL SERVER - ​Building Technical Reference Library - Notes from the Field #048

: This is a 48th episode of Notes from the Field series. How do you build a technical reference library? In other word, when you need help how do you create your own reference so you do not have to go out to look for further help. 1,123 more words

SQL Authority