Women in technology
Earlier this week a friend of mine (Lynn Swayze (Hall) (b/t)) posted this great article on women in technology. It’s...
2015-11-25
628 reads
SQLStudies
Using multiple log files
The transaction log is made up of one or more files that are used sequentially. So in other words if...
2015-11-27 (first published: 2015-11-23)
1,539 reads
Naught to Speaker pt 3
Becoming a speaker is one heck of a journey. Early this year I submitted a session to speak at Pass...
2015-11-18
608 reads
SSMS Setup
Every time I install a new version of SSMS I make a handful of changes to the default setup. For...
2015-11-16
1,090 reads
Hiding one or more columns
This isn’t something you have to do frequently, but sometimes you don’t want the users to have access to certain...
2015-11-12
663 reads
Why are you still using datetime?
It’s almost Thanksgiving time again! Let’s see, what am I thankful for? T-SQL Tuesday! Someone else get’s to pick a...
2015-11-12 (first published: 2015-11-10)
4,844 reads
Questions from “SQL Server Security for Everyone”
I recently gave my SQL Server Security for Everyone session at Summit 2015. (I’m still in awe about that by...
2015-11-04
515 reads
Administrative Logins and Users
If you’ve ever worked through an audit you have probably gotten a request that looks a lot like this:
Please give...
2015-11-02
499 reads
Who’s on call
Of all the posts I’ve written I think this one is my favorite, even though it’s not a technical post....
2015-10-28
500 reads
Finding and keeping your #SQLPassion
I consider myself lucky. I fell into a job that I truly enjoy, something that I do for fun even...
2015-10-26
483 reads
Blogs
Export a Power BI Report that cannot be Downloaded
Yes, you’re reading that right, we’re going to download a report that cannot be...
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...
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