Information Modeling By means of Entity Relationship (ER) Method Part – 3 · Categorizing Relationships – Relationships are categorized by their degree, connectivity, cardinality, course, kind, as well as presence. Not every model practices practice all these categorizations. Among these various categories – degree, connectivity, and cardinality are already explained in Part – 2. The reaming categories like course, kind, […]
SQL Server
How do you set up a sales strategy as a start-up with little to no money?
How do you set up a sales strategy as a start-up with little to no money? 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 […]
Configuring and Administering Windows Azure SQL Database– Part 2
Configuring and Administering Windows Azure SQL Database– Part 2 Author: Basit A. Farooq Working with Windows Azure SQL Database We can use SQL Server Management Studio to perform administration, maintenance and development tasks for Windows Azure SQL Database server. SQL Server Management Studio provides us with a great user interface for the management of SQL Server. However, these management and […]
Tips for using tempdb database in SQL Server 2016
Tips for using tempdb database in SQL Server 2016 Use TempDB section of SQL Server Installation Wizard. SQL Server 2016 introduces the new UI input control on the Database Engine Configuration – TempDB section of SQL Server Installation Wizard. Now during setup, you can configure the number of tempdb database files, initial size, autogrowth and directory placement. You can specify […]
Information Modeling By means of Entity Relationship (ER) Method Part – 2
Information Modeling By means of Entity Relationship (ER) Method Part – 2 Simple Concepts of Entity Relationship (ER) Model The Entity Relationship (ER) modeling interprets the real world as a concept of objects or entities as well as relationship among objects or entities. · Objects or Entities – Objects or Entities are the main information item about which data is […]
Product Funnel Strategy for Non-profits
Product Funnel Strategy for Non-profits 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 profitable and […]
Tips for using SQL Server 2016 triggers
Tips for using SQL Server 2016 triggers Try to minimize the number of rows affected in a trigger. The more number of rows affected in a trigger, the more time a trigger takes to run. So, try to reduce the number of rows affected in a trigger. Consider using triggers on memory-optimized tables. SQL Server 2016 introduces supporting triggers on […]
Information Modeling By means of Entity Relationship (ER) Method Part – 1
Information Modeling By means of Entity Relationship (ER) Method Part – 1 Introduction An information modeling is an intangible illustration of the information arrangements which is necessary for a database. The information arrangements are consisting of the information objects, the relations among information objects, as well as the guidelines which controls he the actions on the objects. As the title […]
How to Handle Client When They Want to Barter for Your Services
How to Handle Client When They Want to Barter for Your Services 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 […]
Three Undocumented SQL Server 2014 XML Stored Procedures
Three Undocumented SQL Server 2014 XML Stored Procedures SQL Server 2014 supports the following three undocumented XML system stored procedures: sp_syscollector_validate_xml sp_xml_schema_rowset sp_xml_schema_rowset2 sp_syscollector_validate_xml The sp_syscollector_validate_xml system stored procedure is used to validate the XML collector. Syntax sp_syscollector_validate_xml [ @collector_type_uid = ] ‘collector_type_uid’, [ @name = ] ‘name’, [ @parameters = ] ‘parameters’ Arguments [ @collector_type_uid = ] ‘collector_type_uid’ Is […]