August 27, 2010 at 8:22 am
SQL has never had Incremental backups in the sense most people think it means, those are differentials. I think you will find they are using a confusing term to describe a file or filegroup backup.
I am most definitely a DBA. I get on with all developers except those who EXPECT me to be better at their job than they are, even though they spend all day doing it.
Does
Bugger
All
---------------------------------------------------------------------
August 27, 2010 at 8:27 am
One thing I've noticed as a consultant is that non-IT hiring managers and most consulting agencies have no idea what a DBA is. If they want someone to do anything at all with a database, they think they need a DBA. I think that not only do they understand the differences between administration and architecture, design and development, they don't know what the letters DBA stand for.
--------------------------------------
When you encounter a problem, if the solution isn't readily evident go back to the start and check your assumptions.
--------------------------------------
It’s unpleasantly like being drunk.
What’s so unpleasant about being drunk?
You ask a glass of water. -- Douglas Adams
August 27, 2010 at 8:32 am
To be fair, there are so many flavors of DBA that architecture / design could be considered part of a DBA's job in certain places.
August 27, 2010 at 8:38 am
Brandie Tarvin (8/27/2010)
To be fair, there are so many flavors of DBA that architecture / design could be considered part of a DBA's job in certain places.
True, the definitions could be better. My main complaint is how often I hear requests for DBAs and when they start listing the responsibilities, there's no administration anywhere in the job req. And if you're looking for a designer, it'll be harder to find one if you're concentrating on DBAs.
--------------------------------------
When you encounter a problem, if the solution isn't readily evident go back to the start and check your assumptions.
--------------------------------------
It’s unpleasantly like being drunk.
What’s so unpleasant about being drunk?
You ask a glass of water. -- Douglas Adams
August 27, 2010 at 8:40 am
Stefan Krzywicki (8/27/2010)
One thing I've noticed as a consultant is that non-IT hiring managers and most consulting agencies have no idea what a DBA is. If they want someone to do anything at all with a database, they think they need a DBA. I think that not only do they understand the differences between administration and architecture, design and development, they don't know what the letters DBA stand for.
DBAs
Build
Anything
August 27, 2010 at 8:52 am
Brandie Tarvin (8/27/2010)
Odd. I remember studying incremental backups when I took my SQL 2000 cert test. Maybe 2000 got rid of it and SQL 7 had it, but there were incremental backups in SQL Server at some point.
Ditto - but it was a part of the OS exams required for the cert.
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
August 27, 2010 at 8:56 am
Stefan Krzywicki (8/27/2010)
Brandie Tarvin (8/27/2010)
To be fair, there are so many flavors of DBA that architecture / design could be considered part of a DBA's job in certain places.True, the definitions could be better. My main complaint is how often I hear requests for DBAs and when they start listing the responsibilities, there's no administration anywhere in the job req. And if you're looking for a designer, it'll be harder to find one if you're concentrating on DBAs.
Data
Base
Architect
I am not a DBA...
but get tasked with some of the same tasks.
And whatever else they can throw at me.
And I also have people telling me I have to dump the results to Excel, and consider it secure, even withour DRM, as changing it could result in dismissal.
I'd love to be around when the process gets audited.
Greg E
Greg E
August 27, 2010 at 8:57 am
Anyone know how to get SQL Server 2008 R2 Developer Edition without an MSDN subscription? I'm been searching and searching without any luck.
For best practices on asking questions, please read the following article: Forum Etiquette: How to post data/code on a forum to get the best help[/url]
August 27, 2010 at 8:59 am
Steve Jones - Editor (8/27/2010)
AFAIR, Incrementals haven't been a part of SQL Server. Perhaps in v4.2, can't remember that far, but I think it was always diff in SQL, incremental in Windows, which was confusing. The docs for 7 / v6.5 aren't online. SQL2K shows this: http://msdn.microsoft.com/en-us/library/aa196675%28v=SQL.80%29.aspxI think that the exams might have referred to incrementals as the people writing them looked at backup technology which tends to use that terminology. Why SQL changed is beyond me.
It would be nice if both backups performed the same thing (a diff since the last backup whether full or diff/incremental).
I will check my 6.5 instance later to see what the backups were on it for sure - but if memory serves correctly from those exams it was also differential and not incremental.
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
August 27, 2010 at 9:03 am
Alvin Ramard (8/27/2010)
Anyone know how to get SQL Server 2008 R2 Developer Edition without an MSDN subscription? I'm been searching and searching without any luck.
This is a decent list of places that claim to sell it
I say "claim" because I haven't checked the links.
--------------------------------------
When you encounter a problem, if the solution isn't readily evident go back to the start and check your assumptions.
--------------------------------------
It’s unpleasantly like being drunk.
What’s so unpleasant about being drunk?
You ask a glass of water. -- Douglas Adams
August 27, 2010 at 9:08 am
CirquedeSQLeil (8/27/2010)
Steve Jones - Editor (8/27/2010)
AFAIR, Incrementals haven't been a part of SQL Server. Perhaps in v4.2, can't remember that far, but I think it was always diff in SQL, incremental in Windows, which was confusing. The docs for 7 / v6.5 aren't online. SQL2K shows this: http://msdn.microsoft.com/en-us/library/aa196675%28v=SQL.80%29.aspxI think that the exams might have referred to incrementals as the people writing them looked at backup technology which tends to use that terminology. Why SQL changed is beyond me.
It would be nice if both backups performed the same thing (a diff since the last backup whether full or diff/incremental).
I will check my 6.5 instance later to see what the backups were on it for sure - but if memory serves correctly from those exams it was also differential and not incremental.
As far as I remember 6.5 only had full and tran log backups.
please read my previous post for what an incremental backup is in MSSQL terms. (at least on the blog Brandie referred to)
---------------------------------------------------------------------
August 27, 2010 at 9:08 am
Stefan Krzywicki (8/27/2010)
One thing I've noticed as a consultant is that non-IT hiring managers and most consulting agencies have no idea what a DBA is. If they want someone to do anything at all with a database, they think they need a DBA. I think that not only do they understand the differences between administration and architecture, design and development, they don't know what the letters DBA stand for.
I have noticed the same thing. All things database means DBA.
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
August 27, 2010 at 9:09 am
Stefan Krzywicki (8/27/2010)
Alvin Ramard (8/27/2010)
Anyone know how to get SQL Server 2008 R2 Developer Edition without an MSDN subscription? I'm been searching and searching without any luck.This is a decent list of places that claim to sell it
I say "claim" because I haven't checked the links.
Thanks Stefan. Now why did those links not come up in my search?
Anyone know if 2008 Dev can be upgraded to 2008 R2 Dev for free. MS website does not appear to have the info.
For best practices on asking questions, please read the following article: Forum Etiquette: How to post data/code on a forum to get the best help[/url]
August 27, 2010 at 9:11 am
Ditto on the links thanks. I need to buy myself a copy.
August 27, 2010 at 9:11 am
My title is DB Architect but what they really needed was somebody to do db dev, db admin, and db architect.
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
Viewing 15 posts - 17,821 through 17,835 (of 66,712 total)
You must be logged in to reply to this topic. Login to reply