Nicom IT Solutions
  • Services
        • Managed & Technical Support Services
          • Information Technology Assessments
          • Network Architecture/Design, Configuration & Installation/Management
          • Active Security, Monitoring & Preventative Maintenance Programs
          • End User Workstation & Subscription Management
          • Back-Up & Business Continuity/Disaster Recovery
          • Advanced Mailbox Protection & Training Services
          • Advanced Telephony Services & Handset Management
          • 24/7 Multi-Tier Helpdesk
          • Software Licencing Management
        • Cloud Solutions
          • Advanced Office 365 Licencing & Services
          • Infrastructure as a Service (IaaS)
          • Hardware as a Service (HaaS)
          • Software as a Service (SaaS)
          • Web as a Service (WaaS)
          • Cloud/Application Subscription Management
          • Cloud Migration Service & Support
        • IT Consulting
        • Web & Mobile Business Application Development
          • Discovery & Consulting
          • UX & UI Design
          • Mobile Application Development
          • Web Application Development
          • Enterprise Solutions Services
          • Backend Development
          • Blockchain Development
          • Artificial Intelligence Software Development
        • Website Design & Development
        • Seaport Information Management Systems
  • IT Careers
  • Blog
  • Contact
  • Menu Menu

Oh, T-SQL, take me away!

Ok, so I have this project that I’m working on with a complex security requirement. I’ve built the data layer using NetTiers as a C# library. All of the necessary methods have been exposed as a user-friendly API via a VB.NET client library.

Problem #1, my library is required to make WAY too many calls to the database as the security process works its way through the layers of permissions (business rule permissions). How do we reduce these database calls?

Answer #1, implement my database calls as native SQL functions.

Hmm, what would be involved in essentially converting my VB.NET functions as T-SQL functions? Surprisingly not much. Once you get past the fact that every line needs to be re-coded, the work really isn’t all that bad. It’s an effort that will pay off in dividends in terms of speed and efficiency.

Now, if I can do something about that large session parameter class we’re using.

Return to the Blog

We are a full-service IT professional services firm that prides itself in the long-term relationships that we have developed with our clients and partners.

Get in Touch With Us!

We’d love to hear from you

Toll Free: 1-877-454-4499
Email: info@nicomit.com

201 Whitehall Dr.
Markham, Ontario
L3R 9Y3

Suite 2030, 6960 Mumford Rd.
Halifax, Nova Scotia
Canada B3L 4P1

Blog

  • Nicom-Built Data Dashboards now Online at Port of Halifax July 25, 2017
  • Nicom Secures Texas Seaport Contract October 27, 2016
  • The Houston Astrolite – a Marvel of Early Technology September 13, 2016

IT Professional Placement Services

We are a leading Canadian IT staffing agency and recruiting firm, providing clients with the best people for critical projects and initiatives. We customize to fit the unique needs of your growing company.

Let us help you engage the next-level tech talent you’re looking for.

  • Contact
  • About Nicom
  • Blog
  • Privacy Policy
© Copyright - Nicom IT Solutions Inc.
  • Website by Nicom Interactive
Scroll to top