Standard Members

Pro Members SQL Server Standard Members

How to Manage Without Micromanaging (Part 2)

by

How to manage without micromanaging Part 2 Validating others’ perspectives 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 TV, we covered the importance...

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
Continue Reading →
Pro Members SQL Server Standard Members

Using a Dedicated Administrator Connection (DAC) on SQL Server

by

Using a Dedicated Administrator Connection (DAC) on SQL Server Introduction: Today, I received a call from one of our clients complaining they are not able to login to SQL Server after the recent code deployment. To investigate the problem, I tried to connect to SQL Server remotely using SSMS on my laptop, but my connection also hangs and I’m not...

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
Continue Reading →
Pro Members SQL Server Standard Members

Troubleshooting problems with DBCC commands in SQL Server 2008 R2

by

Troubleshooting problems with DBCC commands in SQL Server 2008 R2 If you have problems with SQL Server 2008 R2 DBCC commands, review this troubleshooting checklist to find potential solutions. 1. Install the latest SQL Server 2008 R2 service pack. Because many SQL Server 2008 R2 DBCC bugs were fixed in SQL Server service packs, you should install the latest SQL...

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

Don’t Forget DISPLAY as a Part of Your DB2 Tuning Efforts (part 3)

by

Don’t Forget DISPLAY as a Part of Your DB2 Tuning Efforts (part 3) Utility Execution Information If you are charged with running (IBM) DB2 utilities, another useful command is DISPLAY UTILITY. Issuing a DISPLAY UTILITY command will cause DB2 to display the status of all active, stopped, or terminating utilities. So, if you are in over the weekend running REORGs,...

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
Continue Reading →
Pro Members SQL Server Standard Members

Creating and Managing User-Defined Roles in SQL Server 2012

by

Creating and Managing User-Defined Roles in SQL Server 2012 Introduction SQL Server 2012 introduces user-defined server roles. These user-defined server roles are similar to fixed server roles with only difference is that they are created by SQL Server Administrator. SQL Administrators can create, delete or manage these user-defined server roles using T-SQL or SQL Server Management Studio. User-defined roles can...

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
Continue Reading →
Pro Members SQL Server Standard Members

Troubleshooting problems with Reporting Services in SQL Server 2008 R2

by

Troubleshooting problems with Reporting Services in SQL Server 2008 R2 If you have problems with SQL Server 2008 R2 Reporting Services, review this troubleshooting checklist to find potential solutions. 1. Install the latest SQL Server 2008 R2 service pack. Because many SQL Server 2008 R2 Reporting Services bugs were fixed in SQL Server service packs, you should install the latest...

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

Don’t Forget DISPLAY as a Part of Your DB2 Tuning Efforts (part 2)

by

Don’t Forget DISPLAY as a Part of Your DB2 Tuning Efforts (part 2) Of course, there are many additional options that can be used in conjunction with the DISPLAY DATABASE command. The following options can be used to narrow down the amount of information displayed: USE displays what processes are using resources for the page sets in the database CLAIMERS...

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
Continue Reading →
Pro Members SQL Server Standard Members

Working with Sensitive Client Issues

by

Working with Sensitive Client Issues By Laura Lee Rose, author of TimePeace: Making peace with time Hello, this is Laura Lee Rose – Corporate Exit Strategist for the Blooming Entrepreneur. I am a business and life coach that specializes in time management, project management and work-life balance strategies. As business owners, we are sometimes faced with difficult client billing issues...

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
Continue Reading →
Pro Members SQL Server Standard Members

Retrieving Deadlock Graphs with Event Notification

by

Retrieving Deadlock Graphs with Event Notification Basit A Farooq Introduction Recently, one of our clients requested us that they wanted instant deadlock notification every time a deadlock occurs on their SQL Server. This notification should be in the form of email alert containing a deadlock graph as an attachment. As we know, SQL Server provides variety of different ways 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.
Register
Already a member? Log in here
Continue Reading →
Pro Members SQL Server Standard Members

Troubleshooting problems with locking in SQL Server 2008 R2

by

Troubleshooting problems with locking in SQL Server 2008 R2 If you have problems with SQL Server 2008 R2 locking, review this troubleshooting checklist to find potential solutions. 1. Install the latest SQL Server 2008 R2 service pack. Because many SQL Server 2008 R2 locking bugs were fixed in SQL Server service packs, you should install the latest SQL Server service...

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
Continue Reading →
1 … 104 105 106 107 108 … 110