I don't typically rename tables or views. There's been some badly named (IMO) tables, but I've just lived with them.

However, stored procedures are different. I've often taken an old SP...

I think that sometimes the amount of required data is simply out of our hands. I now work for a State agency, which needs to report data to different Federal...

Jacob Wilkins (6/5/2015)

---

You can definitely sort the results in a combo box. In the Row Source property of the combo box, just add the appropriate ORDER BY clause to the...

Lynn, what I'm trying to do is group the records by BitField, whether they're ordered or not. What I was hoping the UNION would do is return all of the...

I prefer using suffixes to prefixes. Personal preference, but that's the way I roll.

Agreed. I know it's possible to search for PowerShell tutorials, etc., but it would be nice...

OK thank you, I'll give that a try. Do I open the copy with SQL Data Tools, or are you recommending making the copy just so if I need to...

I hadn't thought of the administrative policy that you mentioned. Interesting idea, Steve. I'm too new here to know if that would fly or not.

David.Poole (2/26/2015)

---

Well so far I've gone through data architecture and now have the title of "Big Data Manager".

I'm managing a team, engaging with business people, working out new ways of...

Miles Neale (2/17/2015)

---

paul.kemner (2/17/2015)

---

It seems the 'sell-by date' for IT workers gets lower and lower, yet I never see this pointed out to people starting out in the field. IT...

WOW, awesome article, Steve!

Oh this is really good, Andy. Thanks!

Kurt Kemper (6/17/2014)

---

Very interesting editorial and replies...

My personal experience has actually been opposite of some posting here. I am the Senior DBA and work alongside a Junior DBA who...

I know you asked this question over a year ago, but I'd like to chime in. I wonder how useful salary survey sites are. Or salary surveys in general. I'm...

I agree with you, Felipe, that the term DBA today tends to cover too wide a spectrum. Too many skills that either one would have at best some acquaintance with,...