Sign in
|
Help
Rob Farley
Rob Farley - MVP (SQL Server) runs the SQL User Group in Adelaide, Australia.
This Blog
Home
Contact
About
Syndication
RSS
Atom
Comments RSS
Search
Go
Navigation
Home
Blogs
Photos
Downloads
News
My Avatar
Can't find something?
Try checking my old blog...
http://robfarley.blogspot.com
Contact Me
IM:rob_farley@hotmail.com
Yahoo:robjfarley
Skype:rob_farley
E:rob_farley@hotmail.com
MVP (SQL Server)
Adelaide SQL UG
http://www.sqlserver.org.au
Friends - SQL / UGs
Adam Machanic
ANZ MVP feed
Brian Madsen
Darren Gosbell
David Gardiner
Geoff Orr
Greg Linwood
Itzik Ben-Gan
Jamie Thomson
Jeff Wharton
Jim McLeod
Kalen Delaney
Mitch Wheat
Nick Randolph
Paul Turner
Peter Ward
Roger Noble
Simon Sabin
Tony Rogerson
Friends - MS ANZ
Andrew Coates
Darryl Burling
Dave Glover
Dave Lemphers
Michael Kleef
Roger Lawrence
Friends - MS Learning
Glenn Block
Howard Dierking
Trika Harms zum Spreckel
Vishal Joshi
Friends - Misc
Ben Walters
Bronwen & John
Darren Neimke
Debbie Timmins
Mitch Denny
Paul Stovell
Friends - You
Did I forget to list you?
mail me
Tools
Tags
academia
acs
adelaide
adssug
arsenal
australia
certification
code camp
community
css
cte
dotnet
fun
gadgets
imagination
integration services
live.com
mvp
non-tech
personal development
photosynth
podcasts
powergadgets
powershell
professional development
recruitment
reporting services
security
spatial
sql
sql improvements
sql server 2008
tablet
teched
training
vista
wagga
web
whooiz
windows mobile
Receive Email Updates
Subscribe
Recent Posts
Fuzzy in T-SQL
Excitement building at Summit
Transfer SQL Server Object Task fixed
Video of Excel Pivot Tables
User Groups in Second Life
Archives
April 2008 (2)
March 2008 (8)
February 2008 (2)
January 2008 (2)
December 2007 (3)
November 2007 (9)
October 2007 (10)
September 2007 (1)
August 2007 (10)
July 2007 (15)
June 2007 (7)
May 2007 (4)
April 2007 (7)
March 2007 (9)
February 2007 (11)
January 2007 (18)
December 2006 (15)
November 2006 (18)
October 2006 (18)
Browse by Tags
All Tags
»
sql
(
RSS
)
academia
adelaide
adssug
australia
certification
code camp
community
cte
gadgets
integration services
powergadgets
powershell
professional development
reporting services
security
spatial
sql server 2008
teched
training
vista
wagga
Tuesday, March 04, 2008 11:54 AM
Local Server Group queries
This is really quite cool, especially since it's a tool feature, and one that will help SQL Server 2005 installs. Suppose you have many servers, all registered in Management Studio, in the Registered Servers window. Now you can right-click on the...
Posted by
Rob Farley
| with
no comments
Filed under:
sql
,
sql server 2008
Tuesday, March 04, 2008 11:26 AM
Quicker backups by ignoring index data
Sick of how slow backups can run, even though you're using compression from some tool like Hyperbac ? Greg Linwood 's had a good idea to help. A large amount of the data in any database system is the data stored in indexes (copies of the data...
Posted by
Rob Farley
| with
no comments
Filed under:
sql
Tuesday, March 04, 2008 9:17 AM
SQL Server 2008 PowerShell SnapIn
Installing SQL Server 2008 gives you SQLPS.exe, an application you can run which is a PowerShell including the PSDrives for SQL Server (and compatible with SQL Server 2005 as well!). But how do you make this work with your current copy of PowerShell?...
Posted by
Rob Farley
|
12 comment(s)
Filed under:
sql
,
powershell
,
sql server 2008
Tuesday, March 04, 2008 8:53 AM
Using ScriptingOptions with SQLPS
I've written before that SQL Server 2008 (February CTP) gives you SQLPS - a PowerShell interface to SQL Server. So I was trying to get the ScriptingOptions happening, and this is the only way I've found so far. It's ugly, and if you have a...
Posted by
Rob Farley
|
2 comment(s)
Filed under:
sql
,
powershell
,
sql server 2008
Saturday, February 23, 2008 4:57 PM
Transfer SQL Server Objects Task internals
How often do you wonder what something's actually doing under the hood (in the way that it talks to SQL Server)? It's a trick I've written about before - when working out how SSRS did multivalue parameters . This time, it's Integration...
Posted by
Rob Farley
|
1 comment(s)
Filed under:
sql
,
integration services
Thursday, January 31, 2008 5:35 PM
The end of collation woes in SQL Server
Collation is a wonderful thing. It's what makes sure that Greek people can see their data in a Greek order, and Germans can see theirs in a German order. It helps us determine whether data should be case sensitive, or whether those little dots and...
Posted by
Rob Farley
|
2 comment(s)
Filed under:
sql
Tuesday, January 08, 2008 10:34 PM
Querying distances using Spatial data types in SQL 2008
SQL Server 2008 has spatial types which are very useful for all kinds of applications. I thought it would be nice to produce one of those charts like you get in maps, telling you the distance between cities. So I start by populating the data. This uses...
Posted by
Rob Farley
|
2 comment(s)
Filed under:
sql
,
sql server 2008
,
spatial
Monday, November 26, 2007 5:18 PM
Two ways to find / drop a default constraint without knowing its name
So suppose you've created a default constraint without specifying the name (on a SQL Server 2005 machine). You do know the table and column, of course - you just don't have the name of the default constraint. Now you want to find the name so that...
Posted by
Rob Farley
|
2 comment(s)
Filed under:
sql
,
powershell
Friday, November 23, 2007 8:48 AM
How multi-value query parameters in SSRS are treated by SQL Server
This is something that has bothered for me for a while. In SQL Server Reporting Services, you write a query against a data source, and that becomes the data set for the report. Brilliant. I like to write the query in Management Studio first, and then...
Posted by
Rob Farley
|
4 comment(s)
Filed under:
sql
,
reporting services
Thursday, November 22, 2007 12:54 PM
How to format the subtotals of a Reporting Services matrix differently, using InScope
Here's the scenario. Your SQL Server Reporting Services (SSRS) report has a matrix, showing the sales of each salesperson per year. You put conditional formatting in place so that cells in the matrix that have sales over 1000000 are in a different...
Posted by
Rob Farley
|
9 comment(s)
Filed under:
sql
,
reporting services
Thursday, November 01, 2007 8:07 PM
SQL and Virtual Earth
A while back I was talking to Bronwen Zande, of Brisbane-based SoulSolutions and GeekGirlBlogs . Anyway, she and her partner John are big fans of Virtual Earth . As it's well publicised that SQL Server 2008 will have new spatial types , including...
Posted by
Rob Farley
| with
no comments
Filed under:
community
,
australia
,
adssug
,
sql
Sunday, October 28, 2007 2:01 PM
Time-zone change less of an issue with SQL Server 2008
Today the clocks went forward in most parts of Australia. And in the UK, clocks went back. I spoke to my grandmother in the UK last night - my grandfather turned 83, but he wasn't well enough to speak. And I imagine that in both locations, the fact...
Posted by
Rob Farley
| with
no comments
Filed under:
sql
More Posts
Next page »