ravi@sql (1/13/2016)

---

HI,

Thanks for your reply , But am working only on MSSQL server or Data base development activity not DBA and SSIS not SSAS or Data warehouse .

So sql+ssis combination...

michael.k.choffy (1/13/2016)

---

I see said the "blind man"! So only the objects with latest modify date show up. Now I have set it to show the last 10.

Thanks Jeff for your...

... The NFL is also starting to use sensors to track their players, but with different goals. They are monitoring workloads, trying to ensure the health and peak performance of...

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...