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
433 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
433 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
315 reads
My database is in the recovery pending state and I want to get in and extract the data out into...
2017-03-15
353 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
371 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
377 reads
If you ever need to move a copy of a SQL database in Azure across servers then here is a...
2017-03-07
347 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
327 reads
A nice little error log feature that I noticed in SQL Server 2016 regarding tempdb. Tempdb, a system database in...
2017-03-02
402 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
438 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
554 reads
Yes, you’re reading that right, we’re going to download a report that cannot be...
By Chris Yates
When Microsoft announced SQL Server 2025, I was curious about what would truly change...
By Steve Jones
Redgate has a research arm, called the Foundry, that has been experimenting with AIs...
Comments posted to this topic are about the item Poor Name Choice
Comments posted to this topic are about the item Getting the Indexed Columns
Comments posted to this topic are about the item T-SQL in SQL Server 2025:...
I run this code on SQL Server 2022 to get a list of all the indexes and their key columns. What is returned?
SELECT
INDEX_COL (N'AdventureWorks2017.Sales.SalesOrderDetail') See possible answers