Thunderbolt to Ethernet adapter for Windows 7 or Windows 8

Hi all Mac-users,

I’ve been strugeling to get my Thunderbolt-to-Ethernet adapter working on Windows 8 and finally got it working!
It’s a bit tricky since the adapter is not ‘hot-pluggable’, so you’ll need to make sure to put it in before you boot your laptop!

First step is to download the driver for your adapter (made by Broadcom), click here.

Broadcom suggests to ‘Determining the Correct Driver for Broadcom Ethernet Products‘.
My details:

According to Broadcom: ‘Where: 14E4 identifies the controller as a Broadcom device. DEV_XXXX is the device ID.’

Mine is showing 1682…which is not listed here:

The funny thing is that according to Google/Forum-posts, they recommended me to use the ‘NetXtreme I Desktop/Mobile’-driver. So that’s what I did, I downloaded the driver for ‘Windows 7 (x64)‘.

Unpack the ZIP-file and open Device Manager, your ‘Network Adapter’ should be visible with a warning-sign (remember it is not ‘hot-pluggable’, so it needs to be put in before you startup).
Update the driver and select the broadcom drivers.
In the list of devices, select his one: ‘Broadcom NetXtreme Gigabit Ethernet‘ and…Next…Next…Finish.

If it is not working directly, try a restart.


SQL Server Backup, Integrity Check, and Index and Statistics Maintenance

SQL Server Maintenance Solution

I know that some of you are using this T-SQL based toolkit to perform maintenance on your servers, but is this a toolkit we should need to use? Why not use a fancy PowerShell script, create a basic Maintenance Plan in SSMS/SSDT or by CMD perhaps?
Well let me drop the link, let me know who’s using it or what you think?

http://ola.hallengren.com/

The SQL Server Maintenance Solution comprises scripts for running backups, integrity checks, and index and statistics maintenance on all editions of Microsoft SQL Server 2005, SQL Server 2008, SQL Server 2008 R2, and SQL Server 2012. The solution is based on stored procedures, functions, the sqlcmd utility, and SQL Server Agent jobs. I designed the solution for the most mission-critical enterprise environments, and it is used in manyorganizations around the world. Numerous SQL Server community experts recommend the SQL Server Maintenance Solution, which has been a Gold and Silver winner in the 2011 and 2010 SQL Server Magazine Awards. The SQL Server Maintenance Solution is free.

The best starting point for building your own maintenance plan is the comprehensive and free script from Ola Hallengren. That’s what I recommend to my clients.

Use PowerShell to script all database objects

Last week I started working with PowerShell for the first time.
My goal was to create a script that would somehow script all indexes (CREATE-statements) in specified databases.

When I was done Google-ing for all kind of solutions, I combined all sorts of existing PowerShell scripts. The resuls was a single PowerShell script that simply scripts all database objects within the specified database (like the ‘Generate Scripts‘-option does in SSMS/SSDT)!

Modify the script to adjust a few settings!
In the header section, you may want to change the destination folder for the output scripts. Look for:
$SavePath = "C:\PowerShell\SQLScripts\" + $($dbname) + "\" + $DateFolder

Another things is that you’ll need to define which databases on which server needs to be scripted in the bottom section of the PowerShell script:

#Execute function for all PM's user databases:

Script-DBObjectsIntoFolders '.' 'AdventureWorks2012'
Script-DBObjectsIntoFolders 'localhost' 'AdventureWorks2012'
Script-DBObjectsIntoFolders 'servername\instancename' 'AdventureWorks2012'

How to execute?:
Execute this statement in Command (CMD) or via a SQL Agent Job (PowerShell step):

PowerShell "C:\PowerShell\ScriptAllObjectsInDatabase.PS1"

sql-agent-powershell-step-script-all-objects

The Result?:
It creates a new folder every time it is executed, the name of the folder will be a timestamp.

Schedule the thing!

I used the command (CMD) steptype of SQL Agent, because I simply didn’t got it working as a PowerShell steptype:

Download the PowerShell script here: ScriptAllObjectsInDatabase
Don’t forget to save it as ‘ScriptAllObjectsInDatabase.PS1‘!

*** UPDATE ***
In case you would also like to script XML Indexes, add these code-lines to the script on the right locations:

$scriptr.Options.XmlIndexes = $True
...
$scriptDrop.Options.XmlIndexes = $True