Baselines
It can be hard to analyze performance without a baseline. This week, Steve Jones asks how you might use your baseline to better determine what problems you are having with your SQL Server.
2013-02-01
712 reads
Editorial
A New Type of Colocation Facility
Microsoft is working on their generation 4 data centers, which might be a great idea for companies if they can implement a private cloud.
2013-01-31
164 reads
The Knowledge Graph
Google has a new project to use a "database of everything" to help you learn more.
2013-01-30
193 reads
Acing an Audit
Audits for technology groups can be time consuming and stress employees out. An article Steve Jones finds says an insurance company only needed 30 minutes to ace their audit.
2013-01-29
183 reads
Still 32
There is likely still a lot of 32-bit software out there, even as the x86 platform appears to be dying away. Steve Jones notes that you'll likely be dealing with 32/64 bit issues in your career.
2013-01-28
109 reads
Not Pulling the Plug Out
Phil Factor on his renewed appreciation for the "customer-focused" culture of the Data Platform Group at Microsoft
2013-01-28
72 reads
Geeky Oscars
This Friday Steve Jones takes a break from serious technical discussions. With the Oscar nominees announced there were lots of films left out of the awards. Are there some of these you'd recommend?
2013-01-25
85 reads
Serverless Software
Today Steve Jones talks about the future of software development and how it might not require developers to know anything about servers.
2013-01-24
151 reads
Building Better Software
Why is it so hard to build better software? Steve Jones looks at recent problem in iOS that seems silly.
2013-01-23
199 reads
Encryption Not Restriction
Encryption keys for services in the cloud should be maintained by the customer, according to Steve Jones. It's actually a good idea for all of your data.
2013-01-22
126 reads
Blogs
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...
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...
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