In Sharepoint sometimes users have difficulties to grasp the permissions system. You may have to change users membership quite a few times because ‘user X must have the same rights as User Y’. If you have more thtan a couple of users, it can become quickly very boring. The following […]
Got pissed off because your batch file has to know the current date and time and depending on the user or machine logged on you don’t get the same result? Let’s use today snippet: regional independent date time batch job. In the past, you used: date /t time /t But […]
Working in big AD forests and domains can be sometimes challenging, as powershell cmdlets require you perfect identity matches. In an AD of a global corporation, where you have tons of John, Sam, Doe, Smith, Martin, Schmidt , finding that information may be time consuming: is the name given a first […]
Since the initial times of Windows 2003, things have changed. Restoring AD objects, including DNS Zones become simpler with each release of Windows Server. Therefore let’s see how you can restore users, computers, organizational units and DNS zones nowadays. Restoring AD objects for standard classes Since Windows 2008 R2, Get-ADObject […]
In a previous post, I’ve put a snippet using powershell to be able to list domain controllers forest-wide. Here’s a variation if you have some legacy Powershell 2.0, etc. The algorithm takes advantage of the ADSI inteface and the AD Searcher object instead of relying on some built-in powershell cmdlets. […]
Today’s post is about answering a simple question I had to document a SQL Server instance. Is your database part of an Availability group? Or is it purely local to your instance? Microsoft has of course put some Dynamic Management Views (DMV) into SQL Server to list the databases in […]
The Powershell ISE may not be your favorite editor because of its limitations (long to start, has issues with high-consuming parallel workflows). However its snippets you can insert with the CTRL+J shortcut may be worthwhile to have a look at. One is particularly interesting: the powershell function header template. The […]
Some of the recommendations for better administering the logs of a SQL Server include adding more logs than the default value of 6 executing a periodic rotation at a given point in a time instead of relying of the system only Here are then a few snippets to perform […]
There are many cases when you need to search after some specific text into all the objects of a database: replacing references of a commercial product name by another moving an application from one environment to another, Unfortunately not all software developers provide you assistance in this field. There are […]
A good start point is the environment variables special powershell drive, aka Env:. However all folders are not available through this mechanism. You may want to build a hash table to retrieve them all and optionally add a drive to make your code nicer to read. The code is based […]
