Category Archives: S.W.A.T.

Software and Techniques

Anti-Oopsie Tip of the Day

We’ve all done this. You know you have. Here’s the problem: When scripting a Stored Procedure, you don’t save the script. You execute the script to create the stored procedure. Then you throw the script away, and execute the stored … Continue reading

Posted in S.W.A.T. | Leave a comment

SSMS Doesn’t Show ALL FILES in Properties Dialog

You often hear people say that SSMS is pretty good, but you still have to script some things. Here’s one of those things. I had a problem where I found (just laying about the place) some Data and Log files. … Continue reading

Posted in S.W.A.T. | Leave a comment

Like Compounding Interest – For Backups!

I got our backup schedule back under control. Here’s what happened. And maybe there’s some useful info here for others. We do nightly FULL backups, with Hourly Differentials during business hours. The Gist: If you run out of space for … Continue reading

Posted in S.W.A.T. | 1 Comment

Annoying Windows Password Complexity

I had to change a client password last week, and when I did I find out that they are one of those who think that using the Windows Minimum Password Complexity Requirements will help them be more secure. I already, … Continue reading

Posted in S.W.A.T. | Leave a comment

SQL Server Attach Database Doesn’t show MDB LDB files

In case any of you are running into this problem: If you go to attach a SQL Server database in SQL 2005 (and perhaps in 2000, not sure), and you browse to the folder or directory that has the .MDF … Continue reading

Posted in S.W.A.T. | Leave a comment

Invalid Character Value for Cast Conversion in Access Linked View

In MS Access, a SQL Server 2008 view linked as a table, when opened offers: [Microsoft][SQL Server Native Client 10.0] Invalid Character Value for Cast Specification(#0) Upon exam, opened view in SSMS and found that the view had several columns … Continue reading

Posted in S.W.A.T. | Leave a comment

How To Stop SQL Injection Attacks

Like many other sites, I’ve been hit by the recent spate of SQL Injection Attacks. My point here is not to go into great detail about how the exploit works, but rather to offer a relatively simple solution which, so … Continue reading

Posted in S.W.A.T. | Leave a comment