Resource Governor, SQL, SQL Server 2008The engineers from Microsoft PSS has posted some excellent information on thier blog about SQL Server 2008's Resource...
0 Comments
RSS Feed
Email a friend
Article, Config, DataManagement, SQL, SQL Server 2005, SQL Server 2008I’ve published a new tip over on SearchSQLServer.com entitled “
0 Comments
RSS Feed
Email a friend
CLR, Config, SQLThere are two camps when it comes to SQL CLR. The DBA camp, which says don't use it, it'll kill your SQL Server and the Developer camp which says that it will save you loads of time and that you should use it for everything. These two different camps also represent the different messages which...
0 Comments
RSS Feed
Email a friend
Data Types, T/SQL, XMLSo, we've had the ability to use XML within the SQL Server databases since SQL 2000 came out. What's the big deal you ask? How can I use it to make my life easier you also ask? When I first started looking into this whole XML thing I was thinking the same thing. How is this blob of data...
0 Comments
RSS Feed
Email a friend
DataManagement, SQL, SQL Server 2005, SQL Server 2008, SSIS, XMLReceintly I was working on a project where I needed to use a foreach loop with an SSIS project, but couldn't for the life of me get it to properly process the XML document which I...
0 Comments
RSS Feed
Email a friend
Attack Prevention, Security, SQL, T/SQLThe most common way for people to insert invalid data or cause damage to your database is through what is called a SQL Injection Attack. This is when malicious code is placed within the responses which are expected and that code is not caught and it instead executed. Depending on what level of...
0 Comments
RSS Feed
Email a friend
Development, In Person Events, SQL, SQL Server 2008The Microsoft Code camp is coming upon us shortly. I've submitted three sessions (so far) to the organizers of the code camp. They've told me that odds are I'll be able to do all three sessions. I've tagged all my sessions with
0 Comments
RSS Feed
Email a friend
In Person Events, SQL Server 2008Microsoft has announced the schedule for the SQL 2008 launch event. You can register here. The official launch is being held in Los Angeles this time around. I'll be there,...
0 Comments
RSS Feed
Email a friend
Article, Data Types, Development, SQL, SQL Server 2005, SQL Server 2008, T/SQLI've published a new tip over on SearchSQLServer.com entitled "
0 Comments
RSS Feed
Email a friend
Data integrity, Data Types, NULL, SQL, T/SQLThere is always a discussion going on somewhere over having NULL values in a database. Some people (such as myself) are fine with NULL values. Some people don't like having NULL values in there database for some reason. I've heard all sorts of reasons; "The screw up performance", "They are...
0 Comments
RSS Feed
Email a friend
