-->
SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 

Nebraska SQL from @DBA_ANDY

I’m a forty-something Microsoft SQL Server DBA of 15+ years, a devoted husband, and a father of three young boys. I have been a DBA at a public university, at a major bank, at a healthcare system, and I now work as a remote DBA with customers across the United States. I write and speak primarily about the tips and tricks that I discover along my SQL Server journey.

PASS Summit 2017 - Live and in Living Color!

UPDATE - the feed and schedule are live at http://www.pass.org/summit/2017/PASStv.aspx

http://rochistory.com/blog/wp-content/uploads/2014/09/NBC-logo.png
Not in Seattle for some reason this week?  Like maybe you stayed home because it was Halloween week, or you don't have the funds, or you are preparing for the zombie apocalypse?

http://www.demotivation.us/media/demotivators/demotivation.us_Zombie-Apocalypse-Preparation-level-genius_133338427933.jpg

PASS is ready to help you…

Read more

0 comments, 110 reads

Posted in Nebraska SQL from @DBA_ANDY on 1 November 2017

But I Don't *Want* To "Restore from a backup of the database or repair the database!"

Do you like Log Shipping?

Before my time at Ntirety I had done quite a bit of work with failover clustering and mirroring (trending into some Availability Groups) but I had never really done that much replication or log shipping.  Even at my previous managed services remote DBA job I…

Read more

0 comments, 1,944 reads

Posted in Nebraska SQL from @DBA_ANDY on 23 October 2017

And YOU Get a Deadlock and YOU Get a Deadlock and EVERYBODY GETS A DEADLOCK!

https://memegenerator.net/img/instances/400x/59507872/you-get-a-deadlock-everybody-gets-a-deadlock.jpg
We all get them at one point or another - deadlocks.

I have Object 1 and need Object 2, you have Object 2 and need Object 1:

https://i-technet.sec.s-msft.com/dynimg/IC4289.gif
This isn't the same as simple blocking, where I have Object 1 and you want it (but you can't have it…

Read more

1 comments, 1,999 reads

Posted in Nebraska SQL from @DBA_ANDY on 18 October 2017

Toolbox - Fix Your FILEGROWTH

One of the items we usually flag in reports is FILEGROWTH by percentage.  It doesn't help that for most versions of SQL Server the default FILEGROWTH increment for one or both files (DATA and LOG) is 10%.

https://i.imgflip.com/jaq5c.jpg

As you probably already know, the key flaw to percentage-based FILEGROWTH is…

Read more

0 comments, 1,398 reads

Posted in Nebraska SQL from @DBA_ANDY on 5 October 2017

Come See Me in Minnesota in October!




The schedule for SQL Saturday #682 Minnesota 2017 is out, and I will be giving my talk on Extended Events:

--
Getting Started with Extended Events
Speaker: Andy Galbraith
Duration: 60 minutes
Track: Administration
Few subjects in Microsoft SQL Server inspire the same amount of Fear, Uncertainty, and Doubt (FUD)…

Read more

0 comments, 235 reads

Posted in Nebraska SQL from @DBA_ANDY on 14 September 2017

Toolbox - IO, IO, Why are You So Slow?

This is the next in a series of blogs I am going to create talking about useful tools (mostly scripts) that I use frequently in my day-to-day life as a production DBA.  I work as a Work-From-Home DBA for a Remote DBA company, but 90+% of my job functions are…

Read more

2 comments, 1,939 reads

Posted in Nebraska SQL from @DBA_ANDY on 6 September 2017

The Transient Database Snapshot Has Been Marked Suspect

Yet another tale from the ticket queue...

The DBCC CheckDB was failing on INSTANCE99 and after some investigation it looked like a space issue, not an actual corruption issue.

http://baddogneedsrottenhome.com/images/emails/55ce060daa58b.jpg
--

The Job Failure error text was this:

--

Executed as user: DOMAIN\svc_acct. Microsoft (R) SQL Server Execute Package Utility …

Read more

0 comments, 857 reads

Posted in Nebraska SQL from @DBA_ANDY on 24 August 2017

Sudden Differential Backup Failures after an Availability Group Failover

As so many stories do, this story starts with a failover - in this case an Availability Group (AG) failover.

https://cdn.meme.am/cache/instances/folder984/400x/59300984.jpg

There were several different backup and status check jobs failing on NODE01 and NODE02 because the AG01 availability group was now primary on NODE02 instead of NODE01 after a…

Read more

0 comments, 340 reads

Posted in Nebraska SQL from @DBA_ANDY on 24 July 2017

Toolbox - Which Tables are Using All of My Space?

This is the next in a new series of blogs I am going to create talking about useful tools (mostly scripts) that I use frequently in my day-to-day life as a production DBA.  I work as a Work-From-Home DBA for a Remote DBA company, but 90+% of my job functions…

