An Inconvenient Stay
I'm in Indianapolis for the Indy Tech Fest, having been talked into speaking by John M. He started emailing me...
2008-10-03
409 reads
Blog Posts
Blog Changes on SQLServerCentral.com & Visiting The IndyTechFest
Perhaps you've noticed a few of the blog changes if you visit via the web rather than RSS. One good...
2008-10-03
361 reads
Speed or Value - Why Did I Write This?
Why did I write this? I got challenged by Andy Warren
to write a bit about why I wrote something. I...
2008-10-03
354 reads
Thanks to Andy Leonard
Midlands PASS was privileged to host SQL Server MVP Andy Leonard (Blog #1, Blog #2, his VSTS site, Twitter) tonight...
2008-10-03
720 reads
Through the Looking Glass: Elegant -or Not?
SQL Server as an EAV Database -Good Idea?
It seems like I am getting more and more inquires from potential clients...
2008-10-03
369 reads
A Lost Day - Blog Upgrades
We upgraded our blog server yesterday, making some changes and better integrating the blogs into the site. We now have...
2008-10-02
494 reads
Jumping the Gun - Why Did I Write This?
Why did I write this? I got challenged by Andy Warren
to write a bit about why I wrote something. I...
2008-10-02
332 reads
Never say 'never' to the WHILE loop.
/* download the test text file Moby-Dyck.zip here */
/* You might notice that I refer to Moby **** in this blog. This is because the busybodyish...
2008-10-02
2,215 reads
A Focus on Novice DBAs: My Upcoming PASS Presentations
The PASS Community Summit 2008 is coming up fast (November 18-21, 2008), and if you are attending and you are...
2008-10-01
599 reads
Managing My Todo List
I think everyone struggles with keeping track of things they need to do, and it's all too easy to get...
2008-10-01
477 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
fast farward curson vs while loop on @table
hi, need to known weather fast farwand cursor is faster than a while loop...
Economics of AI: What is the Real Cost to Profit?
Comments posted to this topic are about the item Economics of AI: What is...
Poor Name Choice
Comments posted to this topic are about the item Poor Name Choice
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