Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 

Oklahoma City User Group Presentation Files

Earlier this week, I got the opportunity to present online for the Oklahoma City SQL Server User Group on SQL Server Mythconceptions and Mythteries. The files from my presentation are attached below for download. The zip file contains my slide deck and demo code from the session. SQLServerMythconceptionsAndMythteries.zip (653 KB)

Read more

Error Creating Remote Distributor When Creating a Local Distributor

Recently, I was working on a Peer-to-peer replication automation project. When I switched from my local test servers to some lab servers to test my scripts, I ran into some issues. The thing that confused me at first was that it was complaining about a missing remote login for the…

Read more

T-SQL Tuesday #65 – Overcoming Variable Limitations in SQLCmd Mode

It’s time again for that T-SQL blog party T-SQL Tuesday, and this month’s host is Mike Donnelly (blog|@SQLMD). If you want to join in the blog party, take a look at Mike’s announcement for an explanation of the topic and rules for participating: T-SQL Tuesday #065 – Teach Something New.…

Read more

Patching Master Data Services

I recently installed my first deployment of Master Data Services (MDS). I installed the SQL Server 2014 (Enterprise Edition) MDS front-end on a new server with the intent to use an existing SQL Server 2014 (Enterprise Edition) database engine for the back-end. Unsurprisingly, I ran into some issues, and as…

Read more

Performance Counters: Why It Depends

When you’re working through some vague performance issues (e.g., “SQL Server seems slow today”), one of the common things to do is to collect some performance counters. If you are collecting performance counters for the first time on the server, you don’t have anything to compare them against. This usually…

Read more

Speaking at SQL PASS Summit 2014

I am honored to be selected to deliver 2 sessions at the SQL PASS Summit 2014. I will be delivering a half day session on administering BI systems and a regular session on techniques for indexing. If you were selected to speak this year, congratulations. I look forward to attending…

Read more

Size Matters: 2 Products to Accelerate SQL Traffic

I talked previously about network pipelines and how to get the most out of a fat network in the post Network Packet Size: to Fiddle With or Not to Fiddle With. If you need to move large amounts of data and have a network infrastructure that can support a larger…

Read more

Why is Your SQL Server Slow? All-for-one and One-for-all

I have one more thing I want to talk about regarding the conversation I had recently with my friends and former colleagues at Idera about the things that slow down SQL Server. Another “quick performance wins” you can take advantage of is segregating the types of files SQL Server uses.…

Read more

Why is Your SQL Server Slow? Here’s a Hint

I was talking recently with my friends and former colleagues at Idera about the things that slow down SQL Server. Specifically, the discussion was about things that people could change without a lot of trouble to make their SQL Server run faster. I like to use the phrase “quick performance…

Read more

Performance Tuning Pre-con and More at SQLSaturday 277 RVA

Join me for 2 days of fun and education at SQL Saturday #277 in Richmond, VA on March 21 and 22, 2014. I will be delivering an all-day pre-con session, Performance Tuning and Troubleshooting Like a Pro, on Friday, March 21. The session is only $99 if you sign up…

Read more

Schema-only Backups and Restores

I was reading the blog post Time for a Quick Rant by Grant Fritchey (blog|@GFritchey) about people who choose to not back up a database simply because it is large. I agree wholeheartedly with Grant on this topic. Simply choosing not to back up a database is, well to put…

Read more

DBA: Guardian of the Data

I was asked recently by Idera to take a look at the things that could cost a DBA their job. This has lead to a new whitepaper I wrote about the 5 mistakes that DBAs make that can cost them their jobs. Watch Idera’s Resource Central or follow @Idera_Software on…

Read more

T-SQL Tuesday #50: Doing More With Less

It’s time once again for that monthly geek party again we like to call T-SQL Tuesday. T-SQL Tuesday #50 is hosted this month by Hemanth.D (Blog|@SQLChow). You are invited to visit his blog to join the blog party. You are also welcome to write your own participating blog post for…

Read more

Who Owns SQL Backups?

I was asked by Idera to take a look at the things that could cost a DBA their job. This has lead to a new whitepaper I wrote about the 5 mistakes that DBAs make that can cost them their jobs. Watch Idera’s Resource Central or follow @Idera_Software on Twitter…

Read more

When DMVs Cost Me My Job

Back in early 2006, I was still working at my first ever DBA job. I had only been a DBA for a little less than 3 years, but I felt like I knew a lot. I spent every night on the forums helping people with issues as a way of…

Read more

T-SQL Tuesday #49: Wait For It Roundup

A huge round of applause and my thanks to all of the participants and spectators for this month’s edition of T-SQL Tuesday. I hope I didn’t keep you waiting too long for the roundup. <rimshot> Let’s take a look at this month’s participating blog posts: Fellow Certified Master (MCM) Rob…

Read more

Enabling High Performance Power Plan via PowerShell

One of the projects I’ve been working on recently was to automate our production SQL Server installs including our standard configuration changes. Much of this process was already done by my predecessor Nic Cain (blog|@SirSQL) who had written an interactive PowerShell process for doing the SQL Server installs and making…

Read more

T-SQL Tuesday #49: My Go-To Query For Waiting Tasks

I’m not just hosting T-SQL Tuesday, I’m a customer as well. Err, I mean participant. Topic for this month’s T-SQL Tuesday, hosted by yours truly, is … wait for it … Waits and Queues. For my donation to this little blog party, I’m contributing my favorite go-to query for waiting…

Read more

Never an Infinite Loop Around When You Need One

You may be thinking, “You’re a DBA. I thought DBAs hated infinite loops.” Well, you’re right, most of the time. As with most things, there are times when infinite loops can be useful, as long as there is some attainable condition that breaks us out of it. I found myself…

Read more

T-SQL Tuesday #49: Topic is … Wait for It …

Have you been waiting to hear about this month’s T-SQL Tuesday topic? Here’s the announcement, right here and right now. The topic for this month’s T-SQL Tuesday is … wait for it … What? Still waiting? Well, suspend your confusion because that’s it. The topic is (queue the fanfare) Waits.…

Read more

Older posts