My path from a junior to a senior DBA
A non-technical post but something I have been asked about few times so I thought that I would put pen...
2017-03-22
436 reads
A non-technical post but something I have been asked about few times so I thought that I would put pen...
2017-03-22
436 reads
TDE (Transparent Data Encryption) encrypts the data files at rest but don’t forget that it also encrypts your backup file...
2017-03-20
318 reads
My database is in the recovery pending state and I want to get in and extract the data out into...
2017-03-15
357 reads
The title is adapted from a child-hood movie of mine and is my daily (database-related) WTF moment and it is...
2017-03-14
374 reads
This idea basically started from Andy Bek’s TSQL Tuesday last year #84 growing new speakers (https://sqlbek.wordpress.com/2016/10/25/t-sql-tuesday-84-growing-new-speakers/ – thanks Andy) and I have...
2017-03-10
379 reads
If you ever need to move a copy of a SQL database in Azure across servers then here is a...
2017-03-07
350 reads
I decided to accept Grant’s (TheScaryDBA) challenge found here- http://www.scarydba.com/2017/03/02/random-blog-post-challenge/ where we have to write a technical blog post that incorporates a certain...
2017-03-03
329 reads
A nice little error log feature that I noticed in SQL Server 2016 regarding tempdb. Tempdb, a system database in...
2017-03-02
405 reads
For this blog post I want to discuss the meaning behind SQL Server: Memory Manager\Target Server Memory (KB) and SQL...
2017-03-01
441 reads
SQL Server Management Studio (SSMS) release candidate 17.0 RC2 works side-by-side with generally available releases (16.x), but it is not...
2017-02-22
557 reads
By Steve Jones
on tenderhooks – adj. feeling the primal satisfaction of being needed by someone, which...
By DataOnWheels
I have been active in the data community throughout my career. I have met...
By Vinay Thakur
Quick Summary for Microsoft SQL Server till 2025, I am fortunate to be part...
hi, in an ssis for each loop over an object variable called MyListVariable, i...
SQL Server is typically viewed as a transactional or analytical database engine. However, it...
Hello, Is there a way in Azure SQL Database to change the 'Blocking Process...
On SQL Server 2025, when I run this, what is returned?
SELECT EDIT_DISTANCE_SIMILARITY('SQL Server', 'MySQL') See possible answers