Subscribe to this blog
Archives: September 2010
Aliases in SQL Server 2008
Recently I set up replication and as the target server was not on our domain I initially used an IP address to identify the server.
After coming across an issue with the GUI tools that prevented me from entering an IP address, I initially scripted out the replication and manually… Read more
0 comments, 202 reads
Posted in measure twice, cut once. on 20 September 2010
SQL Server 2008 Surface Area Configuration
Ever wondered what happened to the SQL 2005 Surface Area Configuration Utility in SQL SERVER 2008.
Well you can accomplish pretty much the same thing in SQL SERVER 2008.
and then
you can also use sp_configure if that spins your wheels.
1 comments, 178 reads
Posted in measure twice, cut once. on 14 September 2010
Naming Keys & Constraints
G'day,
This is pretty much my first blog post - at least on sqlservercentral.com - so to get started I thought that I'd mention something simple that I like to do.
And that's naming my own constraints, rather than letting SQL SERVER apply some cryptic string for me - however… Read more
1 comments, 83 reads
Posted in measure twice, cut once. on 1 September 2010