SQL Saturday, Southern Tour
Things have worked out where I'll be able to hit a SQL Saturday for this month and each of the next...
2010-08-09
596 reads
Databases – Infrastructure – Security
Planning for Maintenance
On Monday, Microsoft released an out-of-band security patch to address the .LNK vulnerability. This affects Windows XP, including Windows XP...
2010-08-06
682 reads
Free SQL Server Training for the Week of August 9, 2010
Monday
SQL Lunch - SSIS Design Patterns 1a: Introduction to SSIS Design Patterns - Andy Leonard
Tuesday
PASS Application Development Virtual Chapter - Where the bl**dy...
2010-08-06
1,213 reads
Simple Script to Determine Who To Kill (SPIDs)
I'm mostly working now supporting the building of SSIS packages for ETL. And on one particular project we've been making heavy...
2010-08-06
749 reads
Midlands PASS Meeting - August 10
Topic: Creating a SQL Server Utility Environment
Can SQL Server be offered as a service (SQLaaS)? Can SQL Server be treated like...
2010-08-05
768 reads
GTD: Emergency Scanning versus Processing
Cross-posted from The Goal Keeping DBA blog.
I'm making an earnest effort to work through Getting Things Done in an effort...
2010-08-05
747 reads
Free SQL Server Training for the Week of August 2, 2010
Tuesday
PASS Performance Virtual Chapter - Parallelism and Performance - Are You Getting Full Return on Your CPU Investment? - Adam Machanic
Thursday
SQL Lunch - Analysis...
2010-07-30
1,575 reads
Free SQL Server Training for the Week of July 26, 2010
Tuesday
Pragmatic Works - SSIS Management for the DBA - 11 AM EDT - Brian Knight
PASS Application Development VC - The Benefits of SQL Azure...
2010-07-23
803 reads
Free SQL Server Training for the Week of July 19, 2010
This will start a new trend on my blog. Every Friday morning I'll have a blog post covering the free SQL...
2010-07-15
743 reads
Pruning the Blog List
I went through the exercise months ago where I tried to re-organize my blog reading to be more efficient at...
2010-07-15
837 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