Give Us TRIM()!
If you're like me, you've probably typed in LTRIM(RTRIM([value])) hundreds, if not thousands, of times during your travels through SQL...
2009-05-28
1,939 reads
Blog Posts
Good Article on Data Warehousing Best Practices in SQL Server 2008
If you are involved data warehousing, or even if you are just a beginner, you may want to check out...
2009-05-28
1,504 reads
I Can Run Hyper-V!
I noted recently that I purchased a new desktop with the intention of moving to Windows 2008 and Hyper-V. That...
2009-05-28
1,641 reads
Why I Say Something about Running as Administrator
On a couple of recent webcasts, I pointed out the folks were running with the local Administrator account. To start...
2009-05-28
2,157 reads
Catalog view: sys.tcp_endpoints
I was playing around with the endpoint catalog views this afternoon just looking at ways to do poor man's configuration...
2009-05-27
2,824 reads
Configuring Auto-Retry on SQL Server Agent
The goal of this post is to explain how to take advantage of Auto-Retry and why you will want to...
2009-05-27
7,232 reads
Minimalist Design - Part 3
One of the labs I frequently do with students is to design a database for a training business, something which...
2009-05-27
1,451 reads
Speaking at Augusta Developer's Guild
Tomorrow night, May 28th, I'll be speaking the Augusta Developer's Guild. This is a make-up from earlier in the year...
2009-05-27
1,379 reads
Using Windows 2008 as a Workstation
I have a new machine, albeit one with a bad video card, running Windows 2008 Server R2 with Hyper-V. My...
2009-05-27
1,525 reads
Hyper-V
A great Hyper-V blog here at Accentient Blog.
I was searching around for information on setting up Hyper-V and I...
2009-05-26
1,313 reads
Blogs
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...
2025 Wrapped for Steve
By Steve Jones
I’ve often done some analysis of my year in different ways. Last year I...
Forums
reaching ftp thru winscp but erroring in ssis ftp task connection
Hi, below i show various results trying to reach our ftp site (a globalscape...
Finding Motivation
Comments posted to this topic are about the item Finding Motivation
The Last Binary Value of the Year
Comments posted to this topic are about the item The Last Binary Value of...
Question of the Day
The Last Binary Value of the Year
What does this code return?
SELECT cast(0x2025 AS NVARCHAR(20))Image 1:
Image 2: 
Image 3: 
Image 4: 
See possible answers