Space, WER, Windows 2008, Windows Error ReportingIf you are using Windows 2008, you may be like me. Wondering where the hell all this drive space is disapearing to. Continued »
0 Comments
RSS Feed
Email a friend
Replication, SearchSQLServer.com, SQL ServerI've published a new artcile over on SearchSQLServer.com. This article is titled "Push vs. pull: Configuring SQL Server...
2 Comments
RSS Feed
Email a friend
Quest Software, Trent Mera, WebcastThe folks at Quest and Live Meeting worked overtime to get yesterday's webcast recording posted already. This way if you missed the great webcast that...
0 Comments
RSS Feed
Email a friend
Clustering, SQL Server 2008, Starwind, Webcast, Windows 2008On September 15, 2009 I'll be hosting a webcast entitled "How to Set Up a Cost-Effective Windows Server 2008 Cluster with SQL Server 2008 and Tune The Performance". During this webcast I'll be showing how to use...
0 Comments
RSS Feed
Email a friend
Server Hardware, System DesignI am so sick and tired of people posting questions on various forums along the lines of "We just bought a Some brand and model of server and it has n hard drives in it. How should I setup the database on these drives?"
0 Comments
RSS Feed
Email a friend
Permissions, SQL Server 2005, SQL Server 2008, T/SQL, TablesWhen a user that doesn't have sysadmin rights creates objects by default they will be created in the schema that is the users default schema. Now the catch to this is that if you grant the user rights into the database via a domain group that domain group then the user doesn't have a default...
0 Comments
RSS Feed
Email a friend
Kevin Kline, Quest Software, Troubleshooting, WebcastNext week I have the pleasure of presenting another Pain of the Week webcast for Quest Software. This...
0 Comments
RSS Feed
Email a friend
Enterprise Manager, SQL Server 2000, T/SQL, TablesWhen using SQL Server 2000 and the user doesn't have sysadmin rights, and their login isn't mapped to the dbo user within the database all objects created will be, by default created under the user schema. This is the normal behavior of SQL Server 2000. In order to allow users who are not...
0 Comments
RSS Feed
Email a friend
Diskpart, Virtualization, Windows 2008When using VMs and Windows 2008 you have the ability to easily grow the C drive on your servers. This makes it much easier to assign only the space needed to the C drive of your servers saving you a ton of space. However I recently had a few machines say that the disk was extanded in Computer...
0 Comments
RSS Feed
Email a friend
Article, SearchSQLServer.com, Service Broker, SQL Server 2005, SQL Server 2008Today a new article that I wrote was posted up on SearchSQLServer.com. The article is about setting up SQL Service Broker to use Certificates to secure the traffic between the...
0 Comments
RSS Feed
Email a friend
