Data Gathering – SQL Server Setup Problems Cindy Gross, Dedicated Support Engineer Gathering the right data during a problem can get you a long ways towards resolving the problem. When you ask the right questions and clearly define the problem it changes the way you approach the remaining steps. Sometimes the answer to aContinue reading “Data Gathering – SQL Server Setup Problems”
Tag Archives: sql
SQL PowerShell Demo – Intro
SQL PowerShell Demo – Intro Cindy Gross, Dedicated Support Engineer Audience: SQL Server DBAs and/or developers who are familiar with basic SQL Server commands, SQL Server Management Studio (SSMS), and SQL Agent jobs. 0. Prerequisites Read the introductory “PowerShell For SQL Server Basics” 1. Install Basics Check what version of PowerShell you currently have onContinue reading “SQL PowerShell Demo – Intro”
PowerShell for SQL Server – Basics
PowerShell for SQL Server – Basics Cindy Gross, Dedicated Support Engineer Audience: SQL DBAs and/or developers who are familiar with basic SQL Server commands, SQL Server Management Studio (SSMS), and SQL Agent jobs. Basics PowerShell processes objects based on .NET. Cmdlets are named in a Verb-Noun format such as Start-Service and Get-Help. For help onContinue reading “PowerShell for SQL Server – Basics”
PowerShell for SQL – Getting Started
PowerShell for SQL – Getting Started Cindy Gross, Dedicated Support Engineer You may want to use PowerShell to automate SQL activities such as backups. There are various ways to automate backups. For example, you can centralize the backup calls on an admin server which has some type of list of instances and databases and possiblyContinue reading “PowerShell for SQL – Getting Started”
Using Mount Points with SQL Server
Using Mount Points with SQL Server Author: Cindy Gross, Dedicated Support Engineer Tech Reviewer: Min He, SQL Cluster PM Summary: Microsoft does NOT support installing or putting databases on the “root” of a mount point in SQL Server 2005, 2008, 2008 R2 unless you manually manage the ACLs/permissions yourself (modified 1/13/12). The key pointsContinue reading “Using Mount Points with SQL Server”