When You're Out of the Office
What would you recommend for the holidays next week when the office is closed.
2007-12-21
106 reads
Editorials
2007-12-20
1,896 reads
Obfuscation
Test data is critical to being sure your application works, but is production data ok to use in test environments?
2007-12-19
511 reads
Data Ownership
Who owns the data that we generate ourselves? It's not as easy to answer that as you think.
2007-12-18
49 reads
2007-12-17
142 reads
Better Licensing
Licensing SQL Server used to be easy and could be again, though it is still better than licensing Oracle.
2007-12-17
239 reads
What Would You Do?
If someone acts suspicious at work, do you report them? What if it's the CIO? What if data security is involved?
2007-12-14
95 reads
Another Reason to Hate Ads
Malicious code embedded inside advertisements served on the web. What's next?
2007-12-13
66 reads
The Downside of Real Time
Everyone wants real time reporting, or do they? Steve Jones talks about some of the downsides of implementing such a system.
2007-12-12
116 reads
Do We Need a PK?
A primary key is a must for every table. Or is it? Steve Jones examines the question.
2007-12-11
455 reads
Blogs
T-SQL Tuesday #192 Invitation: SQL Server 2025 Excitement
By Steve Jones
It’s that time of the month again, and once again, I’m late and I’m...
The Book of Redgate: What Our Customers Say
By Steve Jones
This is from 2010, but I loved that people felt this way about Redgate...
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...
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