Standard Members

Pro Members SQL Server Standard Members

How to Overcome Nervousness of Public Speaking of Attending Networking Events – Part 1

by

How to Overcome Nervousness of Public Speaking of Attending Networking Events Part 1 Career Management Series By Laura Lee Rose Hello, this is Laura Lee Rose – author of TimePeace: Making peace with time – and I am a business and efficiency coach that specializes in time management, project management and work-life balance strategies. I help busy professionals and entrepreneurs...

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

Undocumented Maintenance SQL Server 2014 DBCC Commands

by

Undocumented Maintenance SQL Server 2014 DBCC Commands In this article, you can find the description of some useful undocumented maintenance DBCC commands, and find out how you can use these commands in SQL Server 2014 for administering and maintenance tasks. 1. DBCC addinstance This DBCC command can be used to add an object instance to track in Performance Monitor. Syntax:...

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

Application of Triggers and Understanding the Transaction Procedures in Database Part – 8

by

Application of Triggers and Understanding the Transaction Procedures in Database Part – 8 What is Deadlock? The deadlock is a state where more than one (1) transaction blocks the distinct items, as well as every single transaction pauses for a block on the additional item to get free. Deadlocks are very much risky for the reason that they decline 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 →
Pro Members SQL Server Standard Members

New Features in SQL Server 2016

by

New Features in SQL Server 2016 Author: Basit A. Farooq During his keynote speech at Microsoft Ignite conference in Chicago, Microsoft Corporate CEO Satya Nadella announced that the first public preview of SQL Server 2016 will be available this summer. Finally, the wait is over and on the May 27, 2015, the first public preview of SQL Server 2016 was...

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 do you do to add some fun to running your business?

by

What do you do to add some fun to running your business? 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...

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

Some tips for using SQL Server 2014 configuration options

by

Some tips for using SQL Server 2014 configuration options SQL Server 2014 configuration options may be separated to two categories: – Options that take effect immediately after setting the option and issuing the RECONFIGURE. – Options that take effect only after restarting the instance of SQL Server. In this article, you can find the description of some useful SQL Server...

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

Application of Triggers and Understanding the Transaction Procedures in Database Part – 7

by

Application of Triggers and Understanding the Transaction Procedures in Database Part – 7 How to Control SQL Server Locks? The different types of locks are applied spontaneously by the SQL Server only. By default, the SQL Server locks every single row / tuple which an individual request. At times when an individual request a huge result set, the locks 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 →
Oracle Pro Members Standard Members

Projecting JSON Data Into Relational Format in Oracle Database

by

Projecting JSON Data Into Relational Format in Oracle Database By Yuli Vasiliev It is common for Web services and Web applications today to use JSON as a data-interchange format. Starting with release 12.1, Oracle Database supports JSON, allowing you to access JSON content stored either inside or outside of the database. This article explains how you might project JSON data...

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 can I increase the responses on my customer satisfaction surveys?

by

How can I increase the responses on my customer satisfaction surveys? 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...

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

Some useful SQL Server 2014 trace flags

by

Some useful SQL Server 2014 trace flags Trace flags are used to temporarily set specific server characteristics or to switch off a particular behavior. You can set trace flags by using the DBCC TRACEON command or by using the -T option with the sqlservr command-line executable. There are 2 types of trace flags in SQL Server 2014: – global trace...

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 … 53 54 55 56 57 … 110