Geeks With Blogs

Disclaimer: The views expressed on this blog are my own and do not necessarily reflect the views of my employer.

Creative Commons License

Check out my profile!

INETA Community Speakers Program

Follow enriquelima on Twitter
Locations of visitors to this page

Intentional Thinking Enrique Lima SQL Server
It seems another season of previews is upon us
The past couple of weeks have been packed with teasers and updates. But here they go. Visual Studio Update 3: Visual Studio 2013 and TFS 2013 Preview: SQL Server 2014 CTP1 : Windows Server 2012 R2 Preview: Windows 8.1 : ......

Posted On Wednesday, June 26, 2013 8:26 PM

Configuration of Hyper-V and creation of VMs
In continuing with the post that I started last week, this week I focus on how I used PowerShell to install Hyper-V on Windows 8 and then create all necessary items to continue the creation of the SharePoint lab running on Hyper-V on Windows 8. First thing, in all situations I started PowerShell as Administrator. And yes, many of this items can be done and worked on through the GUI. But, the point is how do I automate. Also, assumptions here are you have a licensed version of Windows 8, and your ......

Posted On Sunday, April 28, 2013 7:51 PM

Backup Tool for SQL Azure
For those that attended TechEd NA 2011 last week in Atlanta it should be no surprise that more and more companies are betting on the Azure platform, whether it is Windows Azure or SQL Azure. There have been developments, changes and improvements for every aspect of the Windows Azure platform in general. And with that tools from 3rd parties to enhance or extend the experience. That is the case when we look at SQL Azure Backup from Redgate. A way to simplify and sync your SQL Azure data to local SQL ......

Posted On Tuesday, May 24, 2011 11:14 AM

Great Find: Database Maintenance Guidance Document for SharePoint 2010 Products

Over the last couple of weeks I have been discussing with clients and peers the proper way of managing the database side of a SharePoint deployment.

Yesterday, Microsoft released the official version of that guidance.

You can get that here

Posted On Friday, May 6, 2011 8:55 AM

Creating a SharePoint Demo/Dev Lab using Hyper-V on Windows 8. The Overview.
In the last number of days, I have come across the release of the Microsoft Office Division Demo VMs. While a great asset, it is also quite large and it consumes a lot of resources, this being said as I have a Lenovo W530 with 32GB RAM, and 3 Hard Drives. The download is a 56GB set, then expanded it comes to 220GB. That is just the storage piece. Then in order to get all VMs running, it requires 42GB RAM … not quite what I wanted in the end, but still useful in a given situation. That brought me ......

Posted On Sunday, April 21, 2013 1:03 PM

Tidbits on Installing the SQL Server 2012 BI Tools for VS 2012
As I was installing the newly released tools, and catching up on updates for a new system, I ran into the following situation. When it came to going through the dialog screens to install the new tools, under Installation Type, it came down to two options. Perform a new installation of SQL Server 2012 was one, the other, Add features to an existing instance of SQL Server 2012. I decided to select to Add features (why? well, instinct I guess). And I went forward with that choice through the rest of ......

Posted On Tuesday, April 2, 2013 8:47 AM

The Red Gate Guide to SQL Server Backup and Restore Book Review.
Earlier this summer I was reading the SQL Backup and Restore book by Shawn McGehee published by Simple Talk Publishing. There were many things that caught my interest and how this book was different from other books I have seen on the topic. One of the first things is the author did not shy away from explaining recovery models and their impact or effect on the backup strategy. Knowing Red Gate has a tool for Backup and Restore, I was expecting this to be central to the writer’s story. Yet, it wasn’t! ......

Posted On Saturday, August 18, 2012 5:36 PM

Events and Presentations
There is a number of things going on this coming weekend, so this maybe pushing it … yet good to put it out there. June 2nd (tomorrow), presenting at SharePoint Saturday St. Louis. The topic is SQL Server Health in a SharePoint environment. http://www.sharepointsaturd... I will be presenting the same topic at a joint session of the PASS group and SharePoint User Group in Evansville on July 17, 2012. http://evansville.sharepoin... ......

