Click here to monitor SSC
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.

T-SQL Tuesday #74 - Who Grew The Database?



This month T-SQL Tuesday is hosted by Robert Davis (blog/@SQLSoldier) and his topic of choice is “Be The Change

(If you don’t know about T-SQL Tuesday check out the information here – each month there is a new topic and it is a great…

Read more

2 comments, 232 reads

Posted in Nebraska SQL from @DBA_ANDY on 12 January 2016

Why is my SQL Server using all of the RAM on the server?

The TL;DR on this is simple:

"BECAUSE IT'S SUPPOSED TO!"

A frequent complaint we receive comes from a client that has an in-house sysadmin monitoring tool like Microsoft SCOM/SCCM.  They turn the tool on and it starts red-alerting because the Windows server hosting SQL Server is at…

Read more

0 comments, 4,591 reads

Posted in Nebraska SQL from @DBA_ANDY on 8 January 2016

The transaction log for database 'ABC' is full due to 'ACTIVE_BACKUP_OR_RESTORE'

I have recently had a client with a problem each morning where they were having processes fail with this message in their SQL Server Error Log:
Date 12/01/2015 5:58:48 AM
Log SQL Server (Current - 12/01/2015 1:00:00 PM)
Source spid118
Message Error: 9002, Severity: 17, State: 3.
--
Date 12/01/2015…

Read more

0 comments, 2,212 reads

Posted in Nebraska SQL from @DBA_ANDY on 22 December 2015

What Permissions Does This Login Have?

I recently was tasked with this ticket:
Please add new login Domain\Bob to server MyServer.  Grant the login the same permissions as Domain\Mary.
On the face of it, this seems relatively straightforward, right?  It is the kind of request that we all get from time to time, whether as an…

Read more

4 comments, 1,425 reads

Posted in Nebraska SQL from @DBA_ANDY on 17 December 2015

T-SQL Tuesday #73 - Not Running CHECKDB is Naughty!


This month T-SQL Tuesday is hosted by Bradley Balls (blog/@SQLBalls) and his topic of choice is “Naughty or Nice.”

(If you don’t know about T-SQL Tuesday check out the information here – each month there is a new topic and it is a great…

Read more

0 comments, 2,293 reads

Posted in Nebraska SQL from @DBA_ANDY on 8 December 2015

What Do You Mean There is No Current Database Backup?!?

Yet another late night/early morning tale...

The LOG backups for multiple databases on a server failed overnight (not all databases, but many of them), and looking in the output file from the LiteSpeed Maintenance plan (the client's tool of choice) I found entries like this:

Database Database01: Transaction Log Backup...

Read more

0 comments, 365 reads

Posted in Nebraska SQL from @DBA_ANDY on 3 December 2015

We Are All Responsible


Today we all received an email from PASS's president Tom LaRock (blog/@SQLRockstar):


PASS Anti-Harassment Policy Reminder
It is unfortunate that I have to write this letter, but it has become necessary.
An Anti-Harassment Policy (AHP) was implemented in 2012 to help provide a harassment-free conference experience.…

Read more

0 comments, 283 reads

Posted in Nebraska SQL from @DBA_ANDY on 24 November 2015

CHECKDB - The database could not be exclusively locked to perform the operation

…so the job failed….again…you know the one – that darn Integrity Check job: 
Executing query "DECLARE @Guid UNIQUEIDENTIFIER EXECUTE msdb..sp_ma...".: 100% complete  End Progress  Error: 2015-11-15 03:27:52.43     Code: 0xC002F210     Source: User Databases Integrity Check Execute SQL Task     Description: Executing the query "DBCC CHECKDB(N'master')  WITH NO_INFOMSGS  " failed with the…

Read more

3 comments, 1,891 reads

Posted in Nebraska SQL from @DBA_ANDY on 16 November 2015

SQL Server Training

Brent Ozar’s group (http://www.brentozar.com/) just announced a pretty crazy set of “Black Friday” deals:


Insane sales if you can be one of the first few at midnight, but discounts all day on various training.

--

The other top training in the field (to me) is from Kimberly…

Read more

2 comments, 313 reads

Posted in Nebraska SQL from @DBA_ANDY on 12 November 2015

T-SQL Tuesday #72 - Implicit Conversion Problems


This month T-SQL Tuesday is hosted by Mickey Steuwe (blog/@SQLMickey) and her topic of choice is “Data Modeling Gone Wrong.”

(If you don’t know about T-SQL Tuesday check out the information here– each month there is a new topic and it is a…

Read more

2 comments, 1,444 reads

Posted in Nebraska SQL from @DBA_ANDY on 10 November 2015

PASS Summit 2015 Recap

Last week was the annual PASS Summit in Seattle.  The Summit is the predominant educational and networking event for SQL Server professionals of all types – DBA’s, Developers, Analysts, and many more.

I wasn’t sure I was going to be able to attend this year but after some gyrations with…

Read more

0 comments, 281 reads

Posted in Nebraska SQL from @DBA_ANDY on 3 November 2015

Deleting Files Older than X Hours with PowerShell

(aka "OMG I can't believe I am actually finally writing a #PowerShell blog post").

--

I currently have a situation at a client where we are running a server-side trace that is generating 6GB-7GB of trc files per day while we are watching to see what might be causing a…

Read more

0 comments, 6,932 reads

Posted in Nebraska SQL from @DBA_ANDY on 15 April 2015

Availability Groups - Where Did My Disks Go?



The TL;DR - beware of Failover Cluster Manager trying to steal your non-shared storage!

--
At a client recently two availability groups on a single Windows cluster went down simultaneously.  Apparently the server that was the primary for the AGs (Server1) had mysteriously lost its DATA and LOG drives.  By…

Read more

2 comments, 3,570 reads

Posted in Nebraska SQL from @DBA_ANDY on 2 April 2015

POSTPONED to 02/11 - Speaking at the Omaha SQL Server User Group *Tomorrow* Night!

UPDATE - due to weather conditions today (snow this AM and sub-zero cold tonight) we are postponed to next Wednesday 02/11 still at Farm Credit - I will be giving this same talk and we hope to see you there!

Please RSVP at this new link: http://omahamtg.com/Events.aspx?ID=268

Thanks!

--

I…

Read more

0 comments, 495 reads

Posted in Nebraska SQL from @DBA_ANDY on 3 February 2015

Log Shipping - Exclusive access could not be obtained because the database is in use

This story began as they almost always do - with a page at 4am local time...

--

'Alert: SQL Failed Jobs on InstanceName is Failed'

Job name: LSRestore_InstanceName_DatabaseName
Date & Message: 2014-07-31 05:24:00.0 The job failed. The Job was invoked by User DOMAIN\LOGIN. The last step to run was step…

Read more

2 comments, 3,635 reads

Posted in Nebraska SQL from @DBA_ANDY on 31 July 2014

End of Mainstream Support for Microsoft SQL Server 2008 and 2008 R2



@DBA_ANDY: A reminder to all #sqlserver peeps out there and *especially* to our clients: #sql2008 #sql20008R2 http://blogs.msdn.com/b/sqlreleaseservices/archive/2014/07/09/end-of-mainstream-support-for-sql-server-2008-and-sql-server-2008-r2.aspx#Ntirety


--

What does this mean?

The key takeaway comes from this section of the MSDN blog:

For both SQL Server 2008 and SQL Server 2008 R2, Microsoft will continue…

Read more

0 comments, 3,987 reads

Posted in Nebraska SQL from @DBA_ANDY on 14 July 2014

Why Is your datetime saved as a bigint anyway?

Yet another issue I had never seen before - thankfully this time I was able to find a relatively quick answer.

On a client system their primary database had grown to throw disk alarms on the DATA drive, so I was alerted.  I signed onto the system and found that…

Read more

0 comments, 473 reads

Posted in Nebraska SQL from @DBA_ANDY on 26 June 2014

Handling Perfmon Logs with Relog


In a recent situation, I was tasked by a client to check one of their servers which they believed to be grossly over-provisioned.  As a VM they knew they could easily pull both CPU and RAM from the server if they could determine the true needs of the server.

One…

Read more

2 comments, 2,561 reads

Posted in Nebraska SQL from @DBA_ANDY on 29 May 2014

Come to #SQLSAT307 in Iowa City!

June 6th & 7th in Iowa City - Friday precons & Saturday all day sessions!  I will be presenting on Maintaining your SQL Servers and my good friend David Klee will be presenting a Friday Virtualization precon (Only $99 if you register now!) and two Saturday sessions about Virtualization and… Read more

0 comments, 455 reads

Posted in Nebraska SQL from @DBA_ANDY on 23 May 2014

Why Won't My Clustered Instance Start?

Last weekend I had a client page me in the middle of the night (because, of course, these things always happen in the middle of the night) with the complaint that their SQL Server Failover Cluster Instance (FCI) wouldn't come online on their B node after multiple attempts.  When they…

Read more

0 comments, 1,344 reads

Posted in Nebraska SQL from @DBA_ANDY on 21 May 2014

Newer posts

Older posts