But an INSTEAD OF DELETE trigger will prevent anything (users, stored procedures, the DBA) from completing delete operations on the table. Is that what you really want?

If you only want...

Regarding the issue of how to monitor for unauthorized changes to the database schema, accounts, permissions, etc., one technique is to periodically perform an automated schema comparison between a pre-production...

There is the Microsoft certification exam 70-463: Implementing a Data Warehouse with Microsoft SQL Server. It covers not just SSIS but also: dimensional data modeling, ETL, Data Quality Services (DQS),...

The value of a developer's time is relative to whatever else they could be working on at that very moment in time. For example, if you have an active data...

Microsoft SQL Server Data Tools (SSDT) is a free download, and it has features for schema comparison, data comparison, and scripting DDL/DML for the differences.

Today, you shouldn't communicate anything in an email that you wouldn't want posted publicly on Facebook. Plausible deniability is why a lot of confidential conversations take place on the golf...

In recent years, the underlying tools (BIDS, SSDT, VS, etc.) provided by Microsoft to support BI development are more stable than Microsoft's overall BI development game plan. Standing alone, they...

Jeff Moden (1/8/2016)

---

Alvin Ramard (1/8/2016)

---

Jeff Moden (1/8/2016)

---

I especially hate it when a Developer that doesn't know, creates tables using Visual Studio or has VS auto-magically create the tables from objects...

If you routinely encounter source data feeds containing dates formatted as strings (ie: MMDDYYY), then you may want to consider implementing a calendar reference table containing multiple variations of key...

Go to YouTube and search on Wise Owl Tutorials; they have a lot of great step-by-step video series for SSIS, SSRS, and SSAS and then even more subscription based material...

Yes, "an untidy collection of things piled up haphazardly" described a heap table. By definition, a heap...

First, confirm if the query plans used by individual statements in fact differ in a significant way from the plans used when contained within a stored procedure. As for root...

Hugo Kornelis (1/11/2016)

---

Eric M Russell (1/11/2016)

---

This smells like healthcare claims data. If so, then "userpolicyid" is something like PayerID + SubscriberID + DependentID, and the format is not coded consistently...

Alvin Ramard (1/11/2016)

---

Eric M Russell (1/11/2016)

---

rahulsahay123 (1/8/2016)

---

I am getting a data feed with date column of type integer.Format is mmddyyyy.

Values are like : 01092015

Now i want to...

That's not a T-SQL question.