Posted On Friday, June 1, 2012 9:37 AM

Presentation on SQL Server Health in a SharePoint environment
Sql Health in a SharePoint environment View more presentations from Enrique Lima ......

Posted On Sunday, April 22, 2012 10:34 PM

Virtualization of SQL Server on VMware platform
We have gotten the chance to see Microsoft’s recommendations on how to go about providing a reliable virtualization platform to support SQL Server in a Hyper-V environment. While that defines an “ideal” scenario, not all deployments for a virtualized platform happen on Hyper-V, there is a large number of deployments taking place on the VMware platform. And a recent post from Jonathan Kehayias on is a great summary of the resources available for making a great implementation possible. ......

Posted On Tuesday, November 23, 2010 6:49 PM

SQL Server Denali CTP1

SQL Server Denali CTP1 was recently announced.  What are you doing to prepare for it and check the new features?

Here is the link to the Microsoft site:

Posted On Thursday, November 18, 2010 6:52 PM

Source Control from red gate software summary review
I have used Source Control since the first release, and even then it was a great option for bringing source control for the DB. Well a great tool just got better and better rounded in the process. Again, the integration with multiple repositories like SVN or in my case TFS is great. What makes it even better is the near zero interaction a DBA would have to have with Visual Studio in order to drive the solution from managing a few stored procedures or tables to driving a database change management ......

Posted On Sunday, April 22, 2012 10:27 PM

Database Development and Source Control
I have been working with Database Development and the aspects that come with it, the pain and the joy of moving from Dev to QA and then on to Production. Source Control has a place in Dev, and that is where the baselines should be established. Where am I going with this? I have been working with Redgate’s Source Control 3.0, and I am seeing some features that are great for the process of moving from Dev to … well something that allows for quite a level of control. We are not only talking about scripting ......

Posted On Thursday, April 5, 2012 7:38 AM

SQL Server “Denali” CTP3 download availability
SQL Server “Denali” CTP3 has become available for download and testing. Here is where you go for it: And when you get there this is what the site looks like. Once there, click on the Download CTP3 link. This will take you to another screen. Select Language and version, this will take you a sign in with your Live ID, and then you will get to the following screen … Pay close attention to the banner in red: The Akamai download manager will ......

Posted On Tuesday, July 12, 2011 10:14 PM

Installing the AdventureWorks OLAP Sample Database
Once the installer for the AdventureWorks Community Sample Database has finished, we then need to complete the process (not mandatory, but nice to do to play with the OLAP content). The first thing we need to do is make sure we note the location of the script files and samples. The path if you are working with SQL Server 2008 R2 is as follows: “C:\Program Files\Microsoft SQL Server\100\Tools\Samples\Ad... 2008R2 Analysis Services Project\enterprise” I am working with the developer edition, ......

Posted On Saturday, October 29, 2011 8:33 AM

Installing the AdventureWorks Community Sample Database content
For a while now, if we have been around SQL Server we got used to the different sample databases that were provided. From Pubs to Northwind to AdventureWorks. In order to get the AdventureWorks samples we need to go to CodePlex and download the one that corresponds to the version of SQL Server we are working with. The link to the download site here : Now, on to the installation. Once you download the appropriate file, double click and launch ......

Posted On Saturday, October 29, 2011 8:08 AM

SQL Server “Denali” Virtual Labs
The SQL Server team or group of teams responsible for the learning content has done a fantastic job continually of providing great ways to work with their content. This time it is through the Virtual Labs made available to ramp on Denali. How to get it? Go to the Learning Center’s Virtual Lab Link. ......

Posted On Sunday, October 9, 2011 10:00 PM

Getting to know the SQL Server Learning Center
In exploring the SQL Server site at, I came across the Learning Center option. It is a wealth of information to become familiar with the features and capabilities of the platform. It has as I mentioned, a wealth of information. Available for versions 2008 R2, 2008 and 2005. Go check it out here: A sample clipping of what the site displays: ......

Posted On Tuesday, July 12, 2011 10:21 PM

