Registration is Open for SQLSaturday Orlando
It's taken a while to get here, but we're finally accepting registrations for the event. This link will take you...
2007-08-31
1,336 reads
Andy Warren
Blogging on Blogs & Professional Development
Steve posted an interesting editorial on blogs at http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=263&messageid=393904 and the follow up discussion was pretty interesting. Read that if...
2007-08-30
1,517 reads
Getting Random Results Posted on SSC
I previously blogged about using newid() to get random ordering and after chatting with Steve about it, decided to write...
2007-08-30
1,340 reads
Comments on the 2007 Jacksonville Code Camp
I attended for the morning and Brian attended in the afternoon and did a session as well. It was interesting...
2007-08-27
1,315 reads
SQLSaturday Schedule Announced
Our one day free SQL Server event is slowly gaining momentum! Draft schedule is at http://www.sqlsaturday.com/schedule.aspx. 30 sessions total and...
2007-08-27
1,566 reads
Getting Random Results
One common need that DBAs run into is building a report that returns data in some random order. Especially if you're doing some type of contest, like giving something away at your User Group meeting. Andy Warren brings us a short article on this with a look at the performance impact of randomly ordering results.
2007-08-23
4,335 reads
A Replication Interview Book Review
Andy Warren has had a great deal of experience with SQL Server replication and just picked up a new book on the topic. Rather than the standard book review, he decided to conduct the review as an interview with the author.
2007-08-17
4,281 reads
Replication Book Review/Intereview Posted on SSC
Book reviews aren't easy and it's always hard to tell if you're telling the reader anything they can't learn from...
2007-08-17
1,340 reads
SQLSaturday Update
We went for a site visit Tues and I think it will really work out well for us. Good parking,...
2007-08-17
1,390 reads
Fewer Seats Make for Better User Group Meetings?
We had a visitor from another group at our recent www.opass.org meeting and it was interesting that one bit of...
2007-08-09
1,326 reads
Blogs
Using Flyway Prepare for State-Based Deployments
By Steve Jones
One of the neat enhancements made to Flyway was the addition of state-based workflows...
How I Migrated to Azure PostgreSQL Flex from Single Server
I did a couple of posts previously on dumping/restoring Azure PostgreSQL databases and also...
Have a Plan for Your Personal Downtime
By Brian Kelley
Most of us know that spending a lot of time on social media and...
Forums
WHERE condition using ='value' returns different results that using IN('value')
Have an interesting scenario - user found a discrepancy with rows returned when running...
Complex Query (Multiple Tables & Joins) - Need to Restrict to Max Date
I am using the query listed below. USE GAGETRAK_26237 SELECT G.Gage_ID 'ID', G.Model_No 'Model',...
Unknown Token Received From SQL Server
I have an issue when a stored procedure is executed from the SQL Server...