Sections
-
Recent Posts
- 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
- I Cannot Believe How Buggy MS Access Has Become!
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: 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
TSQL Cursor Options
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
Posted in Procedures
Leave a comment
SSMS Tab Bar is Nearly Useless
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
Posted in Procedures
2 Comments
I Cannot Believe How Buggy MS Access Has Become!
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
Posted in Procedures
9 Comments