Is it page splits that you're seeing?

It's understandable that key columns or date/time stamps, like OrderStatusID or InventoryDate, are updated as part of an entity's normal lifecycle, but these type...

Gary Varga (1/15/2016)

---

Eric M Russell (1/14/2016)

---

Gary Varga (1/14/2016)

---

Jeff Moden (1/14/2016)

---

Insurance companies are already doing this although I don't know if they actually track geo-location but it seems logical they would...

Steve, what is this curious attachment at the bottom of your Security Convenience article; a PostScript file?

As a sysadmin, I create a login:

CREATE LOGIN BobSmith WITH PASSWORD = 'mypassword'

I now am in the Sales database and execute this:

CREATE USER BobSmith

What happens?

Considering that a...

If you want to INSERT rows for new ZipCodes and UPDATE columns for existing ZipCodes, then that's what's called an "UPSERT" or "Type 1 Change". You can implement this using...

Like what it says: "Cannot insert duplicate key in object 'dbo.Postal'."

Perhaps you're attempting to insert a row that already exists in the target table.

Gary Varga (1/14/2016)

---

Jeff Moden (1/14/2016)

---

Insurance companies are already doing this although I don't know if they actually track geo-location but it seems logical they would because they can. They...

Jeff Moden (1/14/2016)

---

...

Same goes for cell phones so far as locating the phone and you if you're carrying it with you (and who wouldn't?).

...

Heh... and people are (pun intended) bugged...

The economic argument in favor of Buy is stronger if the product has robust and simply features for customization and scripting.

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