page contents
Archive | SQLServerPedia Syndication RSS feed for this section

Hyper-V limits with Windows Server 2012 Release Candidate

As stated in an early article of mine, there is a great free book from Microsoft Press that talks in good depth about Windows Server 2012. Today, I wanted to share some of the information that I learned from the book. (Limits and new features) Here is a simple comparison of the different limits between Windows Server 2008 R2, Windows Server 8 […]

Comments Off on Hyper-V limits with Windows Server 2012 Release Candidate Continue Reading →

SQL Server Maintenance Solution by Ola Hallengren

I have been meaning to talk about this topic for a while now and tonight I made sure that I put out the good news. Today, I want to introduce you to the SQL Server Maintenance Solution by Ola Hallengren which is a script that will create a series of scripts that will perform SQL agent jobs […]

1 Comment Continue Reading →

Announcing Better IOPS for Amazon EBS‏ Volumes‏

Provisioned IOPS are a new EBS volume type designed to deliver predictable, high performance for I/O intensive workloads, such as database applications, that rely on consistent and fast response times. One of the biggest complaints about Amazon Web Services has been disk performance. In order to get fast performance it has been necessary to use […]

Comments Off on Announcing Better IOPS for Amazon EBS‏ Volumes‏ Continue Reading →

Windows Server 2012 Release Dates

I got some great news for you and it is straight from a Microsoft’s blog Windows Server 2012 final release timing and that news is that they have provided release dates to Windows Server 2012. Release To Manufacturing (RTM): First week of August 2012 Release to General Public: 4 September 2012 These dates were also confirmed by another Microsoft […]

Comments Off on Windows Server 2012 Release Dates Continue Reading →

Free version of Hyper-V Server 2012: Game changer in the making

With Virtualization gaining more traction in all phases of business, competitors are getting better with their products. Most Virtualization vendors offer some sort of free Virtualization software today, that is capable of handling a small to medium load. With that being said, the free hypervisor space is a very important segment for IT pros getting […]

Comments Off on Free version of Hyper-V Server 2012: Game changer in the making Continue Reading →

Creating the Start Menu for Windows 8 or Server 2012

In my last post, I talked about finding the Start Menu in Windows Server 2012 (formerly code name Windows Server 8) since it was a very quick visual difference between previous versions of Windows. It takes some time adjusting to the new direction with the Metro UI, but it can be done. I highly recommend that you […]

3 Comments Continue Reading →

Finding The Start Menu In Windows Server 2012

UPDATE: Most people have been upset with the new Start Menu because of the inability to quickly logoff, shutdown or restart the system. This article will show you how to get around that by creating a PowerShell script to create tiles. As I stated in my last post, I am going to do a series […]

9 Comments Continue Reading →

Technet releases new Windows Server 2012 Jump Start video series

As I stated in an earlier post here, Windows 2012 Release candidate one was released on 31 May 2012. This product is focused on being designed with cloud computing in mind and a lot of features were built with that focus. This will not be an easy upgrade where you just slip in a disc and click […]

1 Comment Continue Reading →

HOW TO: Create a New Partition or Volume with SQL Server in mind

This article will show you how to create a new primary partition using Disk Management and Diskpart (preferred) in Windows from an empty unallocated partition or volume. This is in line with Disk Partition Alignment Best Practices for SQL Server article. Partition Alignment in Windows Operating Systems The way partition alignment works depends on the version of […]

Comments Off on HOW TO: Create a New Partition or Volume with SQL Server in mind Continue Reading →

HOW TO: Set The PowerShell Execution Policy

If you are having been using the new ability to manage servers remotely using command line tools, then I am sure you have been using PowerShell. If you are new to command line tools, then this may seem strange to you, but trust me, Microsoft has been doing a great job making it easier to […]

Comments Off on HOW TO: Set The PowerShell Execution Policy Continue Reading →

Hypervisor Backup Tools: New and Improved methods for virtual machines

You know, it is pretty amazing that over 50% of the servers in the world today are running as virtual machines. This means that they run on top of hypervisors like VMware’s vSphere, Microsoft’s Hyper-V, and Citrix’s XenServer. However, the need to protect data on those virtual machines or to recover individual files hasn’t changed […]

1 Comment Continue Reading →

New Free Ebooks (SQL and Windows 2012) from Microsoft Press!

Hey Everyone, I hope you all had a safe and wonderful 4th of July. As you may or may not be aware, Microsoft has released SQL Server 2012 and on 31 May 2012 released Windows Server 2012 (RC1) Release Candidate One (which should mean Release To Manufacturing or RTM should be soon) I highly encourage all […]

5 Comments Continue Reading →

Video: EC2 Autoscaling with ELB and RDS in Amazon Web Services’ VPC

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 … Notes to go along with the video: Add in html and apache […]

4 Comments Continue Reading →

DBCC CHECKDB A Further Explanation

In an earlier, post I talked about doing backups and also making sure they are being done with data that has been verified as healthy. We want to avoid the scenario of garbage in leads to garbage out. As stated in that earlier article: Robert Davis (Blog | Twitter) provided me with some good advice: You should […]

2 Comments Continue Reading →

HOW TO: Import CSV Data files into SQL Server

How many times have we had to perform an inventory of either our equipment or software assets and then get asked to import that information into a database of some sort? Recently a friend at work asked me for some assistance on creating such a database to inventory server hardware. Lucky for me they had most of the data fields input taken […]

1 Comment Continue Reading →

Video: EC2 Windows Command Line Tools installation

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 … This file contents from this video can be download here. This zip […]

Comments Off on Video: EC2 Windows Command Line Tools installation Continue Reading →

What is better to use Database Mirroring or Log Shipping for SQL Server?

Well, the answer to this question begins with every experienced DBA’s favorite answer… It depends… 🙂 A great place to start is with this MSDN article on Database Mirroring and Log Shipping (SQL Server). It is kind of like a questionnaire to determine what would be best and it explains this topic in fairly simple terms. Before I begin, I […]

1 Comment Continue Reading →

PowerShell Tip: BgPing – A High Performance Bulk Ping Utility

Last week, I was building out a 5 Node Windows 2008R2 cluster for use as a Hyper-V server.One of my nodes was giving me trouble. I was able to successfully install, configure and add it to the cluster, but when I started placing Virtual Machines it would lose access to the Cluster Shared Volumes. (CSV) After that loss to […]

1 Comment Continue Reading →

SQL Server’s Recovery Model Setting Based Upon Model (System) Database!

In my last article, I talked about COPY_Only backups and I very briefly mentioned Recovery Models for SQL Server. I will one do do a more detailed post when I find some time, but I did want to share this little tip with you about the impact the Model database can have on your databases. This […]

Comments Off on SQL Server’s Recovery Model Setting Based Upon Model (System) Database! Continue Reading →

Microsoft SQL Server Copy_Only Backups

One of the great books, I have read this year and have really enjoyed has been Rod Colledge’s (Blog | Twitter) SQL Server 2008 Administration in Action. I have really enjoyed this book and for being technical it was really well laid out, plus easy to follow. My copy has been thoroughly worn and marked up with notes. […]

2 Comments Continue Reading →
Copy Protected by Chetan's WP-Copyprotect.