Category Archives: Procedures

Visual Studio 2012 puts the “Ug!” in “Ugly”

I think I’m all done with this article.  Well, maybe not. Microsoft seem to have taken the really bad Metro idea from Windows 8 and pushed it onto VS2012 also.  All dull grey.  VS2010 had a classy, visually “easy upon … Continue reading

Posted in Procedures | Leave a comment

Installing Sharepoint 2010 Farm on a Single VMWare VM

If you are like most of us Sharepoint Admins (or SQL Server DBA’s in a Cluster Environment, for that matter), you will often want to run through a new service implementation on a Virtual Machine taking a snapshot and running the … Continue reading

Posted in Procedures | Leave a comment

Can’t Save Sharepoint Doc Even with proper permissions

Ran into this today.  User can open and edit, but cannot then save an excel spreadsheet from a document library.  Error msg says “document is read only”.  But it isn’t read only.  And the user has proper permissions to the … Continue reading

Posted in Procedures | 1 Comment

I’ll just leave this here….

An excellent discussion on manipulating Excel Spreadsheets directly from SQL Server TSQL! http://www.simple-talk.com/sql/t-sql-programming/sql-server-excel-workbench/

Posted in Procedures | Leave a comment

A Toast to Brent!

I owe this to Brent Ozar. I’ve been a “dba” for a long, long time.  But not an “official” DBA.  It was always an adjunct function to my regular developer duties.  I’ve been a long time “Development DBA”. In 2008, … Continue reading

Posted in Procedures | 5 Comments

The database principal is set as the execution context of one or more procedures, functions, or event notifications and cannot be dropped.

  When attempting to drop a database user, you get the following message:   One place to begin is your stored procedures.  The database user has likley been used in the “WITH EXECUTE AS” option in a stored procedure: Hey, … Continue reading

Posted in Procedures | 2 Comments

That DBA Look…

Did you ever notice that there’s just something different about the DBA, if you have one on your development team?  Way back when, when I was a developer, I always used to kinda admire the DBAs. They had a uniquely … Continue reading

Posted in Procedures | Leave a comment