Warning: Use of undefined constant íWP_POST_REVISIONSí - assumed 'íWP_POST_REVISIONSí' (this will throw an Error in a future version of PHP) in /homepages/10/d210128362/htdocs/wp-config.php on line 109
» Page 2
Warning: Declaration of Suffusion_MM_Walker::start_el(&$output, $item, $depth, $args) should be compatible with Walker_Nav_Menu::start_el(&$output, $item, $depth = 0, $args = Array, $id = 0) in /homepages/10/d210128362/htdocs/wordpress/wp-content/themes/suffusion/library/suffusion-walkers.php on line 39
Oct 182011
 
Fixing orphaned users

Whenever I restore a production database to a development server, I often end up with orphaned users. You can see in the screen shot below that username matt has no login associated with it. An account becomes orphaned when there is a user account with security rights in the database that is not linked to [Keep reading…]

Sep 222011
 

Today I am continuing from my introduction to SSMS Template Explorer.¬† Part 2 today is a quick look at creating your own templates.¬† I mentioned in the previous post that if you delete one of the Microsoft provided templates, it will be recreated when you next launch SSMS.¬† Another thing of note: if you make [Keep reading…]

Sep 092011
 

In my current job, I have a MySQL database server that I am responsible for.¬† We also run some reporting through Cognos against this server.¬† I ran across a problem while testing reports on an upgrade to Cognos 10.¬† I thought I would share the solution here in case it helps someone else out someday. [Keep reading…]

Sep 092011
 
SSMS Template explorer

I have used several different methods for collecting SQL scripts (both that I have written, and have borrowed from others) to reuse.¬† A few that come to mind include: 1. saving the scripts in individual .sql files somewhere on my hard drive, 2. storing the scripts as an individual page in Microsoft Onenote. 3. saving [Keep reading…]

Aug 312011
 

Just a quick funny for today. For my daily to do list, I generally work off of a half sheet of paper on my desk.¬† I keep a running list and it feels good to physically scratch a done item off.¬† This morning I added to my list: “Update SSMS tools on <server name removed [Keep reading…]

Aug 222011
 

Jen McCown from midnightdba.com started a useful (to me anyways) set of homework assignments called Applied SQL.¬† Each post has a homework assignment for us.¬† This first one has been useful to me in order to make myself read Books Online and understand where information comes from, rather than just running a script when I [Keep reading…]

Aug 182011
 

System tables have lots of interesting and useful information stored on all facets of SQL server.¬† Generally speaking, whenever I find a script that shows useful information, I store that script away for future use.¬† I then run the script whenever I need the information without really thinking about it.¬† Jen McCown from midnightdba.com started [Keep reading…]