Sections
-
Recent Posts
- Very One Sided
- Visual Studio 2012 puts the “Ug!” in “Ugly”
- What a Year Brings
- Installing Sharepoint 2010 Farm on a Single VMWare VM
- Access 2010: A Rare Second Chance
- Waaaay too busy to post….
- I’ll just leave this here…..
- Can’t Save Sharepoint Doc Even with proper permissions
- Can I Kick It? Yes I Can!
- Lessons Learned from a Cheese Curd maker
- I’ll just leave this here….
- So You Want To Be An Air Traffic Controller?
- A Toast to Brent!
- Does “Denali” portend the end of OLAP?
- Anti-Oopsie Tip of the Day
- The database principal is set as the execution context of one or more procedures, functions, or event notifications and cannot be dropped.
- That DBA Look…
- TSQL Cursor Options
- 2008 != 2008R2
- SSMS Tab Bar is Nearly Useless
1. The Daily Reading List
- Aaron Bertrand
- Adam Machanic
- Brent Ozar – Too Much Information
- David Bermingham
- David Stein – Made2Mentor
- DBA Survivor
- John Sansom, DBA
- Jonathan Kehayias – Rambling DBA
- Matt Whitfield
- Paul Ibison – Replication Answers Blog
- Simon Sabin
- Simple Talk
- SQL Blog Rankings
- SQL in the Wild
- SQL Skills
- SQLServerPedia
2. FOSS
Category Archives: S.W.A.T.
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
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
A Coding Insight
Someone asked me the other day why I had done something in a particular way. Here’s an example and an explanation: I had done something similar to the second example. The two versions do exactly the same thing – it’s not a trick … Continue reading
Posted in S.W.A.T.
Leave a comment
SQL Principal owns assembly and cannot be dropped…
Dropping user from database results in: “The database principal owns an assembly and cannot be dropped. (SQL error 15154).” I’ve seen this error, “Principal owns a schema in the database” before, and you simply change the owner of the schema … Continue reading
The Combat DBA
It happened so suddenly… I was sitting in my cubicle, working on the umpteenth “top priority” of the day. When it suddenly dawned on me. I was deluged. I was overwhelmed with sensory input. So-n-so cabinet member was going before … Continue reading
Posted in General, Procedures, S.W.A.T.
Leave a comment