New TPC-E Benchmark for HP DL385 G7
Somewhat unnoticed during the holiday season, HP has submitted a new TPC-E benchmark for the DL385 G7 two socket database...
2012-01-04
1,650 reads
Blog Posts
PASS Summit Evals – Plan Cache Querying
This past year, I spoke at the PASS Summit for the second time. The first time was a couple years...
2012-01-04
781 reads
Presenting at OPASS on January 10, 2012
I’m stepping out of blogging-break mode for a few minutes to share that I’ll be presenting Building Your Professional Development...
2012-01-04
707 reads
SharePoint 2010 Your Backup Is From A Different Version Of Microsoft SharePoint Foundation
Restoring a SharePoint site collection can be a pretty easy task. If your interested in how to do that check...
2012-01-04
1,591 reads
Speaking at Charleston PASS on January 19th
I will be presenting on SQL Server security on January 19th in Charleston, SC. You can find the details at...
2012-01-04
861 reads
Speaking at Knoxville SQL Server User Group
I am excited to announce that I will be giving a virtual presentation to the Knoxville SQL Server User Group. ...
2012-01-04
1,004 reads
SQL Server Error Logs
I read a blog post this morning on SQLServerCentral by Tim Radney about SQL Server Error Logs. Tim talks about...
2012-01-04
1,089 reads
SQL SERVER REBUILD INDEX
Use the script below to rebuild an index on a table
ALTER INDEX MY_INDEX_NAME on MY_TABLE_NAME REBUILD ;
Check SQL Server...
2012-01-04
1,052 reads
SSIS Community Tasks and Components
Do you know there are hundreds of additional tasks, tools, and components for SSIS, many which are free? Why re-invent...
2012-01-04 (first published: 2011-12-30)
3,097 reads
SSIS ETL Frameworks
In my years as a BI Professional I have seen many ETL Frameworks. They range from homegrown internal solution to...
2012-01-04
9,730 reads
Blogs
Experimenting with CHOOSE: #SQLNewBlogger
By Steve Jones
I was looking over the CHOOSE() function while editing an article at SQL Server...
Fighting Procrastination?
By Brian Kelley
Here is another short video (~ 15 minutes). This is by the author of...
A Fun Prize at the PASS Data Community Summit
By Steve Jones
I had a briefing for the 2026 PASS Data Community Summit, which is just...
Forums
SQL Server 2025 Server-level Roles
Comments posted to this topic are about the item SQL Server 2025 Server-level Roles
Stairway to DAX and Power BI - Level 29: The DAX Combine & Aggregate Functions
Comments posted to this topic are about the item Stairway to DAX and Power...
AI Is Improving Security
Comments posted to this topic are about the item AI Is Improving Security
Question of the Day
SQL Server 2025 Server-level Roles
In SQL Server 2022+, what does the ##MS_DatabaseConnector## role allow?
See possible answers