Category Archives: Procedures

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 →

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 →

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 →

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/

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 →

  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 →

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 →

  Since cursors (being a workhorse of industry since ancient days) are never, really, going to go completely away, there’s still a need for helpful information on their use. Fortunately, this row has already been hoed: http://sqlblog.com/blogs/hugo_kornelis/archive/2007/11/21/curious-cursor-optimization-options.aspx

I can’t be the only one to notice that the Tabbed Window Management in MS SQL Server Management Studio (SSMS) is just plain awful. As my day, or task, or project progresses, I end up with more and more windows … Continue reading →

I make no secret of it to anyone: I’m not one of those “snooty” DBAs who turns his nose up at MS Access. I’m a big fan of MS Access. I’ve used it extensively since version 1.0 when it came … Continue reading →