Pro Members

Pro Members SQL Server Standard Members

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...

This content is for Pro, Pro Member, Pro Member Annual - Fall Sale, Pro Member Monthly - Fall Sale, Standard, Standard Member, Standard Member Annual - Fall Sale, and Standard Member Monthly - Fall Sale members only.
Log In Register
Oracle Pro Members Standard Members

Multi-level Aggregation

Multi-level Aggregation You perform a multi-level aggregation when you need to combine data from different levels of aggregation. In this article, you’ll look at an example of how you might perform a multi-level aggregation within a single SQL query that contains subqueries, sending the aggregated data from the inner to the higher level of the query and combining the aggregated...

This content is for Pro, Pro Member, Pro Member Annual - Fall Sale, Pro Member Monthly - Fall Sale, Standard, Standard Member, Standard Member Annual - Fall Sale, and Standard Member Monthly - Fall Sale members only.
Log In Register
Development Pro Members Standard Members

Using SharePoint to Automate Workflows-Part III

Using SharePoint to Automate Workflows-Part III Before you start your project check whether you have the following applications installed: .NET Framework 3.0 or above Runtime Visual Studio 2005 Professional Edition Windows Workflow Foundation extensions for Visual Studio 2005 Windows Communication Foundation (WCF, formerly Indigo) & Windows Presentation Foundation (WPF, formerly Avalon) –Optional Open Visual studio and Create a Sequential Workflow...

This content is for Pro, Pro Member, Pro Member Annual - Fall Sale, Pro Member Monthly - Fall Sale, Standard, Standard Member, Standard Member Annual - Fall Sale, and Standard Member Monthly - Fall Sale members only.
Log In Register
Development Pro Members Standard Members

Rebuild Confidence After You’ve Been Out of Work for Some Time

Rebuild Confidence After You’ve Been Out of Work for Some Time 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. Stephen...

This content is for Pro, Pro Member, Pro Member Annual - Fall Sale, Pro Member Monthly - Fall Sale, Standard, Standard Member, Standard Member Annual - Fall Sale, and Standard Member Monthly - Fall Sale members only.
Log In Register
Pro Members SQL Server Standard Members

Database capacity planning and management – (Part 2)

Database capacity planning and management (Part 2) Author: Basit A. Farooq In this article, I will layout the Software and Hardware options that are available for configuring your storage media in Windows 2003/2008/2012. Finally, I will be give you few tips on how achieve optimal database performance by physically distribute your database files on storage media. Storage Options There are...

This content is for Pro, Pro Member, Pro Member Annual - Fall Sale, Pro Member Monthly - Fall Sale, Standard, Standard Member, Standard Member Annual - Fall Sale, and Standard Member Monthly - Fall Sale members only.
Log In Register
Pro Members SQL Server Standard Members

Tips for using SQL Server 2012 database settings

Tips for using SQL Server 2012 database settings To change the database settings, you can use the ALTER DATABASE SET Options or you can use the graphical user interface (GUI). To change the database settings using GUI, you can do the following: – In Object Explorer, connect to an instance of the SQL Server Database Engine, and then expand that...

This content is for Pro, Pro Member, Pro Member Annual - Fall Sale, Pro Member Monthly - Fall Sale, Standard, Standard Member, Standard Member Annual - Fall Sale, and Standard Member Monthly - Fall Sale members only.
Log In Register
Oracle Pro Members Standard Members

Combining Aggregated Data With Inline Views

Combining Aggregated Data With Inline Views If your responsibility is to compose the queries producing aggregated data, you no doubt know that it’s not always possible to get the job done with a simple query – a one that contains subqueries, such as inline views, may be required. This article illustrates how you might use inline views as a way...

This content is for Pro, Pro Member, Pro Member Annual - Fall Sale, Pro Member Monthly - Fall Sale, Standard, Standard Member, Standard Member Annual - Fall Sale, and Standard Member Monthly - Fall Sale members only.
Log In Register
Development Pro Members Standard Members

7 Speaking Tips for Introverts

7 Speaking Tips for Introverts 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. Stephen Wynkoop and I regularly meet on...

This content is for Pro, Pro Member, Pro Member Annual - Fall Sale, Pro Member Monthly - Fall Sale, Standard, Standard Member, Standard Member Annual - Fall Sale, and Standard Member Monthly - Fall Sale members only.
Log In Register
Pro Members SQL Server Standard Members

Database capacity planning and management – (Part 1)

Database capacity planning and management (Part 1) Author: Basit A. Farooq As part of the planning and research before implementing new SQL Server, you must determine the amount of space needed for your database and how it should be organized in the SQL Server. You also need to understand the properties of the database and how to manage the growth...

This content is for Pro, Pro Member, Pro Member Annual - Fall Sale, Pro Member Monthly - Fall Sale, Standard, Standard Member, Standard Member Annual - Fall Sale, and Standard Member Monthly - Fall Sale members only.
Log In Register
Pro Members SQL Server Standard Members

Troubleshooting SQL Server 2012 Merge Replication

Troubleshooting SQL Server 2012 Merge Replication If you have problems with SQL Server 2012 merge replication, review this troubleshooting checklist to find potential solutions. 1. Install the latest SQL Server 2012 service pack. Because some SQL Server 2012 merge replication bugs were fixed in SQL Server service packs, you should install the latest SQL Server service pack. At the time...

This content is for Pro, Pro Member, Pro Member Annual - Fall Sale, Pro Member Monthly - Fall Sale, Standard, Standard Member, Standard Member Annual - Fall Sale, and Standard Member Monthly - Fall Sale members only.
Log In Register