In Boston for TechEd
This will be my first ever TechEd and I'm looking forward to it. I was able to go to the...
2006-06-11
1,492 reads
Databases – Infrastructure – Security
Two things I wish they'd change about endpoints in SQL Server 2005
I've
been playing around with endpoints in SQL Server 2005 looking at how they can
be used to enhance security for SQL...
2006-05-27
2,146 reads
When It Takes Time...
Saw this from Jason Haley's Interesting Finds post for the morning of May 25, 2006:
Project Managing Latency or: How to...
2006-05-25
1,451 reads
Disaster Recovery and SQL Server, Part II
In a previous post, Disaster Recovery and SQL Server, Part I,
I pointed to the Microsoft Knowledge Base (KB) article which...
2006-05-24
1,501 reads
SQL Prompt
I downloaded and installed SQL Prompt from Red Gate this morning. If
you aren't aware, PromptSQL was bought by Red Gate...
2006-05-23
1,623 reads
Disaster Recovery and SQL Server, Part I
The last few weeks I've been working on disaster recovery procedures
for my organization. We review them at least yearly to...
2006-05-20
1,651 reads
Backing up virtual machines on VMware ESX Server
I know VMware and Virtual Server
technology is becoming more and more prevalent in organizations as both
packages can greatly reduce hardware...
2006-05-17
1,617 reads
Nice Article on Security Myths in May/June 2006 Issue of TechNet Magazine
The May/Jone 2006 issue of TechNet Magazine has a feature on security. One of the articles is titled Deconstructing Common...
2006-05-12
1,532 reads
Review of SQL Server 2005 Integration Services, Part 1 of 4
Back in First Impressions of Professional SQL Server 2005 Integration Services,
I indicated I felt the book was worth the buy...
2006-05-10
1,459 reads
Excellent article on cracking SQL Server passwords
The SQLServerAdvisor mailing from SearchSQLServer.com had a link to a
very good article on cracking SQL Server passwords. The article, by
Kevin...
2006-05-09
1,598 reads
Blogs
From SQL Saturday to Day of Data
By ReviewMyDB
A behind-the-scenes look at Day of Data Jacksonville 2026, the transition from SQL Saturday,...
PostgreSQL 18 Finally Makes BUFFERS the Default. Here Is Why That Matters
You run EXPLAIN ANALYZE on a slow query, stare at the plan, and something...
A New Word: La Guadière
By Steve Jones
la guadière – n. a glint of goodness you notice in something that you...
Forums
Converting Money
Comments posted to this topic are about the item Converting Money
non ascii columns in a utf-8 .txt file
hi, we couldnt get our upstream data source developers to supply what is sometimes...
PolyBase Trace Flags
Are there any good articles on all the trace flags that are enabled on...
Question of the Day
Converting Money
Does this run successfully on a SQL Server 2022, US English default installation?
DECLARE @YenAmount MONEY; SET @YenAmount = ¥1500; SELECT @YenAmount AS RawValue;See possible answers