Archives: September 2010
One of our desktop support technicians noticed the following error from a 3rd party vendor application in an error log:
"9/22/2010 1:02 AM (GMT-06:00): The xxxxx Maintenance Service has reported an error. (200) CCmd: [DBNETLIB][ConnectionOpen (Connect()).]SQL Server does not exist or access denied.
Our technician e-mailed the error message (along…
If you read my blog or follow me on Twitter, you know that I have a strong interest in database server hardware. Having properly selected and sized database server hardware gives you a strong foundation to architect and implement a scalable, high performance database solution. Of course, a bad… Read more
I had a question come up during my “Getting Started with SQL Azure” presentation at SQLSaturday #52 in Denver last Saturday that I did not know the answer to. It had to do with how you could see what your data transfer usage was in and out of a SQL… Read more
Back in February, 2010, I did some preliminary testing on the effects of various BIOS settings and Windows Power Plans on processor performance in Windows Server 2008 R2 using the cross-platform Geekbench benchmark. That round of testing used an 2.8GHz Intel Core i7 860 processor in an ASUS desktop board.… Read more
I was lucky enough to present two sessions at SQLSaturday #52 in Denver on September 25, 2010. By my estimate, there were probably between 200-250 attendees for the event. The event was well organized, with easy parking, plenty of food, and a smooth registration process. The session rooms were a… Read more
SQL Sever MVP Jacob Sebastian (blog/twitter) has been working hard to organize the SQL Server Quiz 2010 event which will be starting on October 1, 2010. This will be a series of 30 Quiz questions, presented each day by a “Quiz Master”, who will be in… Read more
SQL Server MVP Arnie Rowland (blog/twitter) has put a lot of effort into conceiving, organizing, and publicizing Project Phoenix over the past several months. Just in case you have never heard of this effort, the gist of it is to reach out to unemployed/underemployed Developers and… Read more
On September 21, 2010, Microsoft released SQL Server 2008 SP1 Cumulative Update 10, which is Build 2799. I count 29 fixes in this cumulative update. This fixes apply to lots of different areas of the product, including SSAS, SSIS, SSRS, Full-Text Search, and the Engine.
This is a screenshot of Task Manager for a database instance that is part of a synchronous database mirroring partnership in SQL Server 2008 R2. We are using synchronous database mirroring, with a Witness instance, so we have automatic failover. There are a number of mirrored, user databases that normally… Read more
Back in late 2003, I had my basement finished,and as part of that effort, I put in a dedicated home theater with a 105” 16x9 screen, an Infocus ScreenPlay 7200 720p DLP projector and 8.1 sound. This setup has worked very well over the years, but it is time for… Read more
Here is the latest version of my Diagnostic Information Queries for SQL Server 2008 and SQL Server 2008 R2. These are very useful for determining the configuration, health, and performance of a SQL Server instance and individual database.
I have added a couple of new queries, and added some more…
Its only about a week until SQL Saturday #52 in Denver. This is an all day, free event, being held at Cherry Creek Presbyterian Church 10150 E. Belleview Avenue Englewood, CO 80111. There are a number of great speakers, and lots of free loot to be given away. Read more
I did a presentation for the fourth hour of 24 Hours of PASS – Fall 2010 today, which was a lot of fun. We had about 450 attendees for the session, which was a pretty decent turnout. A recording of the session will be available on September 27. I have… Read more
Here is a screenshot from a Dell PowerEdge R910 with four 2.27GHz Intel Xeon X7560 processors and 256GB of RAM. The Intel Xeon X7560 processor has eight cores, plus hyper-threading, for 16 logical cores per physical CPU. This gives you 64 logical processors for the entire machine. If you have… Read more
If you are interested in watching some high quality SQL Server content from the comfort and convenience of your own computer, you should consider attending the SSWUG Ultimate Virtual Conference on October 20, 21, and 22. The are a number of high quality, well-known speakers, on a wide variety… Read more