| Author |
 Topic  |
|
|
Curt
Moderator
USA
5634 Posts
Status: offline |
 Posted - 06/07/2005 : 02:52:32 AM
|
Michael Otey has an article in this month's isse of Windows IT Pro Magazine.
http://www.windowsitpro.com/Article/ArticleID/46265/46265.html#
For those with subscriptions, it is a good article for Windows IT administrators.
I had written the editors and told them of the audience they were missing. There are many Admins who do not want to be DBAs but need to maintain their SQL Servers.
I think we will see more of this.
|
Curt Spanburgh
Microsoft Certified Business Solution Specialist.
Dynamics CRM MVP
Contributing Editor, Windows IT Pro
(Romans 5:7) . . .For hardly will anyone die for a righteous [man]; indeed, for the good [man], perhaps, someone even dares to die.
|
|
|
cybersteve
Here To Stay
USA
284 Posts
Status: offline |
Posted - 06/07/2005 : 3:29:58 PM
|
Good call, Curt. The article set me in the right direction for further reading and study. Am not in the path to become a DBA, but I am responsible for supporting and administering SQL.
Thanks.
|
Cybersteve
"And so it goes..."
Kurt Vonnegut |
 |
|
|
werwar
Old Timer
United Kingdom
683 Posts
Status: offline |
Posted - 06/07/2005 : 7:41:33 PM
|
Nice one!
There must be 1000's of admins (like me) who are responsible for a whole rack of SQL servers (some business-critical) without being full-blown DBAs (and without the training to match).
Much of my SQL knowledge has been gained in the necessity is the mother of invention (or learning?) mould, so I don't have a good overall knowledge of how the beast works. This series should go a long way to resolving that.
Warwick |
|
|
|
IG88
Old Timer
Canada
523 Posts
Status: offline |
Posted - 05/05/2006 : 09:13:21 AM
|
werwar, I'm in a similar boat as you. We have a MSSQL DB since our CIS App moved to it, so now I have to support it etc, and I have zero DB experiance or training. All learned so far, the hard way. But I figure I might as well get more experiance and maybe try setting up a small inventory DB to get more hands on. I'd like to tie it into our SharePoint side (Running SBS2k3 Premium)if possible.
|
-=[ IG88 ]=-
General failure reading Hydro Bill: (I)gnore (B)orrow (G)et cut off. |
|
|
|
ptwilliams
Moderator
United Kingdom
4401 Posts
Status: offline |
|
|
joe_elway
Honorable But Hopeless Addict
Ireland
6673 Posts
Status: offline |
Posted - 05/08/2006 : 09:15:51 AM
|
Excellent idea Curt. Loads of us are forced into installing and managing SQL. It's only going to get "worse"... Exchange (eventually, maybe, possibly storing mailin SQL in V13), WinFS (eek!), everything having an MSDE or Express.
Don't forget Mark's MSDE newsletter from last year. |
Aidan Finn
MCSE, MVP (Virtual Machine: Systems Administration)
IT Blog: http://www.aidanfinn.com
My Photography: http://www.aidanfinnphoto.com/
My Hyper-V Book: Mastering Hyper-V Deployment
Twitter: http://twitter.com/joe_elway |
|
|
|
Wiseman82
Old Timer
United Kingdom
474 Posts
Status: offline |
Posted - 05/11/2006 : 1:47:59 PM
|
I found myself in a DBA position at my last company – mostly because I decided pick up a MCDBA qualification on the road to a MCSE. Nobody else had any DBA experience or knowledge of SQL Server, so the role of DBA defaulted to me. I’m now a full time DBA/Developer for a different organization.
SQL Server is gaining in popularity and I expect this trend will continue for quite some time. One reason for SQL Server’s popularity is the MSDE/Express versions of SQL Server– these are free enterprise class (entry level) database management systems. If you outgrow the limitations of these versions you have an easy upgrade path to Standard or Enterprise edition.
The older MSDE version of SQL server is been replaced by the new SQL Server 2005 Express – this version now has management tools (a feature seriously lacking in the MSDE version), the query governor has been removed and the database size has been up’d to 4Gb. The fact that the installation is a much smoother process, management tools have been included and the tighter integration with .NET will make SQL Server Express popular with both developers and System Admins (Even reluctant DBA’s should find SQL Express easier to manage)
Windows Vista’s file system is reported to be based on SQL technology – It’s not going to use SQL Express for obvious reasons (SQL Express requires a file system), but it makes sense for Microsoft to base its file system similar technology. I think for most people the change will be transparent – Microsoft isn’t going to force all of us to become part time DBA’s. When you run a search for a document you created a few months ago and the results are returned with a sub-second response time you might notice the lack of disk thrashing and the reduced time available for a coffee break. 
System Admis already manage databases whether they realise it or not– Active Directory and Exchange are both databases – I’d be surprised if these systems don’t already borrow at least some technology from SQL Server. It might make sense for Microsoft to actually use SQL Server for these products in the future, but I don’t think this will happen any time soon. I don’t think it’s viable for Microsoft to use the current versions of SQL Server for either of these products, particularly Active Directory.
It’s also worth noting that Microsoft isn’t the only company out there offering a free enterprise class dbms – Oracle and IBM also have free Express versions of their products, not to mention MySQL, PostgreSQL and a plethora of other free database systems out there.
|
David Wiseman
MCSE (2000/2003), MCSA (2003), MCDBA, MCITP:Database Administrator
 |
|
|
|
IG88
Old Timer
Canada
523 Posts
Status: offline |
Posted - 05/11/2006 : 6:16:03 PM
|
quote:
Originally posted by ptwilliams
Guys, there's a host of free online training available for SQL:
-- http://www.microsoft.com/sql/techinfo/training-courses.mspx
Correct me if I'm wrong but none of those courses are free, they are instructor led 3+ day programs |
-=[ IG88 ]=-
General failure reading Hydro Bill: (I)gnore (B)orrow (G)et cut off. |
|
|
|
Wiseman82
Old Timer
United Kingdom
474 Posts
Status: offline |
|
|
triangle
Welcome Newcomer
2 Posts
Status: offline |
Posted - 05/18/2006 : 10:13:39 AM
|
| WinFS is imho the really interesting structure. I've searched over to get more on it and came upon this http://www.ntfs.com/ You might wish to give it a glance. |
|
|
| |
Topic |
|
SQL Server 101
