Hardening SQL Server Installation SQL Server is a repository of sensitive information for organizations, and that is why, it is important to ensure that only authorized users have access to this sensitive information. However, securing SQL Server in a way that is not likely to errors is not an easy task, and as database administrators (DBAs), we have to perform […]
SQL Server
Some tips for using full-text search in SQL Server 2016
Some tips for using full-text search in SQL Server 2016 Use a full-text query instead of the LIKE Transact-SQL predicate if you need to query formatted binary data or query a large amount of unstructured text data. A full-text query against millions of rows of text data can take only seconds; whereas a LIKE query against the same data can […]
Managing Query Execution in Database Engine Part – 2
Managing Query Execution in Database Engine Part – 2 Query Management Before query management is performed, an individual will of course want to decide what things need to be improved first. The aim of accomplishing competence itself might be unlike in dissimilar circumstances. For an instance, an individual may need to reduce the execution time but then again in numerous […]
Managing Query Execution in Database Engine Part – 1
Managing Query Execution in Database Engine Part – 1 Introduction In this article we will be discussing about the query handling process in Database Management System (DBMS). In many Database Management System (DBMS), queries are placed in a non procedural language like Structured Query Language (SQL) and as it was mentioned in earlier articles that such queries does not include […]
What is the Best Way to Encourage/Empower Employees Through Reading?
What is the best way to encourage/empower employees through reading? 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 […]
Introduction to Structured Query Language (SQL) — Part — 7
Introduction to Structured Query Language (SQL) – Part – 7 Foreign Keys Constrictions A Foreign Key (FK) constriction stipulates that the data in a column or attribute otherwise in a group of columns or attributes should match the data appearing in a number of row or tuples of alternative table or relation. It can be said that this preserves the […]
How to Increase the Revenue Value of Non-Revenue Generating Roles – Part 2
How to Increase the Revenue Value of Non-Revenue Generating Roles Part 2 Career Management Series By Laura Lee Rose Small business owners have several budget constraints. One of the most prevalent is staffing. And small businesses wish to reduce or eliminate “non-billable” positions or positions that don’t directly bring in revenue. In the How to Increase the Revenue Value of […]
Tips for using stored procedures in SQL Server 2016
Tips for using stored procedures in SQL Server 2016 Try to avoid using temporary tables and DDL (Data Definition Language) statements inside your stored procedure. Using temporary tables or DDL statements inside stored procedure reduces the chance to reuse the execution plan. Consider using user-defined table type as a parameter for the stored procedures. SQL Server 2016 supports a user-defined […]
Introduction to Structured Query Language (SQL) — Part — 6
Introduction to Structured Query Language (SQL) – Part – 6 Database Wide Privileges The database wide privilege gives the database user either Database Administrators (DBA) or RESOURCE rights. Database users with Database Administrators (DBA) rights have the capability to access, alter, and otherwise remove any database items as well as can grant rights to additional database users. RESOURCE rights permit […]
How to Increase the Revenue Value of Non-Revenue Generating Roles – Part 1
How to Increase the Revenue Value of Non-Revenue Generating Roles 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 create […]