Browse by Tags

Tagged Content List
  • Blog Post: Yes you can execute PARAMETERIZED sprocs with EF Fluent API Code Only (and more!)

    This is really an add-on to this post here . Turns out most people were only thinking that you could execute SQL strings only as opposed to detailed parameterized SQL statements. That's not correct. It's all supported and approved. Scenario 1. Using Parameterized SQL statements So this covers...
  • Blog Post: SQL Tip of the Day

    HAd this passed to me from the SQL Tips DL here at the 'soft and decided to repost it here to 1. remember about it and 2. share the tidbit INSERT MULTIPLE RECORDS WITH TABLE VALUE CONSTRUCTOR Author: Saleem Hakani (Microsoft Corporation) Wouldn’t it be nice to have the ability to...
  • Blog Post: Server Side Pagination in T-SQL / LINQ

    OK it came as a shock to me that so many people were building huge sets of query data that they are binding in their UI and then deciding to page it at like 10 rows per page. I'm not talking about 1 or 2 or even 3 pages of data, I'm talking about hundreds here. If anyone thinks that schleping this much...
  • Blog Post: SIDs in T-SQL

    If you are in a situation where you need to pass a windows domain user into SQL then you might want to think about this. The most reliable way is to use the user’s SID (security identifier) because SIDs never change (aliases can possibly change); however, it may not be technically feasible. An example...
Page 1 of 1 (4 items)