SQL Server

Pro Members SQL Server Standard Members

Introduction to Windows Azure SQL Database (Part 2)

Introduction to Windows Azure SQL Database Services (Part 2) Author: Basit A. Farooq Introduction In my last article "Introduction to Windows Azure SQL Database Services (Part 1)", I’ve provided an overview of Microsoft Windows Azure SQL database, which is a cloud-based relational database platform that is built on SQL Server technologies. We also learned about the steps on how to...

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.
Log In Register
Pro Members SQL Server Standard Members

Nob Hill Software Database Compare: A Data Developer’s Dream Tool For Comparison And Migration Of Databases

Nob Hill Software Database Compare: A Data Developer’s Dream Tool For Comparison And Migration Of Databases By: Stephen Wynkoop Introduction Database comparison and migration tools are evolving and now provide leverage and advanced guidance and feedback during the migration and testing process. Moving beyond a traditional copy-style migration tool can save time, money and frustration in managing your data infrastructure....

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.
Log In Register
Pro Members SQL Server Standard Members

Troubleshooting problems with joins in SQL Server 2008 R2

Troubleshooting problems with joins in SQL Server 2008 R2 If you have problems with joins 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 join bugs were fixed in SQL Server service packs, you should install the latest SQL Server...

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.
Log In Register
Pro Members SQL Server Standard Members

Columnar Databases and SQL Server Columnstore Indexes

Columnar Databases and SQL Server Columnstore Indexes Lately I have been working with Vertica – a column based database from HP and I have to admit that I am amazed by its capabilities and the functionalities it offers, especially when we are talking about relatively big data. The basic difference between SQL Server and Vertica is the way they store...

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.
Log In Register
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.
Log In Register
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.
Log In Register
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.
Log In Register
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.
Log In Register
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.
Log In Register
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.
Log In Register