PRESS RELEASE: INTERFACE ACQUIRES CENTRIQ'S CORPORATE
IT TRAINING BUSINESS - WE ARE EXPANDING!   (Jan 5, 2023)
Interface and Centriq Logos
LEARN MORE
1-800-264-9029|602-266-8500
  • Course Schedule
    • Microsoft Training
      • Microsoft Fundamentals Training
      • Windows Client
      • Teams
      • Teams / Microsoft 365 / MS365
      • Windows Server 2019
      • SQL Server Transact-SQL
      • SQL Server Administration
      • SQL Server Business Intelligence
      • Power BI
      • Power Platform
      • Azure
      • Data Engineering / Machine Learning
      • Artificial Intelligence (AI)
      • M365 Messaging
      • PowerShell
      • System Center
      • SharePoint
      • Microsoft Security
    • Cloud Computing
      • Azure
      • Amazon Cloud (AWS)
    • Developer Training
      • DevOps
      • Web Development
      • .NET Development and Visual Studio
      • Java Programming
      • Python
    • Cisco Training
      • Cisco CCNA
      • Cisco Routing and Switching
      • Cisco Security
      • Cisco Wireless
      • Cisco Data Center and Storage
      • Cisco Collaboration
      • Cisco Contact Center
      • Cisco DevNet
    • CompTIA Certification
      • CompTIA A+
      • CompTIA CASP+
      • CompTIA Linux+
      • CompTIA Network+
      • CompTIA Project+
      • CompTIA Security+
    • Business Training
      • Project Management
      • ITIL
      • NIST
      • Business Analysis (PBA & CBAP)
      • Agile
    • Security Training
      • ISC2
      • Microsoft Security
      • CompTIA Security
      • NIST
      • Cisco Security
    • Wireless Training
      • Wireless Networking
    • Other Training
      • VMware
      • NetApp
      • F5 Networks
      • Citrix
      • Microsoft Excel
  • Exams
    • Student Pricing
  • Subscriptions
  • Interface Gold
    • RemoteLive™
    • Replay™
    • Interface Gold™ Benefits
  • On-Demand
  • Resources
    • Tech Blogs
    • Tech Videos
    • Microsoft Learn Catalog
  • About
    • Instructors
    • Interface TechPak
    • Group Training & Private Classes
    • Contact

How to Administer a SQL Azure Database?

Home > Blogs > SQL Server > How to Administer a SQL Azure Database?

How to Administer a SQL Azure Database?

Like This Blog 1 Don Jones
Added by Don Jones May 7, 2013

As Microsoft continues to develop and promote their cloud-based SQL services, database administrators will have to become adept at administering their company’s Azure-based assets. If you’re a “reluctant DBA” – someone tasked with managing databases just because you’re “the Microsoft person” in your environment and not because you have any DBA training – Azure can seem especially intimidating.

Don’t worry. SQL Azure really is good old SQL Server, just with a few tweaks to make it work better in the cloud. You’ll use essentially the same tools that you always have, including the graphical SQL management console that you’d use to manage an on-premise SQL installation.

There are just a few differences. For example, in SQL Server, you manage server-level security through the “Security” folder in the graphical SQL Server Management Studio; in SQL Azure, you make server-level security changes directly to your organization’s “master” database. That means you’ll need to become more accustomed to the Transact-SQL commands used to manage security. For example, rather than graphically creating login accounts, you’ll have to use the CREATE LOGIN T-SQL command. Keep in mind that SQL Server Management Studio can help teach you T-SQL! For example, I always keep a local copy of the databases that I work with, so that I have something to test with. When I need to create a login, I create one locally, and then right-click the finished login to script the object. Doing so displays the T-SQL command that can be run on Azure to create the same login, with the same options.

There are a few administrative tasks you’ll never have to worry about with Azure. Because it’s designed to abstract the underlying hardware, you won’t worry about things like hard drives, file groups, and so forth. You’ll create your databases on a single file, and Azure will worry about where that file physically lives. For that same reason, you’ll never have to worry about an NTFS-level defragmentation of your databases – although you will have to worry about keeping the database internally defragmented, just as you do with a local SQL Server install.

