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,836 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,337 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
728 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,474 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
660 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,621 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,467 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,792 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
653 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,367 reads
Blogs
Claude finds two cryptographic weaknesses (but the sky isn’t falling)
By Brian Kelley
If you haven't seen the announcement, Anthropic was able to utilize Claude (Mythos Preview)...
Generate Embeddings in SQL with Aurora and Bedrock
Most embedding pipelines on AWS have the same shape: a job reads rows out...
Resolving SQL Server Transaction Log Issues Efficiently
By Arun Sirpal
Transaction log issues are one of the quietest ways a healthy database turns into...
Forums
KONTAK BCA KCU SCBD Telp:08218154392
WA CS (08218154392) Equity Tower, Ground Floor, Unit D & Lantai 8, Unit E,...
BCA KCU GADING SERPONG Telp:08218154392
WA CS (08218154392) Summarecon Serpong, Perumahan Gading Serpong, Jl. Gading Serpong Boulevard Cluster Scientia...
Symmetric Key Encryption
Comments posted to this topic are about the item Symmetric Key Encryption
Question of the Day
Symmetric Key Encryption
If I run this statement in SQL Server 2025, how is the password encrypted?
CREATE SYMMETRIC KEY MySymmetricKey WITH ALGORITHM = AES_256, KEY_SOURCE = 'My secret key source passphrase', IDENTITY_VALUE = 'My secret identity value' ENCRYPTION BY PASSWORD = 'S&perS#cretP@ssword7'; GOSee possible answers