I'm not sure that PowerShell standing alone will become popular amoung Linux and Mac users for their daily scripting needs, but what this will do is expand the portability and...

My 12 year old daughter will probably be posting the same question here a decade from now.

Steve Jones - SSC Editor (8/19/2016)

---

Eric M Russell (8/19/2016)

---

So, in a smoke test what you should really be looking for is not functionality... but smoke.

- If deploying a DDL...

A lot of us here became DBAs back when there weren't a lot of books on the topic. I'd start by looking at the eBooks published by Redgate and Brent...

So, in a smoke test what you should really be looking for is not functionality... but smoke.

- If deploying a DDL script, scroll through the output window and look...

My understanding is that, at least by default, when given a VARCHAR(MAX) column, SQL Server will only store the data offrow, if the total data size for a row doesn't...

You can use Project Parameters and Expressions to specify things like server names and network paths at runtime. The value of the parameter can be set from the job...

Government IT departments, at least at the state and federal level, are well funded, and IT platform tools they use are similar to what you would find in the corporate...

- Sometimes (usually not) an application will populate the Program property of the connection with something like the user's login name, so when qyerying the SQL Server connections DMV, examine...

When we talk about versioning and...

I've survived many rounds of layoffs at several different corporations, so I've been fortunate in that regard. What I've noticed is that the guy with the jack-of-all-trades or internal consultant...

SSIS does a good job of manipulating rows and columns within buffers as it moves through the pipeline, but sometimes loading the data into target table as fast as possible...

Every IT organization I've ever worked for has had a Patient/Customer/Student search application similar to this, and optimizing this type of thing is a classic problem. My default advice is...

Hi Rod,

Google: filetype:xlsx new mexico counties population

http://www.census.gov/popest/data/intercensal/county/tables/CO-EST00INT-01/CO-EST00INT-01-35.xls

As for your network connectivity issues, please email help desk support. 🙂

The same goes for non-clustered indexes; in terms of query predicates, column position in an index matters.