SQL Server 2008 Service Pack 2
On Sept 29th, Microsoft made SQL Server 2008 SP2 available for download. Here are the KB article with a description of the fixes and the links to download SP2. KB 2285068 : List of the bugs that are fixed in SQL Server 2008 Service Pack 2. SQL Server 2008 SP2 SQL Server 2008 SP2 Express SQL Server 2008 SP2 Feature Packs SQL Server 2008 SP2 SSRS Add-in for Microsoft SharePoint Technologies SQL Server 2008 SP2 Upgrade Advisor ......

Posted On Saturday, October 2, 2010 7:47 AM

Developer Training Kits
Microsoft has released a number of training kits that have hands-on labs, articles, presentations and loads of information. The have become available for a range of products. They have also been updating them as more features or service packs come out. The links to them are listed below: Visual Studio 2010 and .NET 4 Training Kit Windows Azure Training Kit SQL Server 2008 R2 for Developers ......

Posted On Tuesday, July 12, 2011 8:00 AM

SQL Azure Backups: The options
One of the things that I have really enjoyed in the process of working with SQL Azure is the SQL Azure Management options. Mind you, it does not have a built-in backup tool, yes there are other options. redgate SQL Azure Backup Currently, Red Gate has a SQL Azure Backup tool (since it is Beta, it is free for the time being). Obviously, in order to use the tool the network/ip address from which you will be connecting has to be enrolled into the Azure Firewall for your account. The first step … connect. ......

Posted On Sunday, July 3, 2011 9:09 AM

Dealing with SQL Server renames and moves
Hopefully you don’t deal with this often. But if it does happen. A couple of things to keep in mind. The steps to 1) rename a server 2) potentially needing to transfer logins. Mind you my reference and examples here are for Stand-alone Instances. There are at least 2 options for each. The ones that paid off for me are: Renaming sp_dropserver <old_name> GO sp_addserver <new_name>, local GO Followed by a: Select @@SERVERNAME Reference from: ......

Posted On Wednesday, June 8, 2011 9:41 PM

Great Find: Analysis Services Operations Guide

A great guide that will give you information on how to test, monitor, capacity plan, and troubleshoot Microsoft SQL Server Analysis Services OLAP solutions.

Get it here ...

Posted On Friday, June 3, 2011 9:01 PM

What do you use for Database Source Control?
I have found myself using more and more of the tools Red Gate software makes. They have proven (to me) to be effective and to the point. This time I am talking about SQL Source Control. Simple to use, simple to add a database to be under Change Control, which really is the goal. Don’t take me wrong, Visual Studio is a great tool, yet it is a developer’s tool. As a DBA or Database Developer (referring to an individual who codes T-SQL) we want to launch SQL Server Management Studio and be able to control ......

Posted On Monday, May 2, 2011 9:07 PM

A bit about backups and tools: Virtual Restore
Over the last months, I have been putting a considerable level of effort recovering databases. That would be databases in dev, staging and prod. Somewhere, somehow someone got access to Prod and decided to mess with it. All in all this has created some heartburn and so on. Again, not only from the downtime it has caused and the lengthy recovery process. We figured we could use interim solutions that would become active only when we knew a transition period had arrived, while effective, the changes ......

Posted On Monday, April 25, 2011 10:16 AM

SQL Server MCM Changes and Readiness Videos
Towards the end of 2010, Microsoft made some changes to the Microsoft Certified Master for SQL Server 2008 program. The process to certification required to have a 3 week bootcamp/course in Redmond. This has changed now. It has been mapped to 2 exams. Get information from Microsoft Learning with regards to the changes, process, resources and pricing for the certification exams. What has happened here too, is some SQL MCM rotation ......

Posted On Sunday, March 6, 2011 8:43 AM

Installing SQL Server Denali CTP
In keeping up with the releases this fall, I have gone through the exercise of installing Denali CTP on my Windows 7 dev machine. Started by running the installation center Selected a New SQL Server Installation Went through the installation of support rules and files. Selected the edition. Accepted the License Agreement. Installed Support Files. Reviewed Support Rules. Selected SQL Server Feature Installation Selected the needed features. Reviewed results from Validation Rules Accepted defaults ......

