Pro Members

Pro Members SQL Server Standard Members

SQL Server Interview Questions and Answers for DBAs and Developers – (Part-3)

by

SQL Server Interview Questions and Answers for DBAs and Developers – (Part-3) Author: Basit A. Farooq This article outlines the interview questions that you should ask to SQL Server DBA. These questions will help you to assess the candidate’s knowledge in relation to SQL Server instance-wide properties and settings. Question Difficulty = Moderate Question 1: How you can view 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
Continue Reading →
Development Pro Members Standard Members

What is the best way to encourage an unemployed friend?

by

What is the best way to encourage an unemployed friend? Hello, this is Laura Lee Rose. I am a speaker and author. I am an expert in time and project management. I help busy professionals and entrepreneurs create effective systems so that they can comfortably delegate to others, be more profitable and have time to enjoy life even if they...

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

Applying Managed Programming – Part 3

by

Applying Managed Programming Part – III Forming Managed Functions For building a managed function by means of an imported assembly, an individual can practice the CREATE FUNCTION statement, as displayed in the subsequent syntax:- CREATE FUNCTION < My_Function_Name > ( < My_Parameter_List > ) RETURNS < My_Return_Type > AS EXTERNAL NAME < My_Assembly_Name > . < My_Type_Name > . <...

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

Tips for using tempdb database in SQL Server 2014

by

Tips for using tempdb database in SQL Server 2014 Permit the tempdb database to automatically grow. Autogrow feature is set by default. Each time the SQL Server 2014 is started, tempdb database is recreated and reset to its default size. Automatically growing results in some performance degradation, therefore you should set a reasonable size for tempdb database and a reasonable...

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

SQL Server Interview Questions and Answers for DBAs and Developers – (Part-2)

by

SQL Server Interview Questions and Answers for DBAs and Developers – (Part-2) Author: Basit A. Farooq In this second part, we will focus on interview questions, which you should ask to SQL Server DBA. These questions will help you to assess the basic knowledge and skills of the candidates in relation to SQL Server product and features. Question Difficulty =...

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

How Introverts Can Successfully Network

by

How Introverts Can Successfully Network Hello, this is Laura Lee Rose. I am a speaker and author. I am an expert in time and project management. I help busy professionals and entrepreneurs create effective systems so that they can comfortably delegate to others, be more profitable and have time to enjoy life even if they don’t have time 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
Continue Reading →
Pro Members SQL Server Standard Members

Applying Managed Programming – Part 2

by

Applying Managed Programming Part – II Making Managed Database Items To form managed database items in the SQL Server, an individual necessity to first produce a managed program in any of the .NET program designing languages. A managed program comprises of classes as well as methods which offers a wanted functionality. Subsequently, an individual must compile the program to construct...

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

Tips for using SQL Server 2014 Profiler

by

Tips for using SQL Server 2014 Profiler SQL Server 2014 Profiler is a graphical user interface to create and manage traces and analyze and replay trace results. SQL Server Profiler allows to capture and save data about each event to a file or table to analyze later. In this article, you can find some helpful tips to performance tune and...

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

Applying Managed Programming – Part 1

by

Applying Managed Programming – Part I The managed programming may possibly sounds like systematized and well thought out program writing or more like controlled software programming, and to some extends its quite factual; let’s take a look into the “MANAGED PROGRAMMING” in details now. The managed programs are executed in .NET CLR (Common Language Runtime). The SQL Server assimilates CLR...

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

Tips for using Integration Services in SQL Server 2014 (Part 2)

by

Tips for using Integration Services in SQL Server 2014 (Part 2) Use the bcp utility instead of Integration Services when you need to export data from the SQL Server table into a text file. The bcp utility is much faster than SSIS, so try to use it whenever possible. If you need to sort data or identify similar data rows,...

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 … 57 58 59 60 61 … 110