You may have something very granular or customizable planned in terms of your scripting effort so this may not be applicable, or these options may not satisfy your requirements, but...

Letting SQL Server use as much memory as possible for the buffer pool (max memory setting only controls buffer pool size) while allowing for the SQL Server processes themselves, the...

I just tested to make sure and people in the SQLAgentReaderRole or SQLAgentOperatorRole can see the execution status of jobs, even ones they do not own, using the Job Activity...

Convince? No. Convincing is your job, not mine 🙂 My job is to evaluate all...

CozyRoc (6/28/2012)

---

Regarding COZYROC's components, it is puzzling why you wouldn't at least out of curiosity check what is available? It is free to test and play inside Visual Studio (BIDS)....

CozyRoc (6/28/2012)

---

Oh, boy. Saying VB.NET is the new version of VB6 is like saying VB Script is VB6-light. VB.NET is very different language and comparing to VB6 or even implying...

There was a new version of VB6. It was called VB.net, i.e. Visual Basic 7.0, and legions of VB6 developers and the companies they work for have since rejected it....

It is a big topic. Here is an architecture document Microsoft produced in 2006 that I can recommend to you to help familiarize yourself with the options. It is based...

I see you're relatively new to SSC, welcome. At first glance your question has a simple answer, but it is not a simple affair. You can change a column's data...

Is the ODBC CozyRoc Destination supported by MySQL or Microsoft?

Is the ODBC CozyRoc Destination free?

- Does it support...

Why not? Do you know of anything wrong with this one? MySQL OLE DB Provider

Use with DTS/SSIS

Since we're mixing the technologies in with the forum we're in I'll throw one more alternative out there. You could likely do everything you need with a single line of...

Database last accessed time

This is an article Kim linked to in her connect item to demonstrate some of the current, limited, set of options: When was my database / table...

SQL Server Execution Plans By Grant Fritchey

Buy it from Amazon too 😉

bothap (6/27/2012)

---

Good day,

I've been looking around on the internet and there are several articles around for high-availability, though not so much on easy maintainable load-balancing clusters.

Any ideas to the problem...