Early July 2010 PASS VC Presentations
In July start with the following presentations from the AppDev and DBA Virtual Chapters of PASS:
Loops, Lookups and Splits: SSIS Beyond the Basics
Why Should I use Stored Procedures?
The Private Cloud
Cloud computing is becoming more and more prevalent in technology. However most people think of a public cloud on the Internet. Steve Jones says a private cloud might be a better idea for many companies.
A closer look at CXPACKET wait type in SQL Server
If you have a server that has more than one CPU core, you may experience high values of CXPACKET wait types. This is typically due to queries that run in parallel and the real issue is to understand how different versions of a query can impact CXPACKET waits. In this tip we examine how changing a query can impact CXPACKET waits.
Copy-and-Paste SSIS Execution Monitoring with Failure-Alert Email
This SSIS package monitors the execution of any SSIS tasks pasted into its sequence container, and sends an email when a failure of any embedded task occurs.
GOSQL vs. NOSQL
If we're getting pulled down a blind alley by acronyms, we may as well make up a more optimistic one.
The Utilty
Is Information Technology a utility service for companies? Steve Jones thinks it can, and should, be, but it can also be a lot more. It can be a strategic part of your enterprise.
TSQL Challenge 34-Search for two keywords within the maximum distance
This challenge is all about searching for two keywords in a string with a maximum distance of 'one word' between them.
Physical Join Operators in SQL Server - Hash Operator
In the concluding part of the Physical Operators series we look at the Hash operator.
Assumptions
For this Friday poll, Steve Jones asks about assumptions that cause you problems at work.
Dynamic creation of Insert, Update, Delete Stored procedures
Automates the creation of INSERT, UPDATE & DELETE stored procedure of a table
Blogs
Advice I Like: Pyramid Schemes
By Steve Jones
If someone is trying to convince you it’s not a pyramid scheme, it’s a...
Using Prompt AI for a Travel Data Analysis
By Steve Jones
I was looking back at my year and decided to see if SQL Prompt...
FinOps for Kubernetes: Leveraging OpenCost, KubeGreen, and Kubecost for Cost Efficiency
In the era of cloud-native applications, Kubernetes has become the default standard platform for...
Forums
Database file shrink issue.
Hi experts, I have a 3+ TB database on a 2019 sql server which...
The North Star for the Year
Comments posted to this topic are about the item The North Star for the...
Multiple Escape Characters
Comments posted to this topic are about the item Multiple Escape Characters
Question of the Day
Multiple Escape Characters
In SQL Server 2025, I run this code (in a database with the appropriate collation):
SELECT UNISTR('%*3041%*308A%*304C%*3068 and good night', '%*') AS 'A Classic';
What is returned? See possible answers