Most database tasks will be exactly the same, such as reorganizing and rebuilding indexes, index tuning for performance, and so forth. Backups work pretty much the same, too, although you’ll need to carefully consider your use of full and differential backups since those will consume bandwidth, which you pay for in Azure.

Some high-level administrative tasks – such as creating new databases – is handled via Azure’s Web-based management interface. This is where you can get the virtual server name that has been assigned to you – and you’ll need that in order to hook up your traditional management tools. You’ll also get to see where your server is physically housed, such as in the “Anywhere Europe” datacenter. It can be important that you provision all of your organization’s virtual servers in the same datacenter as much as possible; you’ll pay for data transfer fees if servers in different datacenters need to communicate.

You also pay for disk space in Azure, meaning you should provision your databases with the very smallest file size they’ll need in order to accommodate your organization’s needs. Don’t provision a 80GB database if you only need 10GB! You pay for the entire database size, even if you’re only using a portion of it. Also keep in mind that database billing is in specific increments – a 22Gb database is billed at 30GB, for example.

That Web-based console also enables you to manage your virtual servers’ firewall settings – the Azure equivalent of the Windows Firewall, essentially. You can define rules that enable your users, and nobody else, to communicate with your databases.

You’ll find additional resources – including some great administrative walkthroughs – on sites like SQLServerPedia – SQL Azure Administration and Microsoft – Windows Azure SQL Database Overview. With a little bit of practice, you’ll be commanding SQL Azure just as confidently as you do your on-premise SQL Server instances.

Enjoy,

Don Jones
PowerShell and SQL Instructor – Interface Technical Training
Phoenix, AZ

Subscribe to this author's posts feed via RSS

You May Also Like

  • On the Topic of Mastery
    On the Topic of Mastery
  • Project Management PMP - Creating a Schedule Using Automated (software) Tools
    Project Management PMP - Creating a Schedule Using Automated…
  • Securing Your Small Office Systems
    Securing Your Small Office Systems
  • Installing DNS from scratch on a Windows Server
    Installing DNS from scratch on a Windows Server
Category SQL Server

Tags

Azure, cloud computing, CREATE LOGIN T-SQL, Database Administrator, DBA, SQL Azure, SQL Server, SQL Server Management Studio, Windows Firewall

Videos You May Like

Cable Testers and How to Use them in Network Environments

Cable Testers and How to Use them in Network Environments

0 645 1

This content is from our CompTIA Network + Video Certification Training Course. Start training today! In this video, CompTIA Network + instructor Rick Trader demonstrates how to use cable testers in network environments. Let’s look at some tools that we can use to test our different cables in our environment. Cable Testers Properly Wired Connectivity … Continue reading Cable Testers and How to Use them in Network Environments

Configuring Windows Mobility Center and How to Turn it On and Off

Configuring Windows Mobility Center and How to Turn it On and Off

1 1402 1

Video transcription Steve Fullmer: In our Windows training courses, we often share information about the Windows 8.1 Mobility Center. Mobility Center was introduced for mobile and laptop devices in Windows 7. It’s present and somewhat enhanced in Windows 8. Since we don’t have mobile devices in our classrooms, I decided to take a little bit … Continue reading Configuring Windows Mobility Center and How to Turn it On and Off

How to create a Cisco IOS Banner – Login and MOTD Message of the Day

How to create a Cisco IOS Banner – Login and MOTD Message of the Day

0 4140 4

In this video, Cisco CCNA instructor Mark Jacob shows how to create a Login and Message of the Day (MOTD) banners in Cisco IOS. The Banner is an interesting feature of the Cisco IOS. You could probably get by without it, but in a commercial environment you want to have it.

Write a Comment

