Tejas Shah

Management Proficiencies:
~ A determined & passionate Tech Lead having hands-on experience to drive the development of data-driven services while utilizing best practices in software development and reporting services.
~ Leading teams to success in the creation, testing, and deployment of cutting-edge enterprise level applications, distributed systems, middleware, databases, and APIs.
~ Utilize a thorough grasp of the demands of the business to develop solutions that are well regarded by the clientele.
~ Helping enterprises achieve success via technical proficiency, leading by example, and collaboration amongst varied teams.

Technical Proficiencies:
Microsoft Certified Professional in Microsoft SQL Server.
I have 18+ years of hands-on experience in working with multiple enterprises, where my role was:
1. Design and develop Data Warehouse to support aggregate data from various data sources.
2. Data modeling for the Health Care Portal. Also, worked on Reporting for the same.
3. Develop Performance improvement with the de-normalizing tables.
4. Develop Data Warehouse in SSIS.
5. Develop Reports in SSRS.
6. Maintained all the codes in Version control.

Also, having good experience in Query Optimization, Performance Tuning, T-SQL, Cloud (Microsoft Azure, AWS, GCP), creating & optimizing SQL queries and stored procedures.
  • Interests: SSIS | SSRS | Power BI | Power Apps | .Net Core | C# | MVC | Angular
  • Skills: SSIS | SSRS | Power BI | Power Apps | .Net Core | C# | MVC | Angular

Blogs

Word to the wise: don’t turn on SQL vulnerability checks on a blog about SQL

By

Recently, in an attempt to thwart leechers (1990s kids will know), I added some...

Dazzling Stuff in Databricks (SQL) – Qualify

By

Once upon a time I had a series about some cool stuff in Snowflake:...

Advice I Like: Overnight Success

By

“Most overnight successes – in fact any significant successes – take at least 5...

Read the latest Blogs

Forums

Why Successful SQL Server Backups Are Not Enough

By Almighty

Comments posted to this topic are about the item Why Successful SQL Server Backups...

Adding Bits II

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Adding Bits II

An Unlimited Token Budget

By Steve Jones - SSC Editor

Comments posted to this topic are about the item An Unlimited Token Budget

Visit the forum

Question of the Day

Adding Bits II

I have a table, dbo.bittest, where I am testing an application response. This has this structure:

CREATE TABLE [dbo].[BitTest]
(
[insertdate] [datetime] NULL CONSTRAINT [DF__BitTest__insertd__300F11AC] DEFAULT (getdate()),
[a] [bit] NULL
) ON [PRIMARY]
GO
My application runs this code:
INSERT dbo.BitTest
(
    insertdate,
    a
)
VALUES
(DEFAULT, true)
GO

See possible answers