Have you tried out YourGMap? It allows you to plot multiple locations on one map (Google Maps) and publish it to the Internet for others to see. We are currently using it to plot the houses that we've looked at or need to look at in search for our new home.
Read more →
Here's the stored procedure that I use to update statistics on a database. I don't use sp_updatestats as it doesn't allow you to change the number of rows to sample. I typically run it weekly on the databases that I support.
Read more →
Last week, I received a new laptop. For the past few days, I've been installing all of the applications that I need. Today, I decided to tackle Red Gate's SQL Compare.
Read more →
Some of our developers regularly debug stored procedures in SQL Server 2000. In fact, they can't live without it. The next version of their application will use SQL Server 2005.
Read more →
If you've installed multiple instances of SQL Server 2005 on the same database server, perhaps you've noticed Microsoft's naming convention for the file locations. They are now using MSSQL.n, where n is the instance number.
Read more →
Which SQL Sever 3rd Party tools do you use? We've been using Red Gate's SQL Compare and SQL Data Compare for a few years now. I rarely use the data compare tool though, but not because it's not a great tool.
Read more →
Yesterday, a developer sent me an e-mail indicating he was having problems creating a table in SQL Server Management Studio. He was using the GUI rather than the CREATE TABLE T-SQL statement.
Read more →
If you are considering using SQL Server 2005 on a 64-bit platform, then I'd highly suggest reading Michael Otey 's “The Essential Guide to 64-BIT Server” article in SQL Server Magazine's May 2006 issue.
Read more →
Service Pack 1 is now available for SQL Server 2005. You can download it here.
Here is the list of the new features and improvements included in this service pack.
Read more →
A while ago, I posted my DBCC DBREINDEX and DBCC INDEXDEFRAG stored procedures. They perform the DBCC operation on all indexes in the database, which is probably not a good idea.
Read more →
You can find the poster of the SQL Server 2005 System Table Map in the December 2005 issue of SQL Server Magazine. Thanks to Rob Volk, here is the online version.
Read more →
The below stored procedure performs a RESTORE of the newest BAK file in the specified directory (@bkpDir). I recommend putting it into an Admin database (hey just name it Admin!) rather than in master.
Read more →
Once again, I attended 3 sessions today (Friday): Kevin Kline's "Performance Baselining, Benchmarking, and Monitoring", Tom Davidson's "SQL Server 2005: Dynamic Management Views", and Ross LoForte's "Optimization Considerations for Designing Very Large SQL Server Database Systems".
Read more →
Wow, what a great experience!
Everyone here has been so friendly. It was nice to put faces to names even for people I didn't actually meet. I hope that I can attend another PASS conference some time in the near future and perhaps finally meet up with Nigel Rivett (I never did find him).
Read more →
At the "General Session" today (Thursday), we saw a demo of the Upgrade Advisor tool which is used to prepare for the SQL Server 2005 upgrade. It'll show you what you need to change prior to the upgrade and what you can change after the upgrade.
Read more →
On Tuesday, I attended Kimberly Tripp's "The Next Generation DBA: Critical New SQL Server Features NEED to Learn!" pre-conference seminar. It was awesome! She is a fantastic speaker. She covered database snapshots and database mirroring amongst many other DBA topics.
Read more →
During the "General Session" today (Wednesday), they threw out SQL Server 2005 t-shirts. Almost everyone got one. All of the t-shirts were black and had a verb on the back. Mine says "Replicate".
Read more →
Paul Flessner, Senior Vice President at Microsoft, announced this morning in his Tech.Ed keynote that SQL Server 2005, Visual Studio 2005 and BizTalk Server 2006 will launch the week of November 7.
Read more →
Service pack 4 for SQL Server 2000 was released this morning. Check this out for details.
Legacy Comments
Brett (Not just a Number...huh?)
2005-05-06
re: SQL Server 2000 service pack 4 Yeah I know.
Read more →
Get Ready for SQL Server 2005
“Get the facts about migrating to SQL Server™ 2005 in one information-packed day in a city near you! SQL Server experts from Scalability Experts, DevelopMentor, and Hitachi Consulting will present practical, real-world information in three tracks—administration, development, and business intelligence.
Read more →