The Business of Publishing
Despite my casual approach to the editorials and my job, this is still
something of a business and Red Gate wants...
2007-07-10
631 reads
Blog Posts
CTEs and where have I been?
I haven't posted much lately, but it has been a busy few months with many family activities. At work, I...
2007-07-09
439 reads
DDL Triggers and CREATE_LOGIN/ALTER_LOGIN
I've been doing a lot with DDL triggers in the last week or so and pulling out the relevant information...
2007-07-09
1,148 reads
The Perils of NewID for Randomizing Results
NewID() is commonly used in the order by to return the result set in random fashion. No idea whether its...
2007-07-09
909 reads
Wiki For Books Online
Browsing MSDN this morning and saw the note that they now have Wiki support. If done well it could be...
2007-07-09
603 reads
Service Packs and Support
More coming next week in editorials and already a note on the site, but support for both SQL Server 2000...
2007-07-07
644 reads
Cursors to Increase Performance?
I recently had the chance to look over a friends shoulder at a query that needed some tuning work. In...
2007-07-06
715 reads
Latest Service Packs and Books Online
I was reading a new post at SQL Server Magazine titled The More Things Change(full version available to registered users...
2007-07-06
625 reads
Midlands PASS Chapter July Meeting with SQL Server MVP Wayne Snyder
SQL Server MVP Wayne Snyder Speaks on SQL Server Integration Services (SSIS)
Midlands PASS Chapter - July 12, 2007 Meeting
Sponsored by...
2007-07-06
783 reads
The Video World
I wonder what you think of this: video shorts. I've gottne the Lockergnome newsletters for years and they've proven interesting...
2007-07-06
608 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