Tools I Use to Scan for SQL Servers
I was having a Twitter conversation on this yesterday and naturally Aaron Nelson (blog | twitter) popped in with "PowerShell!" I like PowerShell,...
2010-10-13
15,532 reads
Databases – Infrastructure – Security
Slides and Demo from Midlands PASS Presentation - October 12, 2010
Here are the slides and demo script from the presentation on Understanding SQL Server Query Processing.
2010-10-12
541 reads
Free SQL Server Training for the Week of October 11, 2010
Monday
SQL Lunch - SSIS Design Patterns 1c: Variables, Events, and Automated Custom Logging Patterns - Andy Leonard
Tuesday
Idera - Accelerating Answers with Analysis Services...
2010-10-08
623 reads
An Organizer's Recap of SQL Saturday #48 - Columbia, SC
This past Saturday, October 2nd, we hosted Columbia, SC's first ever SQL Saturday. By the feedback we've received, both during...
2010-10-06
811 reads
Free SQL Server Training for the Week of October 4, 2010
Monday
Quest Software - Advanced SQL Server Troubleshooting - Kevin Kline
Tuesday
PASS Performance Virtual Chapter - Using Storage to Increase Database Performance - Denny Cherry
Wednesday
SQL Lunch...
2010-10-01
1,057 reads
Lessons from a Great Mentor
On Sunday I learned of the passing of one of my greatest mentors, Major Herbert L. Day, USMC, Retired. He...
2010-09-28
907 reads
Free SQL Server Training for the Week of September 27, 2010
Tuesday
PASS Application Development Virtual Chapter - Next-Level SQLCLR: Parallel Processing and Bulk Load - Adam Machanic
Pragmatic Works - Performance tuning the cube - Adam...
2010-09-24
771 reads
Why You Should Come to SQL Saturday #48 - Columbia, SC
SQL Saturday #48 is on October 2. We're offering free SQL Server and PowerShell training from some great names in...
2010-09-22
939 reads
Putting Priorities into Practice
Yesterday I posted a review on the book Choosing to Cheat. I had begun putting some of the principles into...
2010-09-21
897 reads
Review: Choosing to Cheat
Cross-posted from The Goal Keeping DBA blog.
I first heard about this book at SQL Saturday #51 when I was talking...
2010-09-20
863 reads
Blogs
Becoming a creator, my website experience
By DataOnWheels
Over the past few months, I have debated starting a new blog to discuss...
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...
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