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...
2014-07-31
10,820 reads
Nebraska SQL from @DBA_ANDY
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
Original Message:
http://twitter.com/DBA_ANDY/status/488744595136999424
--
What does...
2014-07-14
10,323 reads
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...
2014-06-26
725 reads
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...
2014-06-03 (first published: 2014-05-29)
7,442 reads
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...
2014-05-23
657 reads
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...
2014-05-21
2,615 reads
T-SQL Tuesday #54 - Interviews and Hiring
This month’s T-SQL Tuesday is hosted by Boris Hristov (blog/@BorisHristov) and his chosen topic is “Interviews and Hiring” – specifically interviewing...
2014-05-16 (first published: 2014-05-13)
2,463 reads
Help - I Need a List of my Maintenance Plan Jobs *and* Schedules!
UPDATE - Jason Brimhall (blog/@sqlrnnr) pointed out after reading this post that there is a more inline way to do a...
2014-05-07
7,773 reads
Speaking at #SQLSat307 in Iowa City!
I just received confirmation I will be speaking at SQL Saturday 307 in Iowa City on June 7th!
I will be...
2014-05-02
650 reads
Why Can't I Reinitialize My Subscriber?
I recently had a colleague request help with a replication problem he was having with a client. The client was...
2014-04-28
3,364 reads
Blogs
SQL Server Journey till 2025 (brief)
By Vinay Thakur
Quick Summary for Microsoft SQL Server till 2025, I am fortunate to be part...
Identity Columns Can’t Be Updated: #SQLNewBlogger
By Steve Jones
I’m not sure I knew identity column values could not be updated. I ran...
Rolling Back a Broken Release
By Steve Jones
We had an interesting discussion about deployments in databases and how you go forward...
Forums
Can someone please explain what happens?
I have mentioned this several times over several years. Can someone please help me...
SELECT COUNT(DISTINCT) returns null when nothing is found instead of 0
SELECT COUNT(DISTINCT Component) AS Found FROM tblComponents WHERE(Component NOT LIKE '%[a-z]%') AND(LTRIM(RTRIM(Component)) = 'GM13622')...
Remotely Engineer Fabric Lakehouse objects: The Fabric Modern Data Platform
Comments posted to this topic are about the item Remotely Engineer Fabric Lakehouse objects:...
Question of the Day
Creating JSON III
In a SQL Server 2025 table, called Beer, I have this data:
BeerIDBeerName 1Becks 2Fat Tire 3Mac n Jacks 4Alaskan Amber 8KirinI run this code:
SELECT JSON_OBJECTAGG(
BeerID: BeerName )
FROM beer;
What are the results? See possible answers