"There's also a weird mention of Fabric in the announcement, which doesn't seem to fit with the objective of the rest of article."

I think they just mention Fabric at every...

I've used the DevExpress tools for quite a few reports in the past. I used them in Winforms applications, but they have ASP.NET tools as well.

Code freezes are different where I work. They are periods where nothing (apart from emergency fixes) can be deployed due to business constraints, eg. end of year, end of tax...

It's not just different strokes for different folks; sometimes one "folk" wants different things at different times. There's a pub in my town that puts on live music and I...

BIN2 does distinguish between uppercase and lowercase, it just sorts them differently from CS collations.

Just in case someone comes here with a similar problem, the article below has an explanation of a possible scenario and the solution.

TRY_CAST Arithmetic Overflow Error - Purple Frog Systems

The decision on whether or not to pre-approve when I've suggested changes depends on a few things for me.

• How much do I trust that developer?
• How urgent is the...

I like this idea in theory, but it could cause a bit of drag in practice due to people having to re-skill. At my current employer, I started as a...

I tend to update SSMS fairly soon after the new version is announced. Same for the Red Gate add-ins.

For Visual Studio, I tend to wait quite a while because I...

If you drop the brackets around (2002 AS year), it would work. Alternatively, you could SELECT from the Books table first and then the SELECT against New would inherit the...

Removed duplicate post.

• This reply was modified 2 years ago by Chris Wooding.

The syntax I've used in the past for this type of thing is below. Because TRUNCATE needs higher permissions than DELETE, we had to create a special user for procedures...

There's nothing to stop you from having the normalised model and building a dimensional model on top of that. Then you have the best of both worlds when it comes...

I also think "We can't guess" is correct, but for a different reason. Rows could have been inserted by other users in the time between the insert statement and the...

You are declaring @TrackingNO as a variable when there is already a parameter by that name in the procedure declaration.