SQL Saturday is coming to Phoenix, Arizona on February 19th, 2011. I have submitted my session for this event. If my session gets approved, it’ll be the same presentation that I gave recently at SQL Saturday #55.
Read more →
I started my IT career as a student worker in the database team at the County of San Diego. Although I worked on many different things in that group, it launched my career as a Database Administrator.
Read more →
On Saturday (9/18), I presented "Performance Tuning with Traces" at SQL Saturday #55. There were about 65 people in attendance, and it was standing room only. As promised, you can download my presentation materials here.
Read more →
If you are interested in finding out the largest SQL projects in the world, you should check out this PowerPoint presentation. It’s from Kevin Cox of SQL CAT at Microsoft.
Read more →
SQL Saturday is coming to my hometown, San Diego, on September 18th, 2010. I have submitted my session and hope that it gets approved. Let me know if anyone is attending the event in San Diego.
Read more →
Paul Randal recently blogged about three life-changing events that brought him to where he is today. His blog is a very interesting read and idea, and so I bring to you my three events that brought me to where I am today in my technical career as a SQL Server DBA.
Read more →
My Database Growth Tracker tool is featured in a SQL Server Magazine web article that Kevin Kline wrote.
Check out the web article here!
Legacy Comments
Brett
2009-10-09
re: SQL Server Magazine web article about a tool I wrote Wow.
Read more →
If you've ever had to copy large files on a Windows platform using the Windows copy method (copy/paste in Windows Explorer or copy/xcopy commands), then you know how slow it is.
Read more →
Microsoft published the ERD for the system views about a month ago, but I'm just now seeing it. It is available in PDF or XPS format.
You can download them here.
Read more →
Microsoft has released SQL Server 2005 service pack 3 and cumulative update package 1 for service pack 3. For more information about SP3, check this out. For more information about SP3 CU1, check this out.
Read more →
Has anyone used SQL Server FineBuild before? According to the web site, it "provides 1-click install and best-practice configuration of SQL Server 2005." It doesn't mention anything about clusters though, which is what I'd be interested in as installing SQL Server on a cluster is a bit of a pain.
Read more →
There's a lot of information out there on how to avoid SQL injection attacks, but I wanted to point you to this blog due to the recent increase in such attacks.
Read more →
In a previous blog, I mentioned a performance problem that I've been working on for a few weeks. I can finally say that this issue has been resolved. The problem was that the database server (SQL Server 2005) was running at 95%-100% CPU utilization at all times.
Read more →
I'm proud to announce that I have received the Microsoft MVP Award for my contributions to the SQL Server community. I'd like to thank Ben Miller from Microsoft for the nomination.
Read more →
Microsoft announced yesterday that the new version of SQL Server, code-named "Katmai", will be delivered in 2008. Check this out for information on "Katmai".
Legacy Comments
Jon
2007-05-11
re: SQL Server "Katmai" Wow we barely got to dig into 2005.
Read more →
We don't use the default port for SQL Server for security reasons, so we usually have to explicitly tell the client how to connect to SQL Server by creating an alias on the client machine.
Read more →
Check out this article for white papers, scripts, and tools on SQL Server 2005 best practices.
Legacy Comments
Jesse
2006-12-13
re: SQL Server 2005 - Best Practices good resource.
Read more →
We've been having performance problems on a new 64-bit SQL Server 2005 cluster in our test environment. We opened a ticket with Microsoft to assist us with this. After modifying several things, the only thing that was slow was Management Studio.
Read more →
In SQL Server 2000, you could generate a SQL script easily using the Generate SQL Script wizard. You could get to it from pretty much anywhere from within Enterprise Manager. For instance, you can get to it by right clicking on any object in the database, then selecting All Tasks, and then selecting Generate SQL Script.
Read more →
In Query Analyzer, we could easily comment blocks of code using Ctrl+Shift+C and uncomment blocks of code using Ctrl+Shift+R.
These keyboard shortcuts do not work in Management Studio unless you switch the keyboard scheme to SQL Server 2000.
Read more →