SQL Server

Pro Members SQL Server Standard Members

Undocumented SQL Server 2017 Agent Procedures

Undocumented SQL Server 2017 Agent Procedures SQL Server 2017 supports the following useful undocumented SQL Server Agent stored procedures: sp_sqlagent_is_srvrolemember sp_sqlagent_get_startup_info sp_MSgetalertinfo sp_readerrorlog Two of these stored procedures exist in the msdb database (sp_sqlagent_is_srvrolemember and sp_sqlagent_get_startup_info), other exist in the master database. sp_sqlagent_is_srvrolemember The sp_sqlagent_is_srvrolemember stored procedure indicates whether a SQL Server login is a member of the specified fixed...

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

Database Models and Relational Algebra – Part 5

THE RELATIONAL CALCULUS In relational calculus, a query is conveyed as a formulary plan which contains a number of variables as well as an expression concerning these variables. It is up to the Database Management System (DBMS) to convert these non – technical queries into the same, well-organized, effective and procedural queries. The concept of relational calculus was first planned...

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

How Do You Develop an Effective Content Marketing Strategy?

This question came from a small business owner. How do you develop an effective content marketing strategy? What are your rules? While there are no defined “rules” for building a content marketing strategy, it’s important to include these key components: Market Research and Analysis Valuable and Effective Content Develop Your Brand’s Voice Stay Consistent Analyze Your Results Market Research 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
Pro Members SQL Server Standard Members

Undocumented SQL Server 2017 oledb stored procedures

Undocumented SQL Server 2017 oledb stored procedures SQL Server 2017 supports the following useful undocumented oledb stored procedures: sp_oledb_language sp_oledb_ro_usrname sp_oledb_database sp_oledb_defdb sp_oledb_deflang sp_oledb_language The sp_oledb_language database engine stored procedure returns the official language name and alternative language name for each language presents in the instance of SQL Server 2017. Syntax sp_oledb_language Return Code Values None. Result Sets Column 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
Pro Members SQL Server Standard Members

Database Models and Relational Algebra – Part 4

The INTERSECTION Operators The INTERSECTION operation on table or relation A and B can be described as relation A INTERSECTION relation B designated as A ∩ B. In other words the rows or tuples which are common as well as belonging to both the tables or relations A and B only those rows or tuples are incorporated in the result...

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

How Best to Promote Yourself in a Job Interview

This question comes from a busy professional. Looking for HR experts to speak to how to promote yourself in a job interview. One crucial element in a job interview comes with the opening question, “So tell me about yourself.” I’m looking for HR and career coaching experts to give tips on how to speak to your accomplishments without coming off...

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

Undocumented SQL Server 2017 job stored procedures

Undocumented SQL Server 2017 job stored procedures SQL Server 2017 supports the following useful undocumented job stored procedures: sp_MSget_jobstate sp_delete_all_msx_jobs sp_get_job_alerts sp_multi_server_job_summary sp_help_operator_jobs sp_MSget_jobstate The sp_MSget_jobstate stored procedure returns the job state for the specified job. Syntax sp_MSget_jobstate [ @job_id = ] ‘job_id’ Arguments [ @job_id = ] ‘job_id’ Is the job identifier. job_id is UNIQUEIDENTIFIER, with no default. Return...

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

Database Models and Relational Algebra – Part 3

RELATIONAL ALGEBRA in Database Management System The relational algebra operators are mathematical functions which are castoff to recover queries by means of explaining a particular sequence of procedures on relations or tables and sometimes on even databases schema. With the help of relational algebra operators, each and every query is always created by a number of relational algebra operators, which...

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

Database Models and Relational Algebra – Part 2

B+ Tree Index Files Any B+ tree is the n-ary tree structure with a variable however over and over again large number of children per node used to be present. A B+ tree is consisting of a root, internal nodes as well as leaves. The root might be one or the other leaf node with two (2) or more (N)...

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