PASS Update #60
I’ve written a lot here, but for June & July (and part of August) I’m trying to just keep the ship...
2011-07-18
650 reads
Blog Posts
Presenting Upserts to PASS AppDev VC
Hopefully this crowd knows a little about what they're getting into! John Jakubowski (blog|twitter) has graciously asked me to present on upsert strategies with SSIS. What are "upserts"? A...
2011-07-18
6 reads
Presenting Upserts to PASS AppDev VC
Hopefully this crowd knows a little about what they're getting into! John Jakubowski (blog|twitter) has graciously asked me to present...
2011-07-18
1,142 reads
Presenting Upserts to PASS AppDev VC
Hopefully this crowd knows a little about what they're getting into! John Jakubowski (blog|twitter) has graciously asked me to present on upsert strategies with SSIS. What are "upserts"? A...
2011-07-18
13 reads
Search Argument Case Study: WHERE the year was 2002…
Content Rating: Beginner, Tips
It’s entirely possible that you’re fiddling with your search arguments too much, and missing out on the...
2011-07-18
811 reads
Second Chances: PASS Community Choice Sessions
Recently I found out that my PASS presentation submission ‘Policy-Based Management’ has a second chance to be accepted for the...
2011-07-18
794 reads
SQL Server “Denali”: Details on the next version of SSIS
CTP3 of SQL Server Code Name “Denali” was made available recently, and it offers a lot of new features for...
2011-07-18
1,252 reads
SQL Server Backup – Inadvertent Striping
When I started working with SQL Server I got bit in the rear one day while I was testing backups....
2011-07-18
1,704 reads
SQLServerCentral.com Track at SQL Server Connections This Fall in Las Vegas
As has now become a regular tradition, SQLServerCentral.com is providing an educational track at SQL Server Connections (part of DevConnections)...
2011-07-18
2,248 reads
Starting and Stopping a Remote Service with PowerShell
A recent project I was working on required me to move folders from a staging location to a processing location....
2011-07-18
1,981 reads
Blogs
Database AI Agents: The Read-Only Rule
By Arun Sirpal
Fourth in a series on Ai and databases. What Read-Only Advisory Actually Means A...
Creating a SQL Stored Procedure to Load a SCD2
By DataOnWheels
This is a blog that I am writing for future me and hopefully it’ll...
Funny Money: #SQLNewBlogger
By Steve Jones
While wandering around the documentation looking for some Question of the Day topics, I...
Forums
Backup Availability Group
Please I am hoping for some feedback Specifications: Windows Server 2022 SQL Server 2022...
How Do the Experts Become Experts?
Comments posted to this topic are about the item How Do the Experts Become...
Stairway to Reliable Database Deployments Level 4 – Preparing for Production Deployment
Comments posted to this topic are about the item Stairway to Reliable Database Deployments...
Question of the Day
Secure Communications
As of June 2026, what is the best version of TLS to use with SQL Server?
See possible answers