Troubleshooting SQL Server 2012 Bulk Copy Problems If you have problems with SQL Server 2012 bulk copy, review this troubleshooting checklist to find potential solutions. 1. Install the latest SQL Server 2012 service pack. Because some SQL Server 2012 bulk copy bugs were fixed in SQL Server service packs, you should install the latest SQL Server service pack. At the...
Standard Members
Fabricating Data Sets
Fabricating Data Sets You often need to fabricate a data set when it comes to creating a report showing daily results for each day in a certain range, regardless of whether there was an activity on a particular day or not. That being said, you need to build a query that will produce a row for each day within a...
The Cloud Demands Rethink of Computing Architecture
The Cloud Demands Rethink of Computing Architecture Structure follows concept. Cloud business models are no exceptions to this rule. Cloud computing creates a number of conceptual shifts and consequent architectural shifts in computing delivery. It disrupts existing computing paradigms and understandings of computing infrastructures. It forces the user rethink enterprise level computing service delivery models. Computing architecture is no longer...
How to Recover from a Bad Review or Termination
How to Recover from a Bad Review or Termination Hello, this is Laura Lee Rose – author of the business and time management books TimePeace: Making peace with time and The Book of Answers: 105 Career Critical Situations– I help busy professionals and entreprenurs create effective systems so that they can comfortably delegate to others, be more profitable and have...
SQL Server: Database Design Basics – (Part 2)
SQL Server: Database Design Basics – (Part 2) Author: Basit A. Farooq In this article, you will learn about table design, entities and attributes and their relation to the tables and columns. You will also learn how to enforce data integrity through domain integrity, entity integrity, referential integrity, and user-defined integrity, and how to use primary keys, unique constraints and...
Troubleshooting SQL Server 2012 XML Problems
Troubleshooting SQL Server 2012 XML Problems If you have problems with SQL Server 2012 XML, review this troubleshooting checklist to find potential solutions. 1. Check that you use the latest SQL Server service pack. Because some SQL Server 2012 XML bugs were fixed in SQL Server service packs, you should install the latest SQL Server service pack. At the time...
SharePoint Server 2013: Basics for Everyone – Part I
SharePoint Server 2013: Basics for Everyone – Part I SharePoint Server 2013 is a member of the Microsoft family of servers and offers an integrated suite of services to its users. The SharePoint server is a hosted application that runs on the Windows Server Operating System. It provides support for Intranets and Extranets and aims to improve organizational effectiveness by...
Bragging Advice for the Terminally Shy
Bragging Advice for the Terminally Shy Hello, this is Laura Lee Rose – author of the business and time management books TimePeace: Making peace with time and The Book of Answers: 105 Career Critical Situations– and I am a business and efficiency coach that specializes in time management, project management and work-life balance strategies. Simply put, I give people the...
SQL Server: Database Design Basics – (Part 1)
SQL Server: Database Design Basics – (Part 1) Author: Basit A. Farooq In this article, you will learn about database design concepts. The database design concepts discussed in this article focus almost exclusively on OLTP requirements. OLAP design is beyond the scope of this article. Database design process According to Wikipedia, the term database design can be used to describe...
Troubleshooting problems with linked servers in SQL Server 2012
Troubleshooting problems with linked servers in SQL Server 2012 If you have problems with linked servers in SQL Server 2012, review this troubleshooting checklist to find potential solutions. 1. Install the latest SQL Server 2012 service pack. Because some SQL Server 2012 linked servers bugs were fixed in SQL Server service packs, you should install the latest SQL Server service...