xsevensinzx (9/28/2015)

---

I can understand the what the author means in the article, especially in the BI realm on my end. Sometimes there is just not enough time due to last...

Jeff Moden (9/27/2015)

---

First, I loved your observations in the article. It takes so little time to "test-as-you-go" that I don't understand why more people don't do it. To wit,...

tbailey 19088 (9/28/2015)

---

Steve,

This rename can be done using sp_dropserver and sp_addserver @local='local.

I tested this on one of my development boxes that had only a single, default-named instance. First, I ran...

The server is on Mountain Time (GMT-7) if I remember? I think we left it that way because we had things scheduled based on this zone.

As noted, you change this...

Well, I had a break out day, without starting Freeman, who had done nothing to that point. If only this had been my week 1 score....

The error log is impractical. You'd be reading the entire log every 5 mninutes, trying to sort through text entries.

That would be cool if you have something. It's a neat idea, especially as using something like SCOM is more like a .44 against houseflies.

Personally, as I get older, I don't want a cannon. Hard on the wrists and arms.

Moving to the SQL 2012 forum. This was posted in SQL 2000.

In 2012, you might be able to do something with xEvents and a trigger when you get xx logins...

erichansen1836 (9/25/2015)

---

I See perhaps your point now, that I am actually performing 2 separate COMMITS, 1 to 1 MDB file, and

another to the other MDB file. DO you still...

One thing you might try is using row_number or some other counter based on the rows to retrieve only the PKs needed for that set of data. Then join that...

jasona.work (9/25/2015)

---

I've been wanting to pile into that topic, but keep restraining myself...

Hmm. Maybe we need to Godwin that topic, and bring in a comparison somehow to the Fuehrer?...

The tables are stored in pages, and those in extents. Those get allocated, and depending on the way they're allocated and data is added/deleted, it's possible the allocations don't match....

Ross.Sp (9/24/2015)

---

It's a bad idea to have sensitive data (e.g. a copy of Production data) in a Dev environment and it may actually be in breach of privacy laws and...

We've put together some learning links for you if you want to learn more about this (or other) new feature(s).

http://www.sqlservercentral.com/articles/Dynamic+Data+Masking/127554/