I treat my Dev servers exactly the same as my Prod servers when it comes to backups and transaction logs and recovery models.  It's has saved dozens of days of...

The eventual plan is that @Filename will be the parameter in an SSIS package so I don't think there is any risk of SQL injection through the use of...

Thanks! Has anyone has any thoughts on Change Data Capture.  The CDC function is, probably similar to the transactional replication.  It is not the same, but it has...

Now THAT I'll mostly agree with.  The key is getting people to "use it right".  For example, at one company I do...

[...]

Entity Framework is a bit fat wrapper around ADO and it took Microsoft about seven releases to get something that was relatively stable. It is essentially another...

I'd recommend against implicit conversions wherever possible.  There are a lot of articles online about implicit conversion and even SQL Server, via the execution plan, will give a warning...

An alternative is to use the format function to convert it to a percentage.  Note that I'm only casting the FirstInteger to a decimal(18,10) because the SecondInteger is implicitly...

My biggest gripe about ORMs, especially old Linq To SQL (but not limited to that one), is datatype mismatches where the passed variables are NVARCHAR() as criteria to be played...

I cant provide anything specific to tables for sensitivity reasons but can explain in detail below.

TABLE1 has Y for Year and M for Month.  It also is the main...

Ok... trying again as a ZIP file...

Edit... looks like that did it.  Just double click on the link and an Explorer window should open up.  Double click on the .ppsx...

@stevec883 and anyone else interested...

I've extracted a section out of my "Black Arts" Index Maintenance #1 PowerPoint presentation and extracted it as a "slide show" so you don't actually need...

Look for the [DOWNLOAD] button at the following link...

https://github.com/bssug/PresentationDownloads/blob/master/20190521_JEFF_MODEN_BLACK_ARTS_INDEX_MAINT_03.zip

I don't write PowerPoint "presentations"... rather, I write highly animated PowerPoint "Books".  If you go into the "present" mode of the...

Excellent thanks. This clarifies a lot and I look forward to those articles.

It sounds like, after reading both posts (Jeff and Brian), that inserting data in the middle of...

Quick Follow Up Question:  The two sets of addresses and two sets of contact info for each applicant are obvious cues to normalize and create tables for each.

But everything...

Now,...