The reason that the 3rd example parameterizes your SQL is because it is generating a reusable query plan.

If you have a WHERE created_date>'2016-05-17' this will generate a different query...

Devs, infrastructure guys and DBAs have to work together to get this working and thus prove the value of DevOps.

Like all things if you adopt the disciplines and put in...

A side effect of having DB roles is that you have a common frame of reference to discuss business roles and how the business wishes to organise itself.

It's a useful...

kiwood (5/10/2016)

---

If you bothered to read the documentation you would know that for a given seed, RAND will produce the same sequence. This is by design. And as for .NET...

Hortonworks are pushing Apache Atlas as a tool to manage Enterprise metadata.

From what I can see so far it is very early days for this particular project.

I went to a...

Given the ascendency of data science I think there is scope for some articles utilising the different statiscal techniques.

I did enjoy the data mining series on this site.....

My experience so far is that some vendor solutions that rely on DBs are not cloud ready. If the apps aren't cloud ready then putting the DB in the...

It's interesting coming back to this editorial after 4 years.

I moved into a management position some time ago and from my perspective I was left to sink or swim. ...

Absolutely. A well maintained data dictionary is something that an organisation with mature data handling processes is likely to have.

Every trade has practices that craftsmen use and journeymen don't....

@gary posted a comment on SOLID principles and I think it's well worth reading a summary of those principles.

Two principles that I take to heart and apply to data are...

From a security perspective a vendor that is behind the curve with SP support when the SP plugs security weaknesses is a problem vendor.

Smaller vendors have a cost and logistics...

AWS are doing interesting stuff with lambda functions to allow stress testing of your equipment in the AWS cloud.

There are tools like Gatling explicitly to machine gun your infrastructure. ...

OK so it is port 80/443/8443 out to the web service. If a client of SQLServer calls SQLServer then ingress is on 1433 but we have to allow egress...

I'd be curious to know which ports and protocols have to be open in the firewall to allow SQL Server to use web services.

As far as I can tell TCP...

I've been playing around with Oracle Data Integrator, formerly Sunopsis. It is primarily an ELT tool rather than an ETL tool.

To be honest, most of the SSIS packages I've...