See what people are saying...

    Share your thoughts...

    Please fill out the comment form below to post a reply.

    Microsoft Subscription

    Blogs by Technology

    • Amazon AWS (2)
    • Azure Cloud Computing (2)
    • Business Analysis (8)
    • Cisco (125)
    • CompTIA (71)
    • Developer Visual Studio / ASP.NET (62)
    • Exchange Server (47)
    • ITIL / COBIT (33)
    • Lync Server (3)
    • Office 365 (5)
    • PMP Project Management (63)
    • PowerShell (81)
    • Security (47)
    • SharePoint (93)
    • SQL Server (78)
    • System Center (13)
    • Web Development (60)
    • Windows 10 (65)
    • Windows 7 (124)
    • Windows 8 (85)
    • Windows Server (74)
    • Windows Server 2012 (90)
    • Windows Server 2016 (14)
    • Wireless (9)
    • Wireshark (5)

    Blogs by Instructor

    • Dan Wahlin (44)
    • Don Jones (15)
    • Dr. Avril Salter (6)
    • Greg Richard (1)
    • Interface (49)
    • Jason Helmick (38)
    • Jeff Jones (18)
    • Jeremy Cioara (8)
    • Mark Jacob (128)
    • Mark Thomas (28)
    • Mike Danseglio (93)
    • Mike Pfeiffer (35)
    • Peter Avila (32)
    • Rick Trader (127)
    • Spike Xavier (86)
    • Steve Fullmer (163)
    • Suzanne Van Hove (1)

    Blogs You May Like

    • The Easy Way to Convert Decimal Numbers to Binary Numbers and Back Again
    • Cisco CCNA and CCNP Certification Update 2019 – 2020
    • How to use File Hashing and Integrity Monitoring Algorithms for File Validation using Certutil MD5 and WinMD5Free
    • Installing DNS from scratch on a Windows Server
    • Understanding Network Cable Testers
    • On the Topic of Mastery

    Video Courses

    • ITIL 4 Foundation Certification Video Training Course
    • Project Management Professional (PMP®) Certification Video Training PMBOK® 6th Edition
    • PMI-PBA Business Analysis for IT Analysts and Project Managers (PMI-PBA)® Certification
    • SharePoint Designer 2013 for American Express
    • CompTIA Network+ (Coming Soon!)
    • CompTIA Security+ (Coming Soon!)
    • CompTIA A+ Certification Core 1 1001 (Coming Soon)
    • CompTIA A+ Certification Core 2 1002 (Coming Soon)

    Live Training Courses

    • NET+007: CompTIA Network+ Certification Training + N10- 007 Exam
    • PowerShell - 10961: Automating Administration with Windows PowerShell
    • ITIL4® Foundation Certification Course with Exam
    • AZ-100: Azure Infrastructure and Deployment Training
    • PMI-PBA: Business Analysis for IT Analysts and Project Managers (PMI-PBA Certification)
    • Cisco CCNA - ICND1v3 Interconnecting Cisco Networking Devices CCNA Part 1
    • COBIT205: COBIT® 5 Foundation and Implementation IT Governance Training
    • DEV415: Microservices with ASP.NET Core and Docker
    • IT Security - SEC+501: CompTIA Security+ with Certification Exam SY0-501
    • SQL Server - SQL101: Introduction to Transact SQL
    Facebook
    Twitter
    Linked In
    Comment
    EMAIL

    About Us

    • Interface Gold™ Benefits
    • Interface TechPak
    • Group Training & Private Classes

    Contact Us

    3115 N 3rd Ave
    G130
    Phoenix, AZ 85013

    602-266-8500

    Stay in touch on our social channels!
    Twitter
    Facebook
    LinkedIn
    State of Arizona Contract # ADSPO18-210228

    Copyright © 2023 Interface Technical Training. All Rights Reserved.

    Interface Live Training Terms and Conditions Terms of Use Microsoft Subscription Terms and Conditions Privacy Policy WIOA Policy

    Insert/edit link

    Enter the destination URL

    Or link to existing content

      No search term specified. Showing recent items. Search or use up and down arrow keys to select an item.