page contents
Archive | SQLServerPedia Syndication RSS feed for this section

Video: AWS Fault Tolerance strategies

The information provided in this video is meant as a tutorial. It is not the final word on security or setup for your particular case. In Simpler terms: USE at your own risk. That said, I hope it helps. Loading the player …

Comments Off on Video: AWS Fault Tolerance strategies Continue Reading →

Video: Configuring EC2Config Service to Capture Event Viewer information for Windows 2003/2008. (Get System Log)

The information provided in this video is meant as a tutorial. It is not the final word on security or setup for your particular case. In Simpler terms: USE at your own risk. That said, I hope it helps. Loading the player …

Comments Off on Video: Configuring EC2Config Service to Capture Event Viewer information for Windows 2003/2008. (Get System Log) Continue Reading →

Different Ways to Find the Recovery Model for a SQL Server Database

Perhaps, the best thing about SQL Server and Microsoft products as a whole is that most of the tasks can be executed in more than one way. At times, it is might be useful to know about the various methods of performing a single task. Today, we will observe four different methods to find out […]

Comments Off on Different Ways to Find the Recovery Model for a SQL Server Database Continue Reading →

Video: Detaching root volumes for both versions of Windows 2008 to Windows 2008 to resolve EC2 connectivity issues. (Part 2 of 2)

The information provided in this video is meant as a tutorial. It is not the final word on security or setup for your particular case. In Simpler terms: USE at your own risk. That said, I hope it helps. Loading the player … Goals: To successfully detach and attach root drive to EC2 Windows 2008 […]

1 Comment Continue Reading →

Video: Detaching root volumes for both version of Windows 2008 to Windows 2003 to resolve EC2 connectivity issues. (Part 1 of 2)

The information provided in this video is meant as a tutorial. It is not the final word on security or setup for your particular case. In Simpler terms: USE at your own risk. That said, I hope it helps. Loading the player … Goals: To successfully detach and attach root drive to EC2 Windows 2003 […]

Comments Off on Video: Detaching root volumes for both version of Windows 2008 to Windows 2003 to resolve EC2 connectivity issues. (Part 1 of 2) Continue Reading →

Video: Keeping Volume Drive Letters the same with an EC2 Windows instance.

The information provided in this video is meant as a tutorial. It is not the final word on security or setup for your particular case. In Simpler terms: USE at your own risk. That said, I hope it helps. Loading the player …

Comments Off on Video: Keeping Volume Drive Letters the same with an EC2 Windows instance. Continue Reading →

Video: Manually Set Key Management Server for Windows Activation in EC2

The information provided in this video is meant as a tutorial. It is not the final word on security or setup for your particular case. In Simpler terms: USE at your own risk. That said, I hope it helps. Loading the player … Amazon KMS Server Information as of 26 JAN 2012 VPC (all regions, […]

Comments Off on Video: Manually Set Key Management Server for Windows Activation in EC2 Continue Reading →

Video: Remotely Reset Windows Password via EC2 Config service.

The information provided in this video is meant as a tutorial. It is not the final word on security or setup for your particular case. In Simpler terms: USE at your own risk. That said, I hope it helps. Loading the player …

4 Comments Continue Reading →

Video: Gathering helpful information to assist with Windows issues within EC2.

The information provided in this video is meant as a tutorial. It is not the final word on security or setup for your particular case. In Simpler terms: USE at your own risk. That said, I hope it helps. Loading the player … Tools needed: tracetcp: http://tracetcp.sourceforge.net/ wincap: http://www.winpcap.org/install/default.htm tcping: http://www.elifulkerson.com/projects/tcping.php Commands: ipconfig /all >C:\tools\tshoot.txt […]

1 Comment Continue Reading →

Video: Recovering EC2 Windows 2008/2008r2 instance due to Windows Firewall issues

The information provided in this video is meant as a tutorial. It is not the final word on security or setup for your particular case. In Simpler terms: USE at your own risk. That said, I hope it helps. Loading the player …

1 Comment Continue Reading →

EC2 Windows 2008/2008r2 loss of connectivity due to Windows Firewall

Happy New Year to everyone and I hope you had a great holiday! I have update this information in the form of a video, which can be found here. Today, I am going to talk about an issue where you might be connecting to a server remotely and all of a sudden you are no […]

1 Comment Continue Reading →

SQL Job Agent fails when Windows name change

Have you ever had a server that had a name change, but you also had a SQL server database on it and now all of your SQL jobs fail? Let’s say that your server used to be named IP-0A7653F2 and had SQL Server installed with some SQL jobs configured on it, but now it is called […]

Comments Off on SQL Job Agent fails when Windows name change Continue Reading →

PowerShell and TSQL code to list database information

Let’s say you want to get a list of all the tables in your database, along with their row counts and data space used. This would be really nice to know if you could not get it from SQL Server Management Studio. (SSMS) Well, today you are in luck, because I am going to show […]

Comments Off on PowerShell and TSQL code to list database information Continue Reading →

Be careful using sysprep with Windows 2008 r2 in a cloud environment

First off, this is an excellent post on the new changes with sysprep with Windows 7/Windows 2008r2: http://briandesmond.com/blog/how-to-sysprep-in-windows-server-2008-r2-and-windows-7/ I could not write it better myself, so if you need help with sysprep and all the new changes, please review Brain Desmond’s blog on it. Instead, I want to highlight a key point, when you are […]

1 Comment Continue Reading →

Have a need to port existing SQL Server Agent Jobs?

If you are like me, you have a few SQL Servers that you are managing and sometimes you write a cool job and say to yourself that would be awesome if I could take this job on Server A and allow Server B to run this job as well. Well, a good friend of mine (Jeremy Carter […]

Comments Off on Have a need to port existing SQL Server Agent Jobs? Continue Reading →
Copy Protected by Chetan's WP-Copyprotect.