Standard Members

Pro Members SharePoint Standard Members

Move SharePoint Farm Databases To New Database Server

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...

This content is for Pro, Pro Member, Pro Member Annual - Fall Sale, Pro Member Monthly - Fall Sale, Standard, Standard Member, Standard Member Annual - Fall Sale, and Standard Member Monthly - Fall Sale members only.
Register
Already a member? Log in here
Pro Members SQL Server 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...

This content is for Pro, Pro Member, Pro Member Annual - Fall Sale, Pro Member Monthly - Fall Sale, Standard, Standard Member, Standard Member Annual - Fall Sale, and Standard Member Monthly - Fall Sale members only.
Register
Already a member? Log in here
Pro Members SQL Server Standard Members

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...

This content is for Pro, Pro Member, Pro Member Annual - Fall Sale, Pro Member Monthly - Fall Sale, Standard, Standard Member, Standard Member Annual - Fall Sale, and Standard Member Monthly - Fall Sale members only.
Register
Already a member? Log in here
DB2 Pro Members Standard Members

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....

This content is for Pro, Pro Member, Pro Member Annual - Fall Sale, Pro Member Monthly - Fall Sale, Standard, Standard Member, Standard Member Annual - Fall Sale, and Standard Member Monthly - Fall Sale members only.
Register
Already a member? Log in here
Pro Members SQL Server Standard Members

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,...

This content is for Pro, Pro Member, Pro Member Annual - Fall Sale, Pro Member Monthly - Fall Sale, Standard, Standard Member, Standard Member Annual - Fall Sale, and Standard Member Monthly - Fall Sale members only.
Register
Already a member? Log in here
Pro Members SQL Server Standard Members

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...

This content is for Pro, Pro Member, Pro Member Annual - Fall Sale, Pro Member Monthly - Fall Sale, Standard, Standard Member, Standard Member Annual - Fall Sale, and Standard Member Monthly - Fall Sale members only.
Register
Already a member? Log in here
Pro Members SQL Server Standard Members

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...

This content is for Pro, Pro Member, Pro Member Annual - Fall Sale, Pro Member Monthly - Fall Sale, Standard, Standard Member, Standard Member Annual - Fall Sale, and Standard Member Monthly - Fall Sale members only.
Register
Already a member? Log in here
Pro Members SQL Server Standard Members

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...

This content is for Pro, Pro Member, Pro Member Annual - Fall Sale, Pro Member Monthly - Fall Sale, Standard, Standard Member, Standard Member Annual - Fall Sale, and Standard Member Monthly - Fall Sale members only.
Register
Already a member? Log in here
Pro Members SQL Server Standard Members

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....

This content is for Pro, Pro Member, Pro Member Annual - Fall Sale, Pro Member Monthly - Fall Sale, Standard, Standard Member, Standard Member Annual - Fall Sale, and Standard Member Monthly - Fall Sale members only.
Register
Already a member? Log in here
Pro Members SQL Server Standard Members

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...

This content is for Pro, Pro Member, Pro Member Annual - Fall Sale, Pro Member Monthly - Fall Sale, Standard, Standard Member, Standard Member Annual - Fall Sale, and Standard Member Monthly - Fall Sale members only.
Register
Already a member? Log in here