page contents
Tag Archives: 2008

Set the Command line properties (i.e. Quick Edit) with PowerShell

If you are like me, you get annoyed at having to do the same thing over and over… especially, if it is tedious and goes on for hours, I am sorry, but I get bored very easily in that situation. One thing I get to do a lot on a daily basis is log into many different […]

Comments Off on Set the Command line properties (i.e. Quick Edit) with PowerShell Continue Reading →

HOW TO: Use the Database Engine Tuning Advisor in Microsoft SQL Server

Before we begin, I want to provide a little background on this tool. Database Engine Tuning Advisor (DTA) is a component of SQL Server Management Studio, which is an integral part of Microsoft SQL Server, the database management application. This tool is used for improving query performances by examining the way queries are processed and […]

Comments Off on HOW TO: Use the Database Engine Tuning Advisor in Microsoft SQL Server Continue Reading →

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 →

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 →

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 →

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 →

SQL Server Max Memory calculator from Microsoft is *not* intended for Database professionals…. really?

In an earlier article, I wrote about a few new tools for SQL Admins that were released by Microsoft. As I have done in the past I will correct myself to ensure that I am passing along helpful information. This article is another example and I would like to explain my thoughts. When I wrote that […]

1 Comment Continue Reading →

SSD- What’s the difference between SLC and MLC?

It’s time dissect the two main types of flash chips in order to understand why not all SSDs are created equal. What is after all the physical difference between SLC and MLC? SLC stands for Single Level Cell and just like the name suggests can store one bit per NAND gate hence SLC cell has […]

Comments Off on SSD- What’s the difference between SLC and MLC? Continue Reading →

New Microsoft SQL Servers tools released

Within the past 2 months, there has been a couple of key tools introduced for SQL Server. Recently on 20 April 2012, Microsoft released the Reporting Services Migration Tool and on 18 May 2012, they released Max. Server Memory calculator. The Reporting Services Migration Tool (Beta) was mentioned here. I do want to point out that the source […]

3 Comments Continue Reading →

Program and Erase Cycle (P/E)- SSD Technology

In my earlier post, I talked about SSD drives and how they can use an algorithm called Static Data rotation to help prevent premature wear on the drive. Today, I am going to briefly cover the write operations of SSD/Flash Memory. One of the limitations of flash memory (Which preceded SSD technology) is that while it can be read […]

Comments Off on Program and Erase Cycle (P/E)- SSD Technology Continue Reading →

Static Data Rotation- SSD Technology to look for in Enterprise products

For many years, RAM and Disk was and still is today, the main culprit for bottlenecks in performance. With the lower cost of Memory, the shift has fallen more on disks to be the slow point in systems. Large Enterprise companies would have numerous external storage devices to get around this issue. (SAN, DAS, NAS, […]

1 Comment Continue Reading →

HOW TO: Add Many NIC configuration settings with PowerShell

In yesterday’s post, I talk about using PowerShell to configure many NIC’s with NETSH. Today, I am going to cover doing it with PowerShell and make it simple where it will prompt for the information in a GUI. So first off, you will need to ensure that you have Executaion Policy changed to allow for […]

Comments Off on HOW TO: Add Many NIC configuration settings with PowerShell Continue Reading →
Copy Protected by Chetan's WP-Copyprotect.