Pro Members

Pro Members SQL Server Standard Members

Tips for using SQL Server 2008 R2 database settings

Tips for using SQL Server 2008 R2 database settings To change the database settings, you can use the sp_dboption system stored procedure or you can use the graphical user interface (GUI). To change the database settings using GUI, you can do the following: – In Object Explorer, connect to an instance of the SQL Server Database Engine, and then expand…...

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

7 Tricks to Attending a Conference on Someone Else’s Dime

7 Tricks to Attending a Conference on Someone Else’s Dime Professional Development Series by Laura Lee Rose Hello, this is Laura Lee Rose – Corporate Exit Strategist for the Blooming Entrepreneur – and I am a business and life coach that specializes in time management, project management and work-life balance strategies. As a success and business coach, I encourage continuous…...

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 SQL Server 2008 R2 Merge Replication

Troubleshooting problems with SQL Server 2008 R2 Merge Replication If you have problems with SQL Server 2008 R2 merge replication, review this troubleshooting checklist to find potential solutions. 1. Check that you use the latest SQL Server 2008 R2 service pack. Because many SQL Server 2008 R2 merge replication bugs were fixed in SQL Server service packs, you should install…...

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
DB2 Pro Members Standard Members

zData Perspectives – A Short History of DB2 for z/OS

zData Perspectives A Short History of DB2 for z/OS by Craig S. Mullins Let’s go back in time… almost three decades ago… back to the wild and woolly 1980s! And watch our favorite DBMS, DB2, grow up over time. Version 1 Release 1 was announced on June 7, 1983. And it became generally available on Tuesday, April 2, 1985. I…...

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 Do You Transition from a Consulting Job Back to Management?

How Do You Transition from a Consulting Job Back to Management? Hello, this is Laura Lee Rose – Corporate Exit Strategist for the Blooming Entrepreneur – and I am a business and life coach that specializes in time management, project management and work-life balance strategies. I recently received a question regarding “How do you transition from a consulting job back…...

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

New Features of SQL Server 2012

New Features of SQL Server Denali By Kautuk Pandey We have just been greeted by another new version of SQL Server in the form of SQL Server 2012/Denali. This release comes with a number of new features. In this article I talk about a few of them. AlwaysON is definitely going to be one of the most exciting new things…...

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
Development Pro Members Standard Members

New Features in Visual Studio 11

Visual Studio 2011 is the next generation of development IDE from Microsoft (commonly known as vNext). Visual Studio 2011 is also referred to as Visual Studio 11. It provides an integrated development environment that simplifies the tasks of creating, managing, debugging, and deploying application software on Windows environments. That’s right here we are with the next version of Visual Studio…...

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

Demystifying SQL Server Differential Database Backups

Demystifying SQL Server Differential Database Backups By Wes Brown, Founding member of the Idera ACE Program and DBA Consultant at Dell SQL Server has three backup types. Two you have heard of and used. One, while useful, isn’t very well understood. Let’s start with a technical recap of the three backup types for SQL Server. 1. Full Database Backup When…...

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 SQL Server 2008 R2 Transactional Replication

Troubleshooting problems with SQL Server 2008 R2 Transactional Replication If you have problems with SQL Server 2008 R2 transactional replication, review this troubleshooting checklist to find potential solutions. 1. Check that you use the latest SQL Server 2008 R2 service pack. Because many SQL Server 2008 R2 transactional replication bugs were fixed in SQL Server service packs, you should install…...

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

System Health Session Dashboard

System Health Session Dashboard I had written a series on how to create reports based on the system health session for SQL Server 2008 and above instances in the recent past. I got a lot of positive feedback regarding the reports which got me thinking on how to make this available using the new features of SQL Server 2008 R2…...

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