Results 1 to 5 of 5

Thread: Just got a job as an SQL Server DBA, need some literature

  1. #1
    Throbbing Member
    Join Date
    Aug 2004
    Location
    Scotlandshire
    Posts
    633
    Thanks
    15
    Thanked
    9 times in 8 posts
    • 8bit's system
      • Motherboard:
      • MSI Z170A-G43 PLUS
      • CPU:
      • Intel i7-6700K
      • Memory:
      • 2x Kingston HyperX Fury Black (8GB)
      • Storage:
      • 1x Crucial MX100 512GB, 1x Western Digital Caviar Black 1TB (WD1001FALS)
      • Graphics card(s):
      • Sapphire AMD R9 390 Nitro
      • PSU:
      • Corsair RM650x
      • Case:
      • Corsair Carbide Air 540
      • Operating System:
      • Windows 10 Home
      • Monitor(s):
      • LG 29UM67 29", 21:9, 2560x1080
      • Internet:
      • PlusNet Fibre

    Just got a job as an SQL Server DBA, need some literature

    Hi all,

    I just got offered a job as an SQL Server DBA. I've done a good bit of this in my last place of work but their setup is on a much smaller scale than this place. Specifically, I need to bone up on on Data Warehousing, index/query optimisation and OLAP. Can anyone recommend any good books, ebooks or websites on the above subjects?

    TIA
    8bit
    "shiro" - Windows 10 Home x64 :: Intel i7-6700K :: Corsair Hydro H90 :: MSI Z170A-G43 Plus :: 2x 8GB Kingston HyperX :: NVidia 3070 FE :: Corsair Force MP600 (1TB) :: Crucial MX100 (512GB) :: WD Caviar Black (1TB) :: Lite-On BD-ROM :: Corsair Carbide Air 540 (white) :: LG 32QK500 2560x1440 :: Logitech M500 :: Cherry KC6000 Slim ::

  2. #2
    Fried Chip Extremist alsenior's Avatar
    Join Date
    Nov 2005
    Location
    Stafford
    Posts
    2,949
    Thanks
    103
    Thanked
    191 times in 145 posts
    • alsenior's system
      • Motherboard:
      • DFI Lanparty Jr x58-T3H6
      • CPU:
      • Core i7 920
      • Memory:
      • 6 x 2GB ocz Gold
      • Storage:
      • 1 TB Samsung F3
      • Graphics card(s):
      • 1gb 4890 vapor-x xfire
      • PSU:
      • xfx 850W
      • Case:
      • Lian-li Pc7
      • Operating System:
      • Windows 7 X64
      • Monitor(s):
      • Dell 2208WFP
      • Internet:
      • 30mb Virgin media
    you dont say which server types ypur on (mssql,oracle,mysql,progress)
    but i can give you one peice of advice across the board
    don't type drop
    Last edited by alsenior; 10-06-2006 at 08:11 AM.
    Quote Originally Posted by Jay View Post
    What kind of emergency would need Windows 95? I think you are already in a bad state of emergency when your backup plan is Windows 95.
    Beginners guide to raid Beginners guide to raid post edition Hexus.Social - FAQ

  3. #3
    Comfortably Numb directhex's Avatar
    Join Date
    Jul 2003
    Location
    /dev/urandom
    Posts
    17,074
    Thanks
    228
    Thanked
    1,027 times in 678 posts
    • directhex's system
      • Motherboard:
      • Asus ROG Strix B550-I Gaming
      • CPU:
      • Ryzen 5900x
      • Memory:
      • 64GB G.Skill Trident Z RGB
      • Storage:
      • 2TB Seagate Firecuda 520
      • Graphics card(s):
      • EVGA GeForce RTX 3080 XC3 Ultra
      • PSU:
      • EVGA SuperNOVA 850W G3
      • Case:
      • NZXT H210i
      • Operating System:
      • Ubuntu 20.04, Windows 10
      • Monitor(s):
      • LG 34GN850
      • Internet:
      • FIOS
    or exec

  4. #4
    Comfortably Numb directhex's Avatar
    Join Date
    Jul 2003
    Location
    /dev/urandom
    Posts
    17,074
    Thanks
    228
    Thanked
    1,027 times in 678 posts
    • directhex's system
      • Motherboard:
      • Asus ROG Strix B550-I Gaming
      • CPU:
      • Ryzen 5900x
      • Memory:
      • 64GB G.Skill Trident Z RGB
      • Storage:
      • 2TB Seagate Firecuda 520
      • Graphics card(s):
      • EVGA GeForce RTX 3080 XC3 Ultra
      • PSU:
      • EVGA SuperNOVA 850W G3
      • Case:
      • NZXT H210i
      • Operating System:
      • Ubuntu 20.04, Windows 10
      • Monitor(s):
      • LG 34GN850
      • Internet:
      • FIOS
    Quote Originally Posted by alsenior
    you dont say which server types ypur on (mssql,oracle,mysql,progress)
    but i can give you one peice of advice across the board
    don't type drop
    SQL Server with capitals is mssql

  5. #5
    Throbbing Member
    Join Date
    Aug 2004
    Location
    Scotlandshire
    Posts
    633
    Thanks
    15
    Thanked
    9 times in 8 posts
    • 8bit's system
      • Motherboard:
      • MSI Z170A-G43 PLUS
      • CPU:
      • Intel i7-6700K
      • Memory:
      • 2x Kingston HyperX Fury Black (8GB)
      • Storage:
      • 1x Crucial MX100 512GB, 1x Western Digital Caviar Black 1TB (WD1001FALS)
      • Graphics card(s):
      • Sapphire AMD R9 390 Nitro
      • PSU:
      • Corsair RM650x
      • Case:
      • Corsair Carbide Air 540
      • Operating System:
      • Windows 10 Home
      • Monitor(s):
      • LG 29UM67 29", 21:9, 2560x1080
      • Internet:
      • PlusNet Fibre
    Sorry yes, it's MS SQL Server 2000 & 2005. Thx for the advice on DROP

    To reiterate, I'm looking for books which cover some of the more advanced MS SQL Server stuff like OLAP, Data Warehousing, index and query optimisation etc. Surely there must be another SQL Server DBA in the house?!?

    TIA
    8bit
    "shiro" - Windows 10 Home x64 :: Intel i7-6700K :: Corsair Hydro H90 :: MSI Z170A-G43 Plus :: 2x 8GB Kingston HyperX :: NVidia 3070 FE :: Corsair Force MP600 (1TB) :: Crucial MX100 (512GB) :: WD Caviar Black (1TB) :: Lite-On BD-ROM :: Corsair Carbide Air 540 (white) :: LG 32QK500 2560x1440 :: Logitech M500 :: Cherry KC6000 Slim ::

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. MS launches SQL Server 2005, Visual Studio
    By Steve in forum HEXUS News
    Replies: 4
    Last Post: 07-11-2005, 12:33 PM
  2. SQL Server 2000
    By Fatboy in forum Software
    Replies: 37
    Last Post: 17-08-2005, 07:05 PM
  3. SQL Server 2000 SP3 Problems
    By Vini in forum Software
    Replies: 3
    Last Post: 17-08-2005, 10:52 AM
  4. SQL Server Connection string?
    By Stoo in forum Software
    Replies: 7
    Last Post: 04-05-2005, 05:48 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •