Tag: SQL Server
-
Project Nami an Open Source WordPress for Azure SQL and SQL Server
If you’re like me and think Not Another MySQL Install, when you go to setup WordPress… then look no further. A couple months back (I know I’m late, I’m sorry!!) I got to drive out to Alabama and talk with the minds behind Project Nami. We covered everything from deploying your blog, migrating your current…
-
How To Move or Migrate SQL Server Workload to Azure SQL Database Cloud Services or Azure VM – All version of SQL Server – Step-By-Step
There are many options for migrating SQL databases to Azure. With the latest technology you can move just the database and log files, or you can move the entire system. You could move to Azure SQL Database or you could migrate to a VM running SQL Server. The methods that you chose to move will…
-
How To Move or Migrate SQL Server Workload to Azure Cloud Services – All version of SQL Server – Step-By-Step
There are many options for migrating SQL databases to Azure. With the latest technology you can move just the database and log files, or you can move the entire system. You could move to Azure SQL Database or you could migrate to a VM running SQL Server. The methods that you chose to move will…
-
How to Fix Login Failed for User (Microsoft SQL Server, Error: 18456) Step-By-Step – Add SQL Administrator to SQL Management Studio
In this post (and video), I will teach you how to determine what user has administrative rights on the server as well as walk you Step-By-Step how to configure SQL Server to allow other users to login as Administrators to SQL Server. The generic message “Login Failed for User (Microsoft SQL Server, Error: 18456)” means…
-
Deploy SQL Server 2014 VM on Azure Cloud and Configure with Adventure Works DB–Step-By-Step
Part 1: Creating SQL Server Virtual Machine on Windows Azure (using the new portal) Step-By-Step 1. Login to Windows Azure Portal 2. Click New in the lower left corner 3. Click SQL Se3rver 2014 Standard 4. Enter Host Name, User Name, Password (Host Name must be unique system wide, username cannot be “admin” password…
-
FREE Hands-on “Virtual Study Halls” with Live Expert Q&A
NEW HOURS! Based on popular demand, we’ve updated the hours for “Early Experts” Virtual Study Hall assistance – Fridays each week from 11AM to 1PM Eastern Time. – – – – – – – – – – There’s so many cool features to explore in the latest Windows infrastructure offerings that it’s hard to find…
-
Using Your Own SQL Server in Windows Azure Step-By-Step (Part 22 of 31) by Blain Barton
The 22nd edition of 31 Days of Server (VMs) in the Cloud is now live at Part 22 of 31 – Using your own SQL Server in Windows Azure – 31 Days of IaaS In this edition, Blain Barton explains Step-By-Step how you can create a new VM and learn how to install SQL Server.…
-
Windows Server 2012 Hyper-V Guest Delivers Incredible Performance 985k IOPS
Jeff Woosley shows us how a Hyper-V guest performs. Do you have a workload that can pull this many IOPS? I sure wish I had this demo environment Anyone want to donate some hardware? This performance is only limited by hardware. Throw more hardware or faster hardware at it for even better performance. Yes, this could…
-
Free Technology Training from TechEd NA 2012 Available NOW
TechNet 2012 – North America has wrapped and what a great show it was. I was able to attend but had to work so I did not get the opportunity to sit in on many sessions. However, now I am going to make the opportunity to sit in on the sessions. How can I do…
-
Edit Using Excel 2010-Add, edit, find, and delete rows by using a data form
When a row of data in a worksheet is very wide and requires repeated horizontal scrolling, consider using a data form to add, edit, find, and delete rows. Learn about data forms A data form provides a convenient means to enter or display one complete row of information in a range or table without scrolling…
-
Event VDX Drive Down Data Center Costs With Hyper-V And System Center Management–Resources Posted
VDX Drive Down Data Center Costs With Hyper-V And System Center Management High quality, high availability, simple to use and full virtual and physical management at a fraction of the cost of the alternatives. That is what you get with Hyper-V and System Center. In this session, we will look inside Microsoft’s flagship virtualization platform,…
-
Installing System Center Virtual Machine Manager (SCVMM) 2008 R2 SP1
I am walking through the installation of SCVMM 2008 R2 SP1 on a new server that I just setup in my demo environment. Hope this is helpful. First lets look at the system requirements. If you want to setup your environment with multiple servers or you want to do a custom install you can find…
-
How to build a FREE Private Cloud using Microsoft Technologies
Chris Avis is a friend and colleague. He created a pretty detailed blog post on how to create a private cloud. I was planning on writing a similar post but found this one and decided to link to his. I hope you find his post helpful. He goes through …
-
SCOM Part 6 Bonus Opening Firewall port for SCOM DB Server (SQL Server)-Managing and Monitoring SharePoint 2010 using System Center Operations Manager 2007 R2
Managing and Monitoring SharePoint 2010 using System Center Operations Manager 2007 R2 Part (6) BONUS of 5+
-
Everything You Could Ever Want to Know About SQL Azure-Get Smart On SQL Azure Here
Recently a great series of 15 introductory videos have been completed and made available up on Microsoft Showcase, all focusing on SQL Azure. Here are the episodes: Getting Started: SQL Azure at a Glance Getting Started: Basic Architectural Considerations with SQL Azure Getting Started: Creating an Account and Your SQL Azure Database Getting Started: Interacting…
-
System Center Operations Manager (SCOM) Best Practices Poster Rule and Monitor Targeting
You can download the PDF from go.microsoft.com/fwlink/?LinkId=125048. The poster will help you understand the process and best practices for setting up rules and targeting. System Center Operations Manager (SCOM) Best Practices Targeting All Managed Computers EXAMPLE: You want to monitor failed logon attempts on Windows Computers DO • Use Windows Operating System to target all…
-
How to Solve Connectivity Issues Connecting To SCOM, SCVMM, AD or Any Other Service–Here is the Easy fix
I have been in the technology industry for more than 25 years now and I have dealt with my fair share of connectivity issues. In the last decade or so a good 85% or more of the issues I have encountered have been DNS issues. There is a very easy solution to fix the problem…
-
DPM eLearning is now online – How to Backup SharePoint, SQL Server, Exchange Server and Virtulized Environments (Hyper-V), Including Disaster Recovery
Announcing DPM eLearning is now online This week, I am very happy to announce the availability of eLearning for DPM 2007. This is a collection of 6 two-hour eLearning modules that include hands-on labs, much of the same courseware as our newly announced classroom-based DPM course, and is built for to prepare you for the…
-
Where To Download ISO Images For The Latest And Past Versions Of Microsoft Software Including SQL Server 2000 x64
I had a customer ask me today if it was possible to download SQL Server 2000 x64. I am posting here so others can benefit from the answer. If you have an MSDN or Technet subscription you can download the ISO image of the CD/DVD’s. If you do not have either of these, you can…