This article is taken from the book SQL Server DMVs in Action. The author discusses a routine that identifies the SQL queries that are blocked as a result of competing for resources.
As a database developer or DBA there is not a lot you can do about a legitimate user sharing confidential data. However, you can minimize the risks of someone breaking into our database and browsing around to find confidential information. This article explores how you can use SQL Server features to encrypt your confidential data.
This article shares some tips on using concatenation efficiently for application development, pointing out some things that we must consider and look at when concatenating values or fields in our queries or stored procedures.
NEW! Never waste another weekend deployingDeploy SQL Server changes and ASP .NET applications fast, frequently, and without fuss, using Deployment Manager, the new tool from Red Gate. Try it now.
This is part two of an article reviewing the results of a virtualisation with SQL Server survey I performed. Part one can be found here. How do you size a new virtual server? When deploying a new virtual server you want to size it according to its predicted workload knowing that additional resource can be allocated as required. Unlike physical servers giving your virtual server more resource than it actually needs can actually be a bad thing, if nothing else if you’ve got resource you’re not using...(read more)
One of the biggest problems that a lot of people have when they are trying to get more rankings in their niche market is the fact that they can't get backlinks. If you don't get them, you are not going to be able to get high traffic rankings in your niche market. In this article I want to show you the best way to get more links so you can get more rankings in your niche market.
Search Engine Optimisation (SEO) is the term used to describe the actions a webmaster takes to improve the search engine rankings of their website - simply put, this means moving your website higher in the list in search engines such as Google, when a web user searches for the products/services you offer. This article offers a basic guide to the search engine optimisation process. Although they may help to improve rankings they are by no means all-encompassing, but rather a starting point for your SEO campaign.
If you want to get more rankings to your site you are going to have to make sure you focus your efforts on doing the one thing that will give you the most results. That one thing is link building! The more you do it, the more search engine rankings you are going to get in your market. In this article I want to show you exactly how you can get more links the right way so you can increase your rankings and traffic.
Original and unique content is viewed favourably by the major search engines and will help to drive your business higher up the search rankings. This article looks at the problems associated with duplicate website text.
Learn how you can get alerts when you centralize the Event log. This is part 2 of the previous article "How to centralize your SQL Server Event Logs."
What are your servers really trying to tell you?
Find out with new SQL Monitor 3.0, an easy-to-use tool built for no-nonsense database professionals.For effortless insights into SQL Server, download a free trial today.
I have noticed that since I have disallowed images using the robots.txt in my Joomla site, when sharing an article in Facebook, the image will not be displayed. Why is that? Is it indeed related?
My robots.txt file:
User-agent: *
Disallow: /administrator/
Disallow: /cache/
Disallow: /cli/
Disallow: /components/
Disallow: /images/
Disallow: /includes/
Disallow: /installation/
Disallow: /language/
Disallow: /libraries/
Disallow: /logs/
Disallow: /media/
Disallow: /modules/
Disallow: /plugins/
Disallow: /templates/
Disallow: /tmp/
In this article I will show how to make a basic twitter client for Windows 7 mobile. This is part 1 of the series. In this part, I will show only how to read statues of given user. In further parts, I will show Tweet, Re tweet and Direct Message functionalities.
In this article we have discussed about the process of canonicalization that was officially announced by search engines last year to optimize website to avoid indexing of duplicate contents. Further we have discussed a scenario with a real life example in which canonicalization can be helpful and then we have seen its syntax and usage.
Open Data Protocol (OData) is a web protocol which is used for querying and updating data. In this article we will see how to enable OData service in our RIA services.
There are a number of different reasons why I choose to create my own website whenever I need one, as there is simply too much that can go wrong when I trust someone else to do it. This article goes into why and the benefits of doing this.
Some people believe Off Page Optimisation (Link Building) should be 90% of your SEO strategy. This article discusses exactly why Link Building is essential in your quest for Search Engine domination.
This first article will show the manner to handle elements within the scene. Indeed, WPF provides us a very helpful class, namely the VisualTreeHelper class.
This article lists the technical and functional specifications allowing you to attain both strength and flexibility for your SaaS application. It will help you conceptualize the security of your application, taking into account important constraints from the beginning of your project. You will thus be able to cover short terms needs, while at the same time anticipation any future evolutions necessary to the development of your business.
<b>Linux Magazine:</b> "In the last article we looked at using strace to examine the IO patterns of simple serial applications. In the High Performance Computing (HPC) world, applications use MPI (Message Passing Interface) to create parallel applications. This time around we discuss how to attack parallel applications using strace."
Any online business should be attached to a vivid blogging activity in order to establish a faithful community around its product or service. This two-part article shows what it takes to gain exposure in organic listings for your own blogging platform.
Another question I get asked by new marketers is "Why are backlinks important?" This article will explain the many benefits of building backlinks and why they are a vitally important part of your off page SEO plan.
Building Backlinks is an important part of Search Engine Optimization because it is one of the most important aspects of increasing your Page Rank and will make your more noticeable in search engines. In this article you will be able to see the top ten ways to build backlinks to your site.
In this article, I am going to show step by step process of creating work items (user stories/tasks), create queries to view the work items and managing same work items using Microsoft Office Excel.