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…
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…
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…
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.
SELECT dbrole1.name AS dbrole1_name
, dbrole2.name AS dbrole2_name
FROM sys.database_principals AS dbrole1
JOIN sys.database_role_members AS dbrm
ON dbrm.member_principal_id = dbrole1.principal_id
JOIN sys.database_principals AS dbrole2
ON dbrole2.principal_id = dbrm.role_principal_id
WHERE dbrole1.name LIKE 'myRole%'
ORDER BY dbrole1.name ASC
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
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…
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)…
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.
A 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…