Read more

0 comments, 219 reads

Posted in Nebraska SQL from @DBA_ANDY on 21 July 2017

T-SQL Tuesday #92 - Trust But Verify


It's T-SQL Tuesday time again, and this month the host is Raul Gonzalez (blog/@SQLDoubleG).  His chosen topic is Lessons Learned the Hard Way. (Everybody should have a story on this one, right?)

When considering this topic the thing that spoke most to me was a…

Read more

0 comments, 1,498 reads

Posted in Nebraska SQL from @DBA_ANDY on 11 July 2017

Toolbox - Where Did All My Space Go?

This is the first in a new series of blogs I am going to create talking about useful tools (mostly scripts) that I use frequently in my day-to-day life as a production DBA.  I work as a Work-From-Home DBA for a Remote DBA company, but 90+% of my job functions…

Read more

1 comments, 1,903 reads

Posted in Nebraska SQL from @DBA_ANDY on 3 July 2017

9003 is a Scary Number


Recently I moved up to the next consecutive error number, a 9003 error:

-- 
Log Name:      Application
Source:        MSSQLSERVER
Date:          6/15/2017 4:49:59 AM
Event ID:  …

Read more

0 comments, 420 reads

Posted in Nebraska SQL from @DBA_ANDY on 21 June 2017

It's Just Another 9002...another error like all the rest...


11:30pm on a Saturday night, and the pager went off…

Error: 5901, Severity: 16, State: 1.
One or more recovery units belonging to database 'i3_dialer' failed to generate a checkpoint. This is typically caused by lack of system resources such as disk or memory, or in some cases due to…

Read more

1 comments, 685 reads

Posted in Nebraska SQL from @DBA_ANDY on 5 May 2017

T-SQL Tuesday #89 – The O/S It is A-Changing



It's T-SQL Tuesday time again - the monthly blog party was started by Adam Machanic (blog/@AdamMachanic) and each month someone different selects a new topic.  This month's cycle is hosted by Koen Verbeeck (blog/@Ko_Ver) and his chosen topic is "The Times They…

Read more

0 comments, 392 reads

Posted in Nebraska SQL from @DBA_ANDY on 11 April 2017

Who Left Those Old Components in My New Database???

Recently a client requested some new transactional replication publications on a relatively new pre-production server.  The client has plenty of transactional and snapshot replication in their environment, including two other publications on this instance already, so this was just adding more to the existing pile.

Piece of cake, right?

https://s-media-cache-ak0.pinimg.com/564x/f2/de/6d/f2de6d3610642b866edcf76f7f86129a.jpg

Read more

1 comments, 1,345 reads

Posted in Nebraska SQL from @DBA_ANDY on 7 April 2017

Querying SQL and Windows Version Info with T-SQL

Just a quick one today - I see questions sometimes about polling Windows information from inside SQL Server itself.  There are a couple of frequently touted options:


--


(1)  SELECT @@VERSION


The most basic option, and it does return most of what we want but not in any kind of…

Read more

4 comments, 3,254 reads

Posted in Nebraska SQL from @DBA_ANDY on 24 March 2017

Embrace The Missing Index DMVs - But Proceed with Caution!

One of the performance tools I use all of the time is the set of Missing Index DMVs: 
·         sys.dm_db_missing_index_details– Detailed specifics on the missing indexes, including column lists 
·         sys.dm_db_missing_index_groups– relates individual missing indexes to index groups
·         sys.dm_db_missing_index_group_stats– information on potential…

Read more

1 comments, 2,393 reads

Posted in Nebraska SQL from @DBA_ANDY on 9 March 2017

How many Backups is Too Many?

Does this title seem strange?  Of course we know this is the true answer:

https://cdn.meme.am/cache/instances/folder633/58097633.jpg

But here is a story of a client that may have too many backups after all.

--

Our monitoring system found that the backups on a client server had suddenly started running very long.  When…

Read more

4 comments, 2,207 reads

Posted in Nebraska SQL from @DBA_ANDY on 24 February 2017

YouTubing Down the SQL Server River

I recently stumbled on a YouTube channel from one of my favorite SQLPeople - she is sharp (and an MCM) and one of the nicest people out there - Kendra Little (blog/@Kendra_Little).  Since divesting herself from Brent Ozar Unlimited over a year ago Kendra has been…

Read more

0 comments, 457 reads

Posted in Nebraska SQL from @DBA_ANDY on 10 February 2017

#SQLSpeaking this Fall!

I have some great speaking dates coming up this Fall - here is the list:

--









First - the big one.  I am honored to be chosen for the first time to speak at the PASS Summit in Seattle.  The only negative is that I am not on until Friday…

Read more

0 comments, 269 reads

Posted in Nebraska SQL from @DBA_ANDY on 15 September 2016

Older posts