page contents
Archive | SQLServerPedia Syndication RSS feed for this section

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 →

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 →

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 →

BEST PRACTICE: SQL Server 2005 to present: Instant Initialization for database files

This is a well-known and often mentioned best practice that I have recently found out that is not implemented much. I was even surprised to see that most installer packages to even include Microsoft’s SQL Server install do not set this feature up. Instant Initialization has been around since Windows XP and SQL Server has taken advantage of […]

Comments Off on BEST PRACTICE: SQL Server 2005 to present: Instant Initialization for database files Continue Reading →

SharePoint error when creating a new SSRS service application

Recently, I followed the steps in this TechNet article (Install Reporting Services SharePoint Mode as a Single Server Farm) to create a Reporting Services 2012 Service Application. However, when I try to create the SSRS service application, I get the following error: “The timer job completed, but failed on one or more machines in the farm.” […]

1 Comment Continue Reading →

Be careful with new licensing model with SQL Server 2012 and CPU’s!

I was upgrading a server recently from SQL Server 2008 R2 Enterprise Edition to the latest version with 2012. I got a surprise after the upgrade… I lost 12 CPU. I had a 32 Processor system ( HP DL580 4×8 server) as seen below: After the upgrade, I wanted to verify the CPU configuration and noticed […]

1 Comment Continue Reading →

HOW TO: Replace or Migrate Your Quorum Drive in Windows 2008 Cluster

Have you been in a position where you had to retire an external storage device like a SAN or DAS but you had your Quorum drive resource on it? Well, this post will walk you through the steps needed to swap out your drive. I was pleasantly surprised to see how much easier it is to […]

Comments Off on HOW TO: Replace or Migrate Your Quorum Drive in Windows 2008 Cluster Continue Reading →

HOW TO: Backup SQL Server 2008 with Compression

This is one of the many new features that I really enjoy with Microsoft SQL Server. Backup compression was introduced with SQL Server 2008 and in my opinion, it is a must tool for most SQL Database administrators. It is especially true when you experience disk space problems. In addition to saving space, it also […]

Comments Off on HOW TO: Backup SQL Server 2008 with Compression Continue Reading →

HOW TO FIX: SQL Server Express Evaluation Edition Expired and Property Owner is not available

In my last post, I talked about an issue where we had a rogue SharePoint 2010 server that had an issue with the file size of the Database. As noted in that post, I stated that I would do another article as follow-up to reflect the other 2 challenges that I ran into as well. […]

1 Comment Continue Reading →

HOW TO FIX: SQL Server Express DB size limitation of 4 GB

Today, I am going to go over 3 things that I encountered this week with SQL Server Express for a friend. At his job, they found a rogue SharePoint server that a developer had placed into production. Sadly, the only way my friend found about it was when the developer had run into an issue. […]

3 Comments Continue Reading →

HOW To FIX: Shadow (a.k.a. “ghosted”) NIC’s in Hyper-V or SCVMM 2008R2

In my last post, I talked about recovering from a failed Storage Migration (QSM) in SCVMM. After you attach the old VHD file, you may find that you are not able to add the NIC settings back, like the IP address because there is a hidden NIC that is in the system but does not […]

Comments Off on HOW To FIX: Shadow (a.k.a. “ghosted”) NIC’s in Hyper-V or SCVMM 2008R2 Continue Reading →

HOW TO FIX: Hyper-V or SCVMM 2008R2 Failed Storage Migration (QSM)

Happy Easter everyone! 🙂 Earlier this week, I was moving VM’s from one shared storage device to another. I had an old HP StorageWorks SAN device that was failing on me and was out of warranty, so I needed to migrate my VM storage to a new EMC device. I ran into some issues and it kind […]

4 Comments Continue Reading →

Last Known Good Backup/DBCC

Today, I was researching information on DBCC and database backups. I was trying to ensure that I have good data in my backup, as you know… garbage in leads to garbage out. Basically, your data is only good as the data you pull from Talking with Robert Davis (Blog | Twitter) he provided me with […]

1 Comment Continue Reading →

Evolution of T-SQL between SQL 2005 & 2008 versions

Ever wondered what has changed under the hood between versions of Microsoft SQL Server? Well, then this post is for you! What’s new in SQL 2008 Programmability Enhancements (Database Engine) What got deprecated in SQL 2008 Deprecated Database Engine Features in SQL Server 2008 What was discontinued in SQL 2008 Discontinued Database Engine Functionality in […]

Comments Off on Evolution of T-SQL between SQL 2005 & 2008 versions Continue Reading →

**UPDATE:** HOW TO: Move SQL Server transaction log files to a different location via TSQL and SSMS

This is to correct some information that I had put out there in this article. From reading books online, it appears that my information was intended only for SQL Server 2005 databases. Talking with Robert Davis (Blog | Twitter) at work, I was advised that my earlier article was in correct and sure enough when I […]

1 Comment Continue Reading →

HOW TO FIX: Clock Drift Automatically with Task Scheduler (Not joined to Domain)

In one of my earlier post I talked about fixing Clock drift for a virtual machine that is not joined to a domain. It is located here. The issue that I was running into was that my clock for some reason would get set back about a day and that would mess up my time […]

2 Comments Continue Reading →

Had an amazing time at SQL Saturday in Vancouver!

If you have never been to a SQL Saturday event, I highly suggest that you do! You can find an upcoming event here and following this event on twitter #sqlsat114  As stated earlier in one of my posts this SQL community is really one of the bright spots in the IT field. I was so happy […]

Comments Off on Had an amazing time at SQL Saturday in Vancouver! Continue Reading →

Fixed an issue *installing* SQL Server 2008r2

As you will remember, I had an issue trying to *remove* SQL Server 2008r2 as noted here. What I failed to tell you was what my REAL issue was… I could not successfully install SQL Server 2008r2 and I kept getting this error: So I used my tip again to remove the new installation that […]

Comments Off on Fixed an issue *installing* SQL Server 2008r2 Continue Reading →

Fixed an issue *removing* SQL Server 2008r2

I had an issue tonight where I was unable to remove Microsoft SQL Server 2008r2. The setup was just hanging at this step SqlEngineConfigAction_remove_validation_Cpu64. I first tried to remove it by Add/Remove Programs and then tried it by the command line: C:\Program Files\Microsoft SQL Server\100\Setup Bootstrap\SQLServer2008R2>setup.exe /ACTION=uninstall /FEATURES=SQL,AS,BOL,SSMS/INSTANCENAME=MSSQLSERVER Neither action would work and it was […]

1 Comment Continue Reading →

Had an amazing time at SQL Saturday in Redmond!

If you have never been to a SQL Saturday event, I highly suggest that you do! You can find an upcoming event here: http://sqlsaturday.com/ and https://twitter.com/#!/search/%23sqlsat108 As stated earlier in one of my posts (http://www.smattie.com/my-small-attempt-to-give-back-to-the-it-community/) this community is really one of the bright spots in the IT field. I was so happy to meet and talk with a […]

Comments Off on Had an amazing time at SQL Saturday in Redmond! Continue Reading →
Copy Protected by Chetan's WP-Copyprotect.