Posted On Wednesday, December 1, 2010 10:11 PM

Visual Studio tips for SharePoint Admins
A while back it was clear: Roses are red, violets are blue … if you are a dev you use Visual Studio. Now: Roses are blue, violets can be red … if you do SharePoint,Visual Studio is the right tool for you. I am not a poet, nor do I pretend to be one on TV. But I have invested time in fine tuning virtual machines and physical deployments in figuring out what goes where and what is needed. We see dependencies of every type, in every place and every product pretty much. If you are doing SQL Server 2008 ......

Posted On Sunday, July 18, 2010 1:42 PM

What is the SQL Server Utility?
When we look at how our database deployments are happening, we identify an ever growing number of servers and instances all servicing important services or why not? Custom applications. What is it? It is a combination of elements, those elements will allow for us as administrators interested in keeping a view of the health of the environment to connect to the system and check resource utilization. The elements that come into play are: Utility Control Point Health Policies Utility Explorer Each one ......

Posted On Monday, July 12, 2010 9:36 PM

SQL Server Master Data Services
In the need to establish a golden baseline of data elements that need to be centrally managed, we find Master Data Services. In order to understand this better and at the same time take advantage of a free offer from Microsoft Learning, check the following out: A free eClinic going over Master Data Services ......

Posted On Monday, July 5, 2010 8:08 AM

What am I reading?
My reading focuses very much around the technologies I work with. During TechEd 2010 North America I found some very good reads that are helping me prep for the new things out and also to establish recommended practices in their implementation. Here are the titles. It looks like a spot for Wrox, but they have hit hard and early with great content, and some friends happen to have participated in their creation ......

Posted On Sunday, June 20, 2010 4:13 PM

SQL Server 2008 R2 Best Practices Analyzer available for download
SQL Server 2008 R2 Best Practices Analyzer is a diagnostic tool that gathers information about the server and the SQL Server instances installed (2008 and 2008 R2). It checks for configuration settings following recommended best practices and reports on configuration settings that deviate from those recommendations. Download: ......

Posted On Sunday, June 20, 2010 4:01 PM

SQL Server Connectivity Portal

We all love one stop portals :-)

Browsing around MSDN I came across this for connectivity, yes, a one stop portal, find info on connecting using a variety of technologies and good guides.

Posted On Saturday, May 29, 2010 3:36 AM

Cumulative Update Package 1 for SQL Server 2008 R2
From the KB Article ID: 981355 “Cumulative Update 1 for Microsoft SQL Server 2008 R2 RTM contains only hotfixes that were released in Cumulative Update 5, 6, and 7 for SQL Server 2008 Service Pack 1 (SP1). Cumulative Update 1 for SQL 2008 R2 RTM is only intended as a post-RTM rollup for Cumulative Update 5-7 for the release version of SQL Server 2008 SP1 customers who plan to upgrade to SQL Server 2008 R2 and still keep the hotfixes from Cumulative Update 5-7 for the release version of SQL Server ......

Posted On Wednesday, May 19, 2010 12:02 AM

Configuring SQL Server Management Studio to use Windows Integrated Authentication … from non-domain systems
Did you know you can pass your Windows credentials to SQL Server even when working from a workstation that is not joined to a domain? Here is how … From Start, then click All Programs, find Microsoft SQL Server (version 2005 or 2008). Once there, do a right-click on SQL Server Management Studio, then click on Properties Now, follow below to modify the entry for Target: Now the real task (we will be using the runas command) … Modify the shortcut’s target as follows, and remember to replace <domain\user> ......

Posted On Tuesday, May 18, 2010 3:17 PM

A great option for those of us who live by virtual environments, SQL Server 2008 R2 sysprep
For a long time when creating images for my development environment, I had to install the OS and then sysprep. Only after that would I then create a differencing drive/image that would have SQL Server. So, the thought of having a base/core image for SQL Server as a template was not easily done. Well, how do things change? SQL Server 2008 R2 gives us the option now. Check this HOW TO provided on the library docs at TechNet. ......

Posted On Sunday, May 16, 2010 7:48 AM

Copyright © Enrique Lima | Powered by: