The Multifunctioning DBA:

Database


October 24, 2012  9:36 PM

Haunted House



Posted by: Colin Smith
Database

This year I decided to go to a haunted house. I thought it would be a lot of fun and I was hoping that it would be scary as well.So I went to the 13th Floor here in Phoenix. This is supposed to be one of the better haunted houses in the country. I got some...

October 24, 2012  9:22 PM

PowerShell CName Reporting



Posted by: Colin Smith
Database

Recently my team started using CName records instead of server names for applications to connect to. This makes moving things around on backend much easier. So here is the script that I am using.   Snapin SqlServerCmdletSnapin100 Add-PSSnapin...


October 23, 2012  7:30 PM

Virtualization Issues



Posted by: Colin Smith
Database

We recently had our bits upgraded to the latest and since that we have had some issues with the product. We have run into issues where the SQL Server that has copies of your databases in a restoring state, have stopped grabbing the log backups and applying them. This is an issue as it has made me...


October 23, 2012  5:52 PM

PowerShell Table and Index DDL



Posted by: Colin Smith
Database

sqlscript-options $server = "Instance" $tables = "Table Name" connect-sql $server $db = $s.databases | where {$_.name -eq "EventManagement_Test"} $db.name foreach ($table in $tables) { $outdir = "C:\ddl\$server" if (!(Test-Path $outdir)) { New-Item -ItemType container $outdir } $tbl...


October 23, 2012  5:17 PM

New TV Purchased



Posted by: Colin Smith
Database

Last Month I Told you that I was looking at getting a new TV. Well I did it. I spent the money and I feel like I did not settle on anything that I wanted. I was able to get 65 inches, 3D, Edge Lit LED (full panel would have been nice) and the TV has many smart features. Here is what I purchased.


September 28, 2012  9:12 PM

New TV



Posted by: Colin Smith
Database

I am going to be purchasing a new TV but I just do not really know what to get. I am replacing a 65 inch Mitsubishi DLP tv and it is really a nice TV but I want to upgrade. My problem is that I want to have LED, 3D, Good contrast Ratio, Internet apps, and I would like it to be 65 inch or a bit...


September 28, 2012  5:05 PM

Poweshell and user input driven menu



Posted by: Colin Smith
Database

I needed to be able to display options to users and let them make simple choices..  to make a selection of what to do. I wrote the following in order to accommodate my needs. So I display a list of choices and the user makes a selection. After the selection is made the script calls the function...


September 27, 2012  6:18 PM

New Virtualization Bits



Posted by: Colin Smith
Database

So I got some new bits for the Virtualization beta that I have been working on and the changes that they made, are all to the CLI so no real GUI still. That would be ok but all the Powershell scripts that I had written no longer work since they interface directly with the CLI. So I had to make some...


September 26, 2012  10:35 PM

Chicago in May



Posted by: Colin Smith
Database

Like I said in my last post, I will be in Chicago in May for training. I am so excited about the training but also very excited to go to Chicago. My wife and I will be in town on a small vacation with our son, he will be about 18 months) for 5 days after the training. I am not sure what to do wile...


September 25, 2012  4:48 PM

Server 2012 Core



Posted by: Colin Smith
Database

I read an interesting post that I just thought I would have to talk about as well. So with the release of Window Server 2012 and SQL Server 2012, we can now install SQL Server on a Core version of the OS. In the article Jeremiah...


Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to: