Table monitoring & Table informations in SQL-Server databases

August 16th, 2014 No comments

If you are a database admin or developer you always should know and take care about, where tables are stored, how much space they consume and how data grows in the tables. One of the golden rules in SQL-Server database development is not to use the PRIMARY file group as the default location for user-tables in your projects.

Better create a new custom file group, and set it as the default file group. From my opinion, this is the point, where a good database design starts: “With the implementation of additional and customized file groups”. In this article you will find a fast example how to do that. I had to mention file group separation first, before we can move on, because this was actually my motivation to write that query and this blog post.

If you never think about it, or don’t even have an idea where the tables in the database are located, how big they are and how much rows your tables contains. You better take care of it…NOW!

Therefor i wrote a quick management query, especially aligned Read more…

The mysterious case of a crashing server (LanmanServer) service

July 27th, 2013 3 comments

A few days ago, we had mysterious issues with one of our Windows Server 2008 R2 SP1 machines. The problem was noticed, because an information popped up in the system tray, of other terminal servers, that the Remote Desktop Licensing Service is not available on the network.

The source server of the problem was found pretty easy. After a troubeshooting for a while, i found out, that the problem-machine is not available via UNC-Path’s and Named Pipes.

If i tried: net use \\<troublemachine> from a remote system i received the error message, that the system is not available. So i searched for the service, that is responsible for providing this services, and this is the server service also known as LanmanServer. Read more…

Support the SQL-Server community

January 17th, 2013 No comments

HP I/O Accellerator Card – Test

November 16th, 2012 No comments

This week i had the honor to test a G2-Series HP I/O-Accellerator Card.
Installation and Post-Configuration of the card is very easy. So you could go ahead immediately with testing these Hot Stuff.

We configured the card to 50% Performance, so we loosed 50% of the available space on the I/O-Card. But for our reasons, to put the TEMPDB of MS SQL-Server 2008 R2 and an Archive log of an ERP-System database on it, shoud this be space enough.

So here are the test results. I don’t wan’t to comment to much. Look at the results. They are self explaining. Read more…

Enumerate Database-Role Membership

November 12th, 2012 No comments

Hey Guy’s

here i am with my 1st SQL-Server Post!

If you want to know the membership of a database role, to what other database roles the role
belongs to, i have a good satatement for you.

Facebook – Behind the scenes

December 28th, 2011 No comments

I always recommend colleagues to read and watch the thread on sysadminslive.com about the Facebook IT Mangement and Operations strategy.

Because the using good tools and ideas to observe there system.

Take a look at yourself: http://www.sysadminslife.com/linux/facebook-ein-blick-hinter-die-kulissen-und-in-das-komplexe-system

Windows Terminalserver Farm & 8dot3 names

March 14th, 2011 No comments

Hey Folks!

currently i’m on the way to deploy a Windows Server 2008 R2 terminal server farm. One server is already up and running productive and the other is one step before going online. I work a lot of with GPO’s and user roaming profiles, to ensure to have excatly the same configuration on the new server for all users. Also i use control panel restrictions to display only neccessary .CPL’s to the user.

And one special control panel addin, what is shipped with the MS Office suite ML32CFG.CPL (responsilbe for configuring MS Outlook MAPI Profile), i discovered how important it is, to ensure that applications have to be installed in the same order as on the other terminal servers. Why, you may ask….because, of the 8dot3-names (8.3) and the windows internal file/path handling. In some cases the OS calls an an application it tries to use the 8dot3 path / name. Read more…

Categories: Microsoft, Windows Tags:

Soluto – Anti Frustration Software

June 14th, 2010 No comments

Soluto (www.soluto.com)

It’s an Awesome Tool, to Speed Up Your System Boot, Fix System Slowdowns

Sound’s very interesting and i’ll give them a try.

found via Lifehacker (http://tinyurl.com/26py4s2)…

Categories: Tools, Windows Tags:

Group Policy Search

May 2nd, 2010 No comments

Discovered via Daniel Melanchton’s Technet Blog

This is really a nice Tool to find existing Group Policies easily. The Group Policy Search

Thank’s Daniel for that helpful information.

Categories: Microsoft, Windows Tags: , ,

Automate Logins with Keepass and Firefox

March 10th, 2010 No comments

KeeFoxA long time ago, but now it’s here!

everyone knows it’s very annoing if you have to login to multiple websites during work days. It would be much easier to have a tool tool, what helps us to automate the login process to websites like Amazon, Facebook, Microsoft, Onlinebanking, etc.., where i am registered to. That would safe time and increases workflow and you don’t need to consider about passowrds anymore. Before this article i used a very simple tool to manage my passwords. I also heard and tested Keepass in the past, but it brought no advantage on my workflow.

Now I found this tool Read more…

Categories: Tools Tags: , ,