Standard Members Archives - Page 92 of 110

Standard Members

Tips for using jobs in SQL Server 2012

by Alexander Chigrik

Tips for using jobs in SQL Server 2012 Specify the understandable job name. Try to specify the job’s name so, that the name describes what the job makes. By using so, you can simplify jobs administering and monitoring. Try to separate very large job into several small jobs. This can improve performance, and can be useful to maintenance the jobs...

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

Learning SSAS: Part V – Creating Dimensions

by Kautuk Pandey

Learning SSAS: Part V – Creating Dimensions Hello and welcome to the fifth part of the series. In the previous articles I showed you how to create an SSAS cube and build and deploy it to a target Analysis Server. In the process you should have learnt how to create Data Sources, Data Source Views, Diagrams and Calculated Columns etc....

Already a member? Log in here

Continue Reading →

Pro Members SQL Server Standard Members

SQL Server Database Backups and Recovery Model – (Part 1)

by Basit Aalishan Masood-Al-Farooq

SQL Server Database Backups and Recovery Models – (Part 1) Author: Basit A. Farooq Editor Notes: This is the three part article series on SQL Server Database Backups and Recovery Models. In the first part, you will learn about basics of SQL Server backup process and database recovery models.In the second part, you will learn about database backup and transaction...

Already a member? Log in here

Continue Reading →

Pro Members SQL Server Standard Members

Keeping a job offer alive

by Laura Lee Rose

Keeping a Job Offer Alive Professional Development Series This is Laura Lee Rose, a business and life coach that specializes in professional development, time management, project management and work-life balance strategies. In my GoTo Academy: Soft Skill Tools for the GoTo Professional continuous online coaching series, I go into professional development and real-world IT topics in detail. If you are...

Already a member? Log in here

Continue Reading →

Oracle Pro Members Standard Members

Proxy Authentication Via Roles

by Yuli Vasiliev

Proxy Authentication Via Roles By Yuli Vasiliev Proxy authentication via roles in Oracle Database gives you greater flexibility when you want to realize the principle of least privilege. You don’t grant privileges directly to users but to roles. Also, when connecting through another user, you’ll be able to enable only those roles that are needed to get the job done....

Already a member? Log in here

Continue Reading →

Pro Members SQL Server Standard Members

Troubleshooting Upgrading to SQL Server 2012

by Alexander Chigrik

Troubleshooting Upgrading to SQL Server 2012 Should you have problems during upgrading to SQL Server 2012, review this troubleshooting checklist to find potential solutions. 1. Check the hardware requirements. To upgrade to SQL Server 2012, you should have the following hardware: – Intel or compatible platform with processor speed: x86 Processor – 1.0 GHz minimum, x64 Processor – 1.4 GHz...

Already a member? Log in here

Continue Reading →

Pro Members SQL Server Standard Members

Monitoring Blocked Processes with Event Notifications

by Basit Aalishan Masood-Al-Farooq

Monitoring Blocked Processes with Event Notifications Author: Basit A. Farooq Introduction SQL Server is able to service requests from a large number of concurrent users. When SQL Server is servicing requests from many clients, there is a strong possibility that conflicts will occur because different processes request access to the same resources at the same time. A conflict in which...

Already a member? Log in here

Continue Reading →

Oracle Pro Members Standard Members

Assuming Another User’s Identity In Oracle Database

by Yuli Vasiliev

Assuming Another User’s Identity In Oracle Database By Yuli Vasiliev Allowing a user to assume the identity of another user is an Oracle Database capability that allows you to give users privileges needed to get the job done without compromising the ability to trace what user performed an operation. This capability is known as proxy authentication and available in Oracle...

Already a member? Log in here

Continue Reading →

Pro Members SQL Server Standard Members

Elemental MDX: MDX Time Series Functions: PeriodsToDate() and OpeningPeriod(), Pt. 3

by William Pearson

Elemental MDX: MDX Time Series Functions: PeriodsToDate() and OpeningPeriod(), Pt. 3 In this, the third of a three-part article focusing upon the PeriodsToDate() and OpeningPeriod() time series functions, we will continue to expose functions that we can use to perform analysis within the context of time. As we discussed in Part 1, many business requirements revolve around theperformance of analysis...

Already a member? Log in here

Continue Reading →

Pro Members SQL Server Standard Members

Managing Database Storage

by Craig Mullins

Managing Database Storage By Craig S. Mullins Database systems require data files to store the data under management. These files, or data sets, reside on storage media. So storage management should be a key part of the database operations required of a database administrator (DBA). Unfortunately, storage is sometimes relegated to an afterthought; after all, don’t we have storage administrators...

Already a member? Log in here

Continue Reading →