Database Backups: Things You Need To Do Now
I want to say a few things about database backups that you need to know.
Wait a minute, haven’t you written...
2012-01-16 (first published: 2012-01-11)
5,160 reads
The Scary DBA
PASS Summit 2012 Evaluation Results
I say it all the time because it’s worth repeating, feedback is a gift. Good, bad or indifferent (well, not...
2011-12-19
1,724 reads
SQL Saturday #104: Colorado Springs
I’ll be presenting at the Colorado Springs SQL Saturday on January 7th of 2012. The session is called Seven Ways...
2011-12-14
1,929 reads
Changes to SQL Server 2012 Execution Plans
I’ve been working with execution plans quite a lot in SQL Server 2012. There are a number of changes, most...
2011-12-12
10,162 reads
#sqlfamily
Microsoft is supporting an effort by PragmaticWorks targeted at supporting technical training for returning veterans. I can’t think of a...
2011-12-09
1,696 reads
SQL Connections Fall 2011 Speaker Evaluations
In keeping with the past, I’m going to go ahead and post my evals for the two sessions I did...
2011-12-06
1,578 reads
Resolutions: Outcome
Earlier this year, I wrote a post about my upcoming plans for the year in response to a question asked...
2011-12-05
1,597 reads
PASS Board Elections
Here is the list of suckers, uh, I mean, candidates, that actually want to subject themselves to the board. Look...
2011-11-30
2,317 reads
Installing SQL Server 2012 RC0
Very short informational post.
If you’re like me and you’ve been running the public Client Technology Preview (CTP3) of SQL Server...
2011-11-21
2,012 reads
Thank you
I somehow made the Top 10 Community Choice Bloggers in the SQL Server Magazine 2011 awards (keep scrolling to the...
2011-11-18
1,475 reads
Blogs
Query Intelligence in SQL Server 2025: What Developers Need to Know
By Chris Yates
When Microsoft announced SQL Server 2025, I was curious about what would truly change...
Finding and Killing Blockers with Redgate AI Tech
By Steve Jones
Redgate has a research arm, called the Foundry, that has been experimenting with AIs...
Back at Small Data SF in 2025
By Steve Jones
Today I’m in San Francisco at Small Data SF 2025. I went to the...
Forums
Poor Name Choice
Comments posted to this topic are about the item Poor Name Choice
Getting the Indexed Columns
Comments posted to this topic are about the item Getting the Indexed Columns
T-SQL in SQL Server 2025: Substring Changes
Comments posted to this topic are about the item T-SQL in SQL Server 2025:...
Question of the Day
Getting the Indexed Columns
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