SQL Server 2012 RC0 available

Release Candidate 0 (RC0) of SQL Server 2012 is available for download! That means you can start to experience a feature complete version of the next great SQL release. We’re still looking at the first half of calendar year 2012 for the RTM release of SQL Server 2012. FURTHER.  FORWARD.  FASTER. Downloads: Microsoft® SQL Server®…

1

Leadership – Strengths and Weaknesses

Leadership – Strengths and Weaknesses As part of my attempt to grow as a leader I took the StrengthsFinder survey. I got this one from the Go Lead Idaho sessions I am attending. It’s based on a Gallup survey and is all based on self-assessment. It was a quick and painless survey with clear, concise…

3

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 way…

2

Leadership – Taking Feedback

Leadership – Taking Feedback As you may have seen from my other blogs, I’m taking leadership courses and trying to stretch and define myself. It is hard work but I think it is going to be well worth the trouble. I’m getting great input from many sources and writing about it helps me think it…

1

Leadership – What Does It Mean?

Leadership – What Does It Mean? What is a leader? Are you a leader? Do you have to be a people manager to be a leader? Do you care about leadership? These are all questions I’ve faced recently. I’m attending some leadership training and I’m doing a lot of introspection. When I got to the…

2

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 files…

7

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 Fast…

0

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 a…

0

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 on…

0

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 on…

2