Overview of Database Management System (DBMS) Part – 10 Categories of Database Application More than a few standards are generally castoff to categorize Database Management System (DBMS). The 1st is the information modeling on which the Database Management System (DBMS) is constructed. The key information modeling castoff in numerous present commercial Database Management System (DBMS) is the relational information modeling. […]
SQL Server
Configuring and Administering Windows Azure SQL database – Part 1
Configuring and Administering Windows Azure SQL database – Part 1 Author: Basit A. Farooq Microsoft Windows Azure SQL database or simply Azure SQL database is a cloud-based relational database platform that is based on Microsoft SQL Server technologies. Azure SQL database runs a special version of Microsoft SQL Server that provides the subset of SQL Server functionality as its core […]
Four Undocumented SQL Server 2014 Agent Procedures
Four Undocumented SQL Server 2014 Agent Procedures SQL Server 2014 supports the following useful undocumented SQL Server Agent stored procedures: sp_MSgetalertinfo sp_readerrorlog sp_sqlagent_is_srvrolemember sp_sqlagent_get_startup_info Two of these stored procedures exist in the master database (sp_MSgetalertinfo and sp_readerrorlog), other exist in the msdb database. sp_MSgetalertinfo The sp_MSgetalertinfo stored procedure is used to get information about alerts from Windows registry. Syntax sp_MSgetalertinfo […]
How Can I Raise Prices on My Existing Customers Without Losing Them?
How can I raise prices on my existing customers without losing them? 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 […]
Five Undocumented SQL Server 2014 Job Stored Procedures
Five Undocumented SQL Server 2014 Job Stored Procedures SQL Server 2014 supports the following useful undocumented SQL Server job stored procedures: sp_MSget_jobstate sp_delete_all_msx_jobs sp_get_job_alerts sp_multi_server_job_summary sp_help_operator_jobs One of these stored procedures exist in the master database (sp_MSget_jobstate), other exist in the msdb database. sp_MSget_jobstate The sp_MSget_jobstate stored procedure returns the job state for the specified job. Syntax sp_MSget_jobstate [ @job_id […]
Overview of Database Management System (DBMS) Part – 9
Overview of Database Management System (DBMS) Part – 9 Three Tire Architecture The aim of the three tired architecture is to isolate the end user application as well as the physical database application. In this design, schemas can be demarcated at the subsequent three (3) stages: 1. The inner stage has a core schema that defines the physical storing arrangement […]
The 6 Biggest Pitch Deck Mistakes You May Not Know You’re Making
The 6 Biggest Pitch Deck Mistakes You May Not Know You’re Making Today we are very fortunate to have a TV program to emulate regarding the perfect pitch deck. If you haven’t already watched ABC’s the Shark Tank, make the time to watch and take notes. It gives you a very good illustration of pitching to investors. Even though the […]
Five Undocumented SQL Server 2014 log shipping stored procedures
Five Undocumented SQL Server 2014 log shipping stored procedures In this article, I want to describe the following five undocumented log shipping stored procedures shipped with SQL Server 2014: sp_check_log_shipping_monitor_alert sp_create_log_shipping_monitor_account sp_delete_log_shipping_monitor_info sp_delete_log_shipping_monitor_jobs sp_log_shipping_get_date_from_file sp_check_log_shipping_monitor_alert The sp_check_log_shipping_monitor_alert log shipping stored procedure is used to check all monitor alerts in the primary database and in the secondary database in log shipping […]
Overview of Database Management System (DBMS) Part – 8
Overview of Database Management System (DBMS) Part – 8 Database End Users plus End User Interfaces There are four (4) dissimilar kinds of database application end users, distinguished by means of the method they imagine to work with the database application. Dissimilar kinds of end user interfaces have been planned for the dissimilar kinds of end users. 1. Inexperienced end […]
How Do You Negotiate with Difficult People?
How Do You Negotiate with Difficult People? 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 comfortably delegate to others, be more […]