Forum Replies Created
Viewing 15 posts - 46 through 60 (of 118 total)
-
RE: Code generation and any third party tools to generate SSIS packages
You may want to look at BIML, as that may offer the flexibility you're looking for. Check out John Welch's blog (http://www.agilebi.com/jwelch/%5B/url%5D) as he developed it. BIDS Helper[/url], a free...
=============================================================
/* Backups are worthless, Restores are priceless */Get your learn on at SQL University!
Follow me on Twitter | Connect on LinkedIn
My blog: http://sqlchicken.com
My book: Pro Server 2008 Policy-Based Management -
RE: shrink database clarifications
Also, because I include this picture in my presentations... http://twitpic.com/1gdrwv
Please think of the kittens...
=============================================================
/* Backups are worthless, Restores are priceless */Get your learn on at SQL University!
Follow me on Twitter | Connect on LinkedIn
My blog: http://sqlchicken.com
My book: Pro Server 2008 Policy-Based Management -
RE: shrink database clarifications
Read this blog series by Brent Ozar, he does a good job of explaining fragmentation: http://www.brentozar.com/archive/2009/02/index-fragmentation-findings-part-1-the-basics/ [/url]
http://www.brentozar.com/archive/2009/02/index-fragmentation-findings-part-2-size-matters/%5B/url%5D
Also check out this article by Paul Randal: http://technet.microsoft.com/en-us/magazine/2009.06.sqlqa.aspx
=============================================================
/* Backups are worthless, Restores are priceless */Get your learn on at SQL University!
Follow me on Twitter | Connect on LinkedIn
My blog: http://sqlchicken.com
My book: Pro Server 2008 Policy-Based Management -
RE: Missing Drive where SQL Server instance installed - Urgent help required
viduvs (6/16/2011)
I am going to use SQL Server management Studio to restore the database for point in time recovery.So should i first restore the full database backup and then transaction...
=============================================================
/* Backups are worthless, Restores are priceless */Get your learn on at SQL University!
Follow me on Twitter | Connect on LinkedIn
My blog: http://sqlchicken.com
My book: Pro Server 2008 Policy-Based Management -
RE: Missing Drive where SQL Server instance installed - Urgent help required
viduvs (6/16/2011)
One more thing.How do I retore the databases in order to recover the data?
As we have lost LUN, we don't have database running up to take tail log backup.
We...
=============================================================
/* Backups are worthless, Restores are priceless */Get your learn on at SQL University!
Follow me on Twitter | Connect on LinkedIn
My blog: http://sqlchicken.com
My book: Pro Server 2008 Policy-Based Management -
RE: Missing Drive where SQL Server instance installed - Urgent help required
viduvs (6/16/2011)
Thanks for your reply.I was having the same solution to install a new fresh instance and then configure the things.
Though we don't have a backup (even external backups), we...
=============================================================
/* Backups are worthless, Restores are priceless */Get your learn on at SQL University!
Follow me on Twitter | Connect on LinkedIn
My blog: http://sqlchicken.com
My book: Pro Server 2008 Policy-Based Management -
RE: Over my head...
Then it looks like you'll need to plan a downtime and patch that server to bring it up to proper patch level.
=============================================================
/* Backups are worthless, Restores are priceless */Get your learn on at SQL University!
Follow me on Twitter | Connect on LinkedIn
My blog: http://sqlchicken.com
My book: Pro Server 2008 Policy-Based Management -
RE: Migrate the DTS Pakages in sql server 2005 sp4
Do yourself a huge favor and check out (disclosure: I work for Pragmatic Works) DTSxChange. It will convert packages for you automatically. It will save you TONS of time/headache. Can...
=============================================================
/* Backups are worthless, Restores are priceless */Get your learn on at SQL University!
Follow me on Twitter | Connect on LinkedIn
My blog: http://sqlchicken.com
My book: Pro Server 2008 Policy-Based Management -
RE: SSRS Noob - Installed OK, but unable to administer due to permissions.
Open Internet Explorer using 'Run as Administrator' option and browse to your SSRS site (i.e. http://localhost/reports). Click on Site Settings at top right. Go to Security. Click new Role Assignment...
=============================================================
/* Backups are worthless, Restores are priceless */Get your learn on at SQL University!
Follow me on Twitter | Connect on LinkedIn
My blog: http://sqlchicken.com
My book: Pro Server 2008 Policy-Based Management -
RE: Policy Based Management - is it possible to combine Facets?
Here you go, wrote this up for you: Find Heaps Using Policy-Based Management[/url]
=============================================================
/* Backups are worthless, Restores are priceless */Get your learn on at SQL University!
Follow me on Twitter | Connect on LinkedIn
My blog: http://sqlchicken.com
My book: Pro Server 2008 Policy-Based Management -
RE: Difference between SQL server 2008 and SQL server 2008 R2
Dave Ballantyne (3/3/2011)
1 ) http://tinyurl.com/6fmaq32:Whistling:
=============================================================
/* Backups are worthless, Restores are priceless */Get your learn on at SQL University!
Follow me on Twitter | Connect on LinkedIn
My blog: http://sqlchicken.com
My book: Pro Server 2008 Policy-Based Management -
RE: The Spring Semester
Awesome, I'm glad you've found it useful. Thank you for your support!
=============================================================
/* Backups are worthless, Restores are priceless */Get your learn on at SQL University!
Follow me on Twitter | Connect on LinkedIn
My blog: http://sqlchicken.com
My book: Pro Server 2008 Policy-Based Management -
RE: The Spring Semester
Steve, thanks again for doing the write up on SQLU! Koen, if you like SSIS make sure you check out the great posts from the previous semesters especially Josef's series...
=============================================================
/* Backups are worthless, Restores are priceless */Get your learn on at SQL University!
Follow me on Twitter | Connect on LinkedIn
My blog: http://sqlchicken.com
My book: Pro Server 2008 Policy-Based Management -
RE: iPads for Christmas
Up until this point in my career I've been strictly an operational DBA for my organization(s). Now I've transitioned over to a consultant role wherein I'm travelling around interfacing with...
=============================================================
/* Backups are worthless, Restores are priceless */Get your learn on at SQL University!
Follow me on Twitter | Connect on LinkedIn
My blog: http://sqlchicken.com
My book: Pro Server 2008 Policy-Based Management -
RE: Please don’t Tweet this, but…
WayneS (9/6/2010)
That's not why I don't get on those sites. I'm one of those folks that are absolutely paranoid about protecting my personal identity... and all of those social networking...=============================================================
/* Backups are worthless, Restores are priceless */Get your learn on at SQL University!
Follow me on Twitter | Connect on LinkedIn
My blog: http://sqlchicken.com
My book: Pro Server 2008 Policy-Based Management
Viewing 15 posts - 46 through 60 (of 118 total)