Move SharePoint Farm Databases To New Database Server Many times it’s required to change the database server for a SharePoint farm from one DB server to other DB server. The reason for changing database server can vary for different scenario but below two reasons are pretty common: · Need a hardware upgrade for database server so willing to use a...
Standard Members
Troubleshooting problems with log shipping in SQL Server 2008 R2
Troubleshooting problems with log shipping in SQL Server 2008 R2 If you have problems with log shipping in SQL Server 2008 R2, review this troubleshooting checklist to find potential solutions. 1. Install the latest SQL Server 2008 R2 service pack. Because many SQL Server 2008 R2 log shipping bugs were fixed in SQL Server service packs, you should install the...
How to start SQL Server without a MASTER database
Issue SQL Server depends on the MASTER and RESOURCE databases for critical information required to start the instance. Without these databases your SQL SERVER will not start. We recently had an outage where everything on the RAID-5 disk drive array containing the SQL Server system (master, resource, model and MSDB) and USER databases was lost due to hardware failure. After...
Using Nulls in DB2
Using Nulls in DB2 By Craig S. Mullins A null represents missing or unknown information at the column level. If a column “value” can be null, it can mean one of two things: the attribute is not applicable for certain occurrences of the entity, or the attribute applies to all entity occurrences, but the information may not always be known....
Configuring Database Level Encryption on SQL Server instance
Transparent Data Encryption (TDE) with Database Mirroring Author: Basit A. Farooq Introduction Database security is essential for the organisations working in healthcare and financial sector because the databases in such organisations contain sensitive and confidential information about their customers. The organisation working in such sectors also falls under the boundaries of data regulatory and compliance requirements (such as HIPAA, PCI-DSS,...
Troubleshooting problems with linked servers in SQL Server 2008 R2
Troubleshooting problems with linked servers in SQL Server 2008 R2 If you have problems with linked servers in SQL Server 2008 R2, review this troubleshooting checklist to find potential solutions. 1. Install the latest SQL Server 2008 R2 service pack. Because many SQL Server 2008 R2 linked server bugs were fixed in SQL Server service packs, you should install the...
How to Manage Without Micromanaging (Part 3)
How to manage without micromanaging Part 3 Influencing different roles to see eye to eye Professional development series This is Laura Lee Rose, instructor for the OnLine Coaching Series on SSWUG and I am a business and life coach that specializes in professional development, time management, project management and work-life balance strategies. In an interview with Stephen Wynkoop on SWWUG...
Introduction to Windows Azure SQL Database (Part 1)
Introduction to Windows Azure SQL Database Services (Part 1) Windows Azure SQL Database also known as SQL Server Data Services or simply SQL Azure is a Microsoft’s cloud services that offers a transactional and relational data-storage capabilities on Microsoft SQL Server 2012 (such as Amazon S3 and Amazon Relational Database Services), as part of the Azure Services Platform. Windows Azure...
Troubleshooting problems with SQL Server 2008 R2 jobs
Troubleshooting problems with SQL Server 2008 R2 jobs If you have problems with SQL Server 2008 R2 jobs, review this troubleshooting checklist to find potential solutions. 1. Install the latest SQL Server 2008 R2 service pack. Because many SQL Server 2008 R2 job bugs were fixed in SQL Server service packs, you should install the latest SQL Server service pack....
Building a Database Systems Bookshelf
Building a Database Systems Bookshelf By Craig Mullins Achieving success working with a database system can be a difficult task. In order to prosper you must have an inquisitive mind and an on-going desire to learn. In this day-and-age of frugality and meager training budgets, much of your education will be self-taught. One of the most cost-effective ways to learn...