Standard Members

Pro Members SQL Server Standard Members

Some tips for using SQL Server 2012 Database Console Commands

Some tips for using SQL Server 2012 Database Console Commands Try to run the DBCC commands when there are no other disk I/O operations, such as disk backups, replication and so on. Use DBCC CHECKFILEGROUP instead of DBCC CHECKDB, if you need to check only specified filegroup, not entire database. If your database contains several filegroups and you need to...

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

Using SharePoint to Automate Workflows-Part II

Sequential Workflows A sequential workflow—as the name suggests—represents a sequence of events that follow one upon other and each event is triggered by the outcome of the previous event. As a consequence, the start of a fresh event must wait the completion of the previous event. SharePoint allows users attach business processes to workflows and organize the sets of activities...

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

SQL Server Monitoring and Optimization (Part 1)

SQL Server monitoring and optimization – (Part 1) Author: Basit A. Farooq To optimize the performance of your database, you need to monitor and tune. You determine the performance baseline, how SQL Server is currently performing, through monitoring. Your optimization process includes making changes and then monitoring their effect. This means adjusting two overlapping performance areas, that is, database server...

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

Picking the Right Cloud Stack for Your Cloud

Picking the Right Cloud Stack for Your Cloud If you have decided to move to the cloud, the first question that you will have to ask yourself: “what will you be moving to the cloud?” The next question will be about the arrangement or modeling of the stack. This is an important question, because reversing the process of stacking is...

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

SQL Server Encryption Options – Part 2

SQL Server Encryption Options – Part 2 Author: Basit A. Farooq Editiors Note: In the first part of this article series, I discussed the options for encrypting connections and learn concepts on how to encrypt confidential data in the database. In this second part, I will show you how to encrypt data using cell-level encryption, and how to encrypt database...

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

How to Keep New Employees

How to Keep New Employees Hello, this is Laura Lee Rose – author of the books TimePeace: Making peace with time– and the Book of Answers: 105 Career Critical Situations. I am a business and efficiency coach that specializes in professional development, career management, time management, and work-life balance strategies. Today we are going to talk about how to keep...

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

Troubleshooting problems with connection to SQL Server 2012

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

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

SQL Server Encryption Option – Part 1

SQL Server Encryption Options – Part 1 Author: Basit A. Farooq Many database servers store confidential data, which must be protected from unauthorized access when it’s transmitted across the network and stored on the server. SQL Server provides support for encrypted connections, encrypting data, encrypting database and for encrypted storage. In this first part of this article series, I’ll discuss...

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

How to Repair a Damaged Relationship with Your Boss

How to Repair a Damaged Relationship with Your Boss Hello, this is Laura Lee Rose – author of the books TimePeace: Making peace with time – and the Book of Answers: 105 Career Critical Situations. I am a business and efficiency coach that specializes in professional development, career management, time management, and work-life balance strategies. Today we are going to...

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

Working with LINQ to Entities

Working with LINQ to Entities The ADO.NET Entity Framework enables you to raise the level of abstraction by isolating your application’s relational model from the object model. Added to what a typical ORM provides, it enables identity resolution, chance tracking, entity inheritance, entity composition, etc. The Entity Data Model (commonly known as EDM) is the core of the Entity Framework....

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