Microsoft® SQL Server® 2012 Bible

787 Chapter 30: Confi guring and Managing SQL Server with PowerShell 30 FIGURE 30-2 Database objects. Server Settings DefaultFil ...

788 Part V: Enterprise Data Management SQL Server requires that a database have a PRIMARY fi legroup and that the system tables ...

789 Chapter 30: Confi guring and Managing SQL Server with PowerShell 30 LISTING 30-3 CreateDB.ps1 #createdb.ps1 #Creates a new d ...

790 Part V: Enterprise Data Management $dbdsysfile.GrowthType = 'None' $dbdsysfile.IsPrimaryFile = 'True' # Create the file for ...

791 Chapter 30: Confi guring and Managing SQL Server with PowerShell 30 ■ (^) DataReader object: Designed to return query result ...

792 Part V: Enterprise Data Management LISTING 30-4 EmployeeExtract.ps1 #employeeextract.ps1 #This script pulls info from the Pe ...

793 Chapter 30: Confi guring and Managing SQL Server with PowerShell 30 Scripting SQL Server Tasks Although using PowerShell int ...

794 Part V: Enterprise Data Management FIGURE 30-3 SMO scripting objects. Scripter Server Options ScriptDrops WithDependencies F ...

795 Chapter 30: Confi guring and Managing SQL Server with PowerShell 30 By default, the scripting process sends the results to t ...

796 Part V: Enterprise Data Management $ScriptDrop.Options.WithDependencies = $False $ScriptDrop.Options.Default = $False $Scrip ...

797 Chapter 30: Confi guring and Managing SQL Server with PowerShell 30 $ScriptDrop.Script($ScriptThis) $scriptr.Script($ScriptT ...

798 Part V: Enterprise Data Management LISTING 30-8 dept_birthdays.ps1 #dept_birthdays.ps1 #This script will extract information ...

799 Chapter 30: Confi guring and Managing SQL Server with PowerShell 30 $did = $DepartmentID } $r = """" + $DepartmentID + """," ...

c30.indd 800c30.indd 800 7/31/2012 9:46:24 AM7/31/2012 9:46:24 AM http://www.it-ebooks.info ...

801 CHAPTER 31 Managing Data in Windows Azure SQL Database IN THIS CHAPTER Focusing on the Overview of Azure SQL Database Managi ...

802 Part V: Enterprise Data Management Managing Windows Azure SQL Database One of the great benefi ts of SQL Database, on top of ...

803 Chapter 31: Managing Data in Windows Azure SQL Database 31 same thing applies for creating a database and other objects. The ...

804 Part V: Enterprise Data Management FIGURE 31-2 SQL Database Manager. Another benefi t of this tool is that you can also auth ...

805 Chapter 31: Managing Data in Windows Azure SQL Database 31 Once connected to SQL Database, open a new query window and type ...

806 Part V: Enterprise Data Management High Availability and Scalability The goal of SQL Database is to provide a highly availab ...