BrainDonor (10/5/2015)

---

At SQL Pass there's usually an SSC night. I'm certain I saw mention of it somewhere but can't find it again.

Could somebody tell me which night it is?...

I'm not sure what you want with a feature like this. You don't have this now. You have to build it, and ensure it works, and debug it. There are...

Depends on SQL version. In earlier versions, you couldn't compress and encrypt...

Grrrr, tried to swap out me TE who was ruled out in the am, but all players were set to waivers. Annoying I can't pick up an open player on...

billp 37934 (10/5/2015)

---

I'm with Jeff on the header saying what the SQL is supposed to do. When debugging if a header says what it's supposed to do and the...

SQLRNNR (10/2/2015)

---

Brandie Tarvin (10/2/2015)

---

I found this StackOverflow article. Does it help?

DBCC SQLPERF('sys.dmv_name_here',CLEAR);

--EDIT: And then this if clearing plan cache too

DBCC...

WayneS (10/2/2015)

---

It seems that this would be a good time to explore locking down the production environment. Ideally, developers have no need to access production. They might need periodic access...

brad_bowzer (10/2/2015)

---

I wrote a system in MS access in 1993 and upsized it to SQL Server in 1996. Its been updated constantly but the core is much the same...

Iwas Bornready (9/30/2015)

---

I develop code in a fashion similar to what you have stated. I also find that expectations change as we develop, especially when we start showing the results...

Iwas Bornready (10/1/2015)

---

It sounds good, and may be good. It certainly must be for you. But I have a set amount of work that needs to get done. How do...

Brad Allison (10/1/2015)

---

This is great advice that I will share with my small team of SQL Server developers I work with. I usually give them some daily technical inspiration...

Tepluken (10/1/2015)

---

Terrific advice. I always take a walk at the end of the day. Usually I will listen to a podcast as I walk to pass the time; however once...

I do usually tell people in Scouts or kids sports that I'm a computer guy. If they know something and want to ask more, I will talk about databases.

I'm not clear what you are seeing here.

You can connect with SSMS. What are the credentials?

In Data Tools, do you mean SQL Server Data Tools? SSDT? Can you enter the...

Apart from what has been suggested, I try to solve things like this for one area. Write down the plan for one dimension or entity and solve each one. Then...