SQL Server

Pro Members SQL Server Standard Members

SQL Server Development and Deployment Standards

SQL Server Development and Deployment Standards The purpose of this article is to highlight a set of standards for the development and deployment of database code. This will allow best practices to be complied with, standards to be maintained and ownership to be traced. It will also mean that developers and DBAs alike can share common practices that will assist...

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 to Overcome Nervousness of Public Speaking of Attending Networking Events – Part 1

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
SQL Server

Some tips for SQL Server 2016 clustering

Some tips for SQL Server 2016 clustering Avoid running other software on the SQL Server 2016 cluster nodes. To increase SQL Server 2016 performance, SQL Server clusters should be dedicated to SQL Server only. Consider using Distributed Availability Groups (DAG) if you have two availability groups residing on different Windows Server Failover Clusters (WSFC). DAG enables you to associate two […]

SQL Server

Managing Query Execution in Database Engine Part 5

Managing Query Execution in Database Engine Part – 5 Elementary Algorithms for Executing Query Processes The effectiveness of query handling in a Relational Database Management System (RDBMS) is grounded on the competence of the relational operators. Even the easiest actions can frequently be implemented in a number of different methods as well as the costs of the different methods could […]

SQL Server

Managing Query Execution in Database Engine Part – 3

Managing Query Execution in Database Engine Part – 3 Internal Query Arrangement As it was known previously, a query created in a query language like Structural Query Language (SQL) should be 1st transformed to an internal arrangement which is appropriate for a machine to understand and represent as well. Every internal query arrangement should be adequately influential to signify every […]

SQL Server

What are some good ways to bring back lost customers?

What are some good ways to bring back lost customers? 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 create effective systems […]