william-700725 (10/28/2015)

---

WHERE? Those are the ones I want but can never find. I always get stuck having to earn...

Let's assume that the sync application is attempting to create an index on Customer table called ix_CustomerName. If you don't want that index, then you could try creating a filtered...

Four years after the article was published; is the business still bugging developers?

It helps if your IT department is using TFS or JIRA to manage requests the same way as...

GoofyGuy (10/28/2015)

---

So then ... the less-exalted aren't interested ever in challenges, they're just in it for...

Gary Varga (10/28/2015)

---

Eric M Russell (10/19/2015)

---

...Top-end contractors are able to sniff out bad management from the start and pass the "opportunity" over, so the organization isn't likely to acquire them...

Gary Varga (10/28/2015)

---

Eric M Russell (10/28/2015)

---

...another advantage of Char(1) is that it offers the flexibility of supporting additional codes in the future. Computers reduce the world as 0 | 1,...

ben.norris (10/28/2015)

---

Eric M Russell (10/27/2015)

---

However, if a single column approach is more appropriate, then I still prefer not to use 1 or 0 but rather a character using a less...

Honestly, I hate healthcare IT, specifically healthcare data. The problem is that you have a lot of disparate vendors with proprietary and inconsistent data, who out of necessity must exchange...

If you're going to do something like copy production data down to lower (ie: Dev and QA) environments, then you need a formalized process that is approved and scoped by...

Glenn Berry maintains a lot of system information type DMV queries on his blog site. You might find something there to fill in some of the missing items.

https://sqlserverperformance.wordpress.com/2012/06/11/sql-server-2008-diagnostic-information-queries-june-2012/

You mentioned that you are managing the database. Of course you can do everything you need using T-SQL from a query window, but going with any other tool (like MS...

Are we simply talking about what tool or technique to use for migrating data from an old transactional database into a new transactional database (ie: SSIS) ?

http://www.amazon.com/Server-2012-Data-Integration-Recipes/dp/1430247916

Or are we talking...

Whether an IT department is Great or Lousy; it's determined by the aggregation of those of us in the department.

One great quote in there is "velocity is more important than perfection", which is a tenet that I have found to be very true over the years. It's not...

My (admittedly un-scientific) belief is that only a small percentage of organizations in private (or public) sector engage in what could be genuinely called "data science". Whatever predictive modeling they...