SQL PASS: All the Magic Knobs – Tools

SQL PASS: All the Magic Knobs – Tools In my All the Magic Knobs talk at #SQLPASS 2011 I discussed some easy ways to determine if you’re using some of the performance magic for SQL Server. When you have many consolidated, non-tier 1 databases you don’t have a lot of control over, the best wayContinue reading “SQL PASS: All the Magic Knobs – Tools”

SQLPASS: Are You Smarter Than an MCM? VLF Demos

Are You Smarter Than an MCM?  I had a great time on Wednesday co-presenting with some great SQL peeps! We dressed up, had a lot of fun, and shared a few technical tips along the way. My demo was on VLFs, an often forgotten and/or misunderstood part of the transaction log technology. The demo filesContinue reading “SQLPASS: Are You Smarter Than an MCM? VLF Demos”

SQL PASS: All the Magic Knobs

SQL PASS 2011 DBA-319-C #SQLPASS All the Magic Knobs – Low Effort, High Return Tuning Key points covered: Power Savings = High Performance Smart Virtualization Enough Hardware Control other apps, filter drivers Optimize for ad hoc workloads = ON Compression = ON Set LPIM + Max Server Memory Pre-size files, avoid shrink and autogrow FastContinue reading “SQL PASS: All the Magic Knobs”

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”

Invite a guest in, or not?

The guest user in SQL Server is a bit of a funny object. While we’re taught to be polite to guests, sometimes we don’t want to invite them into our databases. If you have a login to an instance of SQL Server that doesn’t automatically give you access to any databases…. or does it? ByContinue reading “Invite a guest in, or not?”

Taming the Tempdb Tempest – WI SQL Server Virtual User Group, 22 Apr 2011

Thanks to the Wisconsin Virtual SQL Server User Group for letting me talk about tempdb today! The slides and demo queries are attached. Once the recording is available I will update this blog with a link to it. Taming the Tempdb Tempest Summary: ·         Multiple data files of the same size, one log file ·        Continue reading “Taming the Tempdb Tempest – WI SQL Server Virtual User Group, 22 Apr 2011”