I see a lot of question on the forums about migrating to new servers.At all the companies I have worked at, we have implemented server build processes to help with this process and also document needed DR procedures.
Read more →
We are now running full-speed with SQL Server 2005 at work. I have my team testing the new features and spending part of each week learning the technology. I've been telling everyone how much there is to learn.
Read more →
I've now installed SQL Server 2005 about 18 trillion times since the first beta came out. :) Seriously, since I have been trying to take all the free webcasts, training, etc that's out there and ramping up my skillset on the new technology, I have completed around 25 installs of the product.
Read more →
As we all know, SQL Server SP4 arrived on the scene late last week.It’s been a LONG time since we’ve had a major service pack release for SQL Server 2000, so this service pack is very large.
Read more →
Microsoft has set up virtual labs for people to train on their new technologies, including SQL Server 2005. You can find them here.
http://msdn.demoservers.com
The labs I have taken so far are really good for an introduction to SQL Server 2005 and Visual Studio technology.
Read more →
In this world of third-party insanity, I'm constantly amazed how much companies spend for third-party applications that are written like crap and have ZERO security. Lately, I've been plagued by a series of third-part applications using the sa username and password.
Read more →
I feel like posting today. :) We get asked about datetime formats a lot on the forums. Here is a simple little script to tell you what formats SQL Server supports using the CONVERT function.
Read more →
Physical Database Security
·Move a SQL Server out of DMZ (this one was ticking me off). --Completed.
·Create new VLAN's for SQL Server and migrate servers.--Completed.
oCreated four VLAN's to provide separation of database servers on network.
Read more →
I know this is a little late, but I wanted to finish it up for my own purposes. The final day of PASS was incredible. Anytime you get a chance to listen in on Kimberly Tripp you should take that chance and remember it.
Read more →
WOW....what an interesting last couple days. I was priviliged to attend a couple incredible meetings. I was unfortunate enough to attend a session that was not so great (cough, cough)!!!!! Such is life in the world of conferences.
Read more →
High Availability with SQL Server 2005
This was a great session. It was cut a little short by an EMERGENCY EVACUATION!!! Go figure. :) It focused on the new enhancements that SQL Server 2005 has added to provide for greater flexibility and implementation of high-availability networks.
Read more →
Just thought I'd give a brief rundown of what's going on at PASS. I just attended the keynote address and my first session. The session was Developer Productivity and Server Extensibility with SQL Server 2005.
Read more →
This recently came up as a discussion on the www.sqlteam.com forums. I posted the options below and Kristen suggested I post it in my blog, so here it is. :) This is by no means meant to be comprehensive.
Read more →
This is something I see posted continuously on various forums. Some fine, young idiot on one forum yesterday said the solution was to just detach and attach all the system databases.
Read more →
I got to attend the second part of a Yukon review last week that was really informing and interesting. It covered some of the basics which I had already seen, such as the additions to Transact-SQL (pivot, apply, etc).
Read more →
While installing the EMC SnapView software, we had a problem with our LUNs not “anchoring”. We clone the drives, then use mountvol to mount them. We then change the LUNs to the appropriate drives for our SQL Server instances.
Read more →