SQL Server with Mr. Denny:

April, 2008

April 28, 2008  9:00 AM

Checking free disk space from T/SQL

Posted by: Denny Cherry
SQL, T/SQL, xp_fixeddrives

I've seen some very creative ways to see how much free disk space SQL Servers have.  Most make use of xp_cmdshell which some very complex dos commands or vbscripts. However there is a much easier way.  Microsoft has included the system extended stored procedure xp_fixeddrives.  It returns the...

April 24, 2008  12:23 PM

My ERRORLOG shows some spids have an ‘s’ after them. What’s going on?

Posted by: Denny Cherry
ERRORLOG, sp_who3, SQL

That "s" is new in SQL Server 2005.  It means that the SPID is a system process.  For example my database is having a problem with tempdb running out of space for no reason.  When I look in the log I see that SPID 118s is the offending SPID.  When I watch SPID 118 using

Bookmark and Share     0 Comments     RSS Feed     Email a friend

April 21, 2008  9:00 AM

Back To Basics: The DELETE Statement

Posted by: Denny Cherry
DELETE statement, SQL

When you have data in your table that you need to remove the DELETE statement is the way to do that.  Using the DELETE statement without any WHERE clause will remove all the data from your table.  The WHERE clause works the same way as the WHERE clause for SELECT and UPDATE...

April 17, 2008  10:00 PM

New Article: Configure SQL Server Service Broker for sending stored procedure data

Posted by: Denny Cherry
Article, Service Broker, SQL Server 2005, SQL Server 2008

I’ve just published a new tip on SearchSQLServer.com called Configure SQL...

Bookmark and Share     1 Comment     RSS Feed     Email a friend

April 17, 2008  8:00 AM

SQL 2008 one click database encryption gives a false sense of security

Posted by: Denny Cherry
Compliance, DataManagement, Encryption, SQL Server 2008

While I think that the one click database encryption that Microsoft has built into SQL Server 2008 is a good idea, but I'm not sure how useful it actually is.  It's touted as giving you data encryption of the entire database without any code change. What this actually means is that if someone...

April 14, 2008  10:00 AM

I’ll be speaking at the NJ SQL Server User Group

Posted by: Denny Cherry
In Person Events, Service Broker

The NJ SQL Server User Group has been kind enough to invite me to come speak to them about SQL Server Service Broker.  I'll be speaking up there on August, 19,...

April 11, 2008  3:00 PM

Back To Basics: How do I use sp_change_users_login?

Posted by: Denny Cherry
Back To Basics, sp_change_users_login, SQL

The sp_change_users_login procedure has a specific purpose.  It's used to identify and correct users within a database which do not have a corresponding logins. You can specify the value of Report for the @Action input parameter to see any users which do not have a corresponding login.  This...

April 11, 2008  12:00 PM

Back To Basics: Logins and Users, what’s the difference?

Posted by: Denny Cherry
Back To Basics, LOGIN, USER

Usually Logins and Users are words which are interchangeable with each other.  However in Microsoft SQL Server they are very different things.  Because everyone assumes that they are the same thing, it can get a little confusing. Logins are created at the database server instance level, while...

April 11, 2008  5:00 AM

Back To Basics: Functions, the good and the bad

Posted by: Denny Cherry
Back To Basics, Functions, SQL

Functions are create little blocks of code.  They are fantastic for converting data from one format to another, or for looking up other values based on a lookup.  However this comes at a price.  That price is CPU power.  Doing all these additional lookups can cause extra strain on the database...

April 10, 2008  8:00 PM

Back To Basics: Stored Procedures, the work horse of the database

Posted by: Denny Cherry
Back To Basics, SQL, SQL Server stored procedures

Stored procedures are extremely useful objects.  Not only do they store T/SQL scripts for later execution, but they also provide us with an extremely important security barrier between the user interface and the database.  The security barrier is used to prevent the users from needing SELECT,...

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to: