This is not intended as a generic script you can just copy, paste, and run and get results. It needs a little light editing to make it work in...

I too have just completed developing a replacement backup process. The databases (around 45 of them across 2 servers, serviced via batch processing) are all BI related, and very...

We store ALL database code in Microsoft's Team Foundation Server (TFS), but we could just as easily gone with Subversion or GIT.

Why? History, my man. We have the...

I have very fond memories of MS Access (starting with 2.0 and ending with 2000). Working for an international insurance company, and in the days before the Internet really...

I am a BI developer first and foremost, but spent 100% of my time working in and with SQL Server.

I QA a lot of code before it is released to...

A more mundane aspect of virtualization is Windows licensing. Windows licenses are 'attached' to the physical host, not the VM, and each physical host has to be licensed for...

Regardless of whether or not this is a "bright idea", it's a little worrying that the developer did not know enough to approach the problem for themself, or have the...

Maybe this will help. I have just been through the process of trying to work out the licensing model for the servers I support as they are virtuals running...

My effort looks very much like the triangular join running total - that's not good. I like the Quirky Update - I've used this approach for concatenating strings before...

I got made redundant 18 months ago when the entire Systems Department (around 83 people) was outsourced to two third party companies. My current employer has a much more...

After many years of SQL and SSRS development we brought a dedicated QA resource into the team (comprising 3 developers and 1 Business Analyst). We took a big hit...

Apologies, I may have introduced an unnecessary "thought" by bringing partitioning into this thread. Partitioning[/url] is applied at the table level and the different partition schemes linked to different...

Is the database partitioned? From the error message it looks like it may be (both NRJData_Data3 and NJRData_Data claiming MDS2DataED.mdf). If this is the case then it may...

Maybe you could try the VB equivalent of CHARINDEX which is INSTR. Yes, the search is in a single string rather than separate values, but if they are still...

I too learned something new today about something I didn't even know existed (NULL bitmap).

Excellent question.

JR