Six Undocumented SQL Server 2014 Database Engine Stored Procedures SQL Server 2014 supports the following useful undocumented database engine stored procedures: sp_bcp_dbcmptlevel sp_MSforeachdb sp_MSforeachtable sp_MSindexspace sp_MStablespace sp_objectfilegroup sp_bcp_dbcmptlevel The sp_bcp_dbcmptlevel database engine stored procedure is used to get the database compatibility level for the specified database. Syntax sp_bcp_dbcmptlevel [ @dbname = ] ‘dbname’ Arguments [ @dbname = ] ‘dbname’ The […]
SQL Server
Overview of Database Management System (DBMS) Part – 7
Overview of Database Management System (DBMS) Part – 7 Data Dictionary or Data Directory An individual can describe a data dictionary or data directory as a Database Management system (DBMS) module which keeps the description of information appearances as well as associations. An individual might recall that this “information about information” was considered as metadata. The Database Management system (DBMS) […]
3 Keys to Increasing Your Workforce on a Shoestring Budget – Part 3
3 Keys to Increasing Your Workforce on a Shoestring Budget – Part 3 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 so that they can […]
Five Undocumented SQL Server 2014 OLEDB Stored Procedures
Five Undocumented SQL Server 2014 OLEDB Stored Procedures SQL Server 2014 supports the following useful undocumented oledb stored procedures: sp_oledb_database sp_oledb_defdb sp_oledb_deflang sp_oledb_language sp_oledb_ro_usrname sp_oledb_database The sp_oledb_database stored procedure returns the oledb database name. Syntax sp_oledb_database Return Code Values None. Result Sets Column name Type Description name sysname The name of the oledb database Remarks This stored procedure exists in […]
Overview of Database Management System (DBMS) Part – 6
Overview of Database Management System (DBMS) Part – 6 Database Operation Language A database application delivers a Data Definition Language (DDL) to stipulate the database schema as well as a Data Manipulation Language (DML) to define database queries plus alteration In reality, the Data Definition Language (DDL) and Data Manipulation Language (DML) are not two (2) distinct languages; as a […]
3 Keys to Increasing Your Workforce on a Shoestring Budget – Part 2
3 Keys to Increasing Your Workforce on a Shoestring Budget – Part 2 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 so that they can […]
Five Undocumented SQL Server 2014 Database Mail Procedures
Five Undocumented SQL Server 2014 Database Mail Procedures SQL Server 2014 supports the following useful undocumented database mail stored procedures: sp_RunMailQuery sp_SendMailMessage sp_sysmail_activate sysmail_verify_account_sp sysmail_verify_profile_sp Note. These stored procedures exist in the msdb database, not in master. sp_RunMailQuery The sp_RunMailQuery database mail stored procedure is used to run the mail query. This stored procedure is used in the sp_send_dbmail stored […]
Encrypting sensitive within databases using SQL Server 2016 AlwaysEncrypted feature
Encrypting sensitive within databases using SQL Server 2016 AlwaysEncrypted feature Author: Basit A. Farooq With the increasing number of incidents of lost and unauthorized exposure to sensitive data, database security is a vital and growing concern for many enterprises. Publicly owned enterprises that hold sensitive data such as social security numbers or credit card numbers in their databases should encrypt […]
Overview of Database Management System (DBMS) – Part 5
Overview of Database Management System (DBMS) – Part 5 Information Modeling Designing the construction of a database is the information modeling: a gathering of theoretical tools for labeling information, information associations, information semantics, as well as reliability constrictions. In the direction of demonstrating the notion of information modeling, two (2) information models have been outlined: the entity – relationship (ER) […]
3 Keys to Increasing Your Workforce on a Shoestring Budget – Part 1
3 Keys to Increasing Your Workforce on a Shoestring Budget – Part 1 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 so that they can […]