Writing Technical Content for PASS
We’ve just posted our core guidelines for technical content on sqlpass.org. The short story is there are three main ways...
2009-08-12
871 reads
Blog Posts
Data Theft
Is employee data theft on the rise? I saw this blog post on the subject, but I had to take...
2009-08-11
792 reads
Does File Exist Check in SSIS
A very common need in SSIS is to check to see if a file exist before you run what could be...
2009-08-11
15,178 reads
Passed The 70-251 Microsoft Exam
I took the final, non-BI Microsoft SQL Server 2008 Certification Exam on Friday, so now I have finished all of...
2009-08-11
543 reads
Review: Motorola H710 Headset
Last week I posted about getting a new bluetooth speakerphone, so I thought I’d follow up with some notes about...
2009-08-11
514 reads
Security is a Zero-Sum Game...
but I don't mean with respect to privacy. But I do mean with respect to the time it takes securing...
2009-08-11
708 reads
Some Statement Start Times!
I thought I had captured statement start times within the DMV sys.dm_exec_sessions. I was absolutely wrong. However, this has sparked...
2009-08-11
951 reads
The Joy of Data Modelling.
You may think that the task of teasing out the exact nature
of the data and processes within a company...
2009-08-11
2,493 reads
24 Hours of PASS
Rick Heiges has put together an interesting event coming up on Sep 2, 2009 called 24 Hours of PASS. As...
2009-08-10
835 reads
Adding Multiple Columns to a Table With a Single T-SQL Statement
You know, I believe the old saying, “If you don’t use it you will lose it”. Well, I write a...
2009-08-10
81,788 reads
Blogs
Finding Balance: Things Will Come Up
By Steve Jones
I have a presentation on finding balance in your career that got quite a...
Who Are You Doing It For?
By Brian Kelley
But as I've matured over the years, I came to realize that I needed...
Presenting Twice in May 2026
By alevyinroc
I will be presenting my latest session, Documenting Your Work for Worry-Free Vacations, in-person...
Forums
what data type i should use for roversion col and can i use less than greater
can i use Rowversioncol ( in my database it's synonyme timestamp is used) to...
Radius Latitude Longitude
I have a table with latitude longitude in the format. 45.123456 , -111.123456 ,...
degree of parallelism
Team, I'm trying to figure out what will be the best recommendation to configure...
Question of the Day
A Fun Computer Quote
Which movie featured this quote?
"All programs have a desire to be useful."Happy April Fools! See possible answers