[Vent] SQL Server Upgrade

It just occurred to the suits recently that the 240 GB is not enough, so
what did they do?
Change the RAID configuration?!? NO!
Get more drives for the RAID 10 stack?!? NO!
They bought a SATA drive and wired it to the SQL Server with a USB
connector.
And now there's an email storm going on about how slow the backups are.
<bonking head on desk>
Is it ironic poetry that my computer at home that I designed and built to
play doom has twice the speed and twice the capacity of the Big Momma SQL
Server at work?!? YES!
Suits and computers should never *EVER* mix.
Peace & happy computing,
Mike Labosh, MCSD
"Musha ring dum a doo dum a da!" -- James HetfieldMike,
At some point, you should start thinking about your future. It's going to b
e pretty hard to get another job with this kind of resum stain.
Regards,
Brian Selzer
"Mike Labosh" <mlabosh@.hotmail.com> wrote in message news:uhOzmM#rFHA.3788@.TK2MSFTNGP12.phx
.gbl...
> It just occurred to the suits recently that the 240 GB is not enough, so
> what did they do?
>
> Change the RAID configuration?!? NO!
> Get more drives for the RAID 10 stack?!? NO!
>
> They bought a SATA drive and wired it to the SQL Server with a USB
> connector.
>
> And now there's an email storm going on about how slow the backups are.
>
> <bonking head on desk>
>
> Is it ironic poetry that my computer at home that I designed and built to
> play doom has twice the speed and twice the capacity of the Big Momma SQL
> Server at work?!? YES!
>
> Suits and computers should never *EVER* mix.
>
> --
> Peace & happy computing,
>
> Mike Labosh, MCSD
> "Musha ring dum a doo dum a da!" -- James Hetfield
>
>|||I wanted to change the world. But I have found that the only thing one can
be sure of changing is oneself.
- Aldous Huxley
"Mike Labosh" <mlabosh@.hotmail.com> wrote in message
news:uhOzmM%23rFHA.3788@.TK2MSFTNGP12.phx.gbl...
> It just occurred to the suits recently that the 240 GB is not enough, so
> what did they do?
> Change the RAID configuration?!? NO!
> Get more drives for the RAID 10 stack?!? NO!
> They bought a SATA drive and wired it to the SQL Server with a USB
> connector.
> And now there's an email storm going on about how slow the backups are.
> <bonking head on desk>
> Is it ironic poetry that my computer at home that I designed and built to
> play doom has twice the speed and twice the capacity of the Big Momma SQL
> Server at work?!? YES!
> Suits and computers should never *EVER* mix.
> --
> Peace & happy computing,
> Mike Labosh, MCSD
> "Musha ring dum a doo dum a da!" -- James Hetfield
>|||And this company you're at is actually making money?
How?
ML|||> At some point, you should start thinking about
> your future. It's going to be pretty hard to get
> another job with this kind of resum stain.
Or "shit stain"?
My major malfunction is that I love my work too much to leave it. :( The
only good part is that I have at least identified what my own malfunction
is.
--
Peace & happy computing,
Mike Labosh, MCSD
"Musha ring dum a doo dum a da!" -- James Hetfield|||The 2005 certs will be available soon, so you have something to occupy the
time while you wait for the power systems to come back online. ;-)
"Mike Labosh" <mlabosh@.hotmail.com> wrote in message
news:ez2GQ4%23rFHA.1168@.TK2MSFTNGP11.phx.gbl...
> Or "shit stain"?
> My major malfunction is that I love my work too much to leave it. :( The
> only good part is that I have at least identified what my own malfunction
> is.
> --
> Peace & happy computing,
> Mike Labosh, MCSD
> "Musha ring dum a doo dum a da!" -- James Hetfield
>|||>I wanted to change the world. But I have found that the only thing one can
>be sure of changing is oneself.
> - Aldous Huxley
Whhhooooooo! That was actually quite profound. Who is this Aldous Huxley
person?
--
Peace & happy computing,
Mike Labosh, MCSD
"Musha ring dum a doo dum a da!" -- James Hetfield
"JT" <someone@.microsoft.com> wrote in message
news:uB%23siy%23rFHA.3732@.TK2MSFTNGP11.phx.gbl...
> "Mike Labosh" <mlabosh@.hotmail.com> wrote in message
> news:uhOzmM%23rFHA.3788@.TK2MSFTNGP12.phx.gbl...
>|||> And this company you're at is actually making money?
Who knows?

> How?
Perhaps by sacrificing live chickens over the SQL Server?! (just my guess)
Peace & happy computing,
Mike Labosh, MCSD
"Musha ring dum a doo dum a da!" -- James Hetfield|||http://www.quotationspage.com/quotes/Aldous_Huxley/
http://huxley.net/index.html
http://huxley.net/bnw/index.html
"Mike Labosh" <mlabosh@.hotmail.com> wrote in message
news:%23l6h%23L$rFHA.308@.TK2MSFTNGP10.phx.gbl...
> Whhhooooooo! That was actually quite profound. Who is this Aldous Huxley
> person?
> --
> Peace & happy computing,
> Mike Labosh, MCSD
> "Musha ring dum a doo dum a da!" -- James Hetfield
> "JT" <someone@.microsoft.com> wrote in message
> news:uB%23siy%23rFHA.3732@.TK2MSFTNGP11.phx.gbl...
>|||> Perhaps by sacrificing live chickens over the SQL Server?! (just my guess
)
Aha! That would explain slow backups! Chicken guts in the air vents! Quite
common...
ML

[help] SSIS File Configuration (XML)

We are deploying our SSIS packages into different folders. For example:
\Test1
\test2
\production

Test1 points to the Test1 database, etc.

So, I configured my SSIS package to use a database connection called dbMAIN.

I then setup the SSIS File Configuration (XML) so that "dbMain" points to Test1. This xml file, called Global.dtsConfig, sits in C:\test1\, the same place as my ssis.dtsx file.

I want to copy my dtsx file and my dtsconfig file into \test2 and \production. The problem is that the the location of dtsconfig is HARDCODED in the ssis package!

How do I dynamically change it?

I tried to hardcode the location to ".\Global.dtsconfig", but that did not work! Please advise!I found the solution. When you call an executable, you can use the /ConfigFile option. Example:

dtexec.exe /file "d:\myFile.dtsx" /configfile "d:\test1\Test1.dtsconfig"

When myfile.dtsx is run, it will use the test1.dtsconfig file to get all of its configurations.

Hooah!

~Le

[HELP] How can I start an Analysis Services service

Hi all,

at Surface Area Configuration in my SQL Server 2005 I noticed that I have Database Engine, Reporting Services and SQL Server Browser services. I want to deploy a cube modelled at SQL Server Business Intelligence Development Studio and I'm getting connection errors.

I checked at Management Studio that I don't have an instance of Analysis Services. Only Database Engine and Reporting Services.

How can I create an instance of Analysis Services.

Does anyone could help me please?

Thanks a lot.

Another way to verify if you have Analysis Services installed or not, is to look in Services for "SQL Server Analysis Services". To install it, re-run the Setup and there is an option for Analysis Services.

Adrian Dumitrascu