Data Gathering – SQL Server Setup Problems

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”

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”

%d bloggers like this: