If you look back to hundred years or more, you will come to know that at that time the society was very reserved and there was no way to take the help of the online search engine. In the sphere of business, people had to depend on the old fashioned advertising tools for making the propaganda of their products.
Microsoft released versions of SQL Server 2008 R2 products to IT professionals on Monday....Did you know that DotNetSlackers also publishes .net articles written by top known .net Authors? We already have over 80 articles in several categories including Silverlight. Take a look: here.
Of course one big pro is the amount of syntactic sugar leading to shorter code in a lot of cases. On http://jashkenas.github.com/coffee-script/ there are impressive examples. On the other hand I have doubts that these examples represent code of complex real world applications. In my code for instance I never add functions to bare objects but rather…
This blog post is inspired from SQL Queries Joes 2 Pros: SQL Query Techniques For Microsoft SQL Server 2008 – SQL Exam Prep Series 70-433 – Volume 2.[Amazon] | [Flipkart] | [Kindle] | [IndiaPlaza]
This is follow up blog post of my earlier blog post on the same subject - SQL SERVER – Introduction to Hierarchical Query using a…
SQL Wait Stats
About a year ago, I had very proud moment. I had published my second book SQL Server Wait Stats with me as a primary author. It has been a long journey since then. The book got great response and it was widely accepted in the community. It was first of its kind of book written specifically on Wait Stats and Performance. The…
I'm having a hard time finding information about whether implementing ipv6 or using a stretched vlan is a better option for geographically dispersed sites is better. Does anyone know:
Problems with stretched vlans (mac address broadcasting etc)
costs for devices to solve those problems
pros for using IPv6 instead
EDIT. What I am…
My friend Rick Morelan is a wonderful speaker and listening to him is very delightful. Rick is one of the speakers who can articulate a very complex subject in very simple words. Rick has attained over 30 Microsoft certifications in applications, networking, databases and .NET development, including MCDBA, MCTS, MCITP, MCAD,…
It has been quite a long time since I posted SQL in Sixty Seconds Video. Here we are back with the new video.
One of the most popular question, I often receive is very similar to following:
“How do I reset the password for SA username?”
“I have forgotten the SA password, what should I do?”
“Our DBA just left the job and now noone…
Fans of this blog are aware that I have recently released my new books SQL Server Functions and SQL Server 2012 Queries. The books are available in market in limited edition but you can avail them for free on Wednesday Nov 14, 2012. Not only they are free but you can additionally learn SQL Server 2012 Error Handling as well.
My…
There are multiple reasons why a user may want to make a copy of the database. Sometimes a user wants to copy the database to the same server and sometime wants to copy the database on a different server. The important point is that DBA and Developer may want copies of their database for various purposes. I copy my database for…
Is in a bit of disagreement with a more experienced developer on this issue, and was wondering what you guys here think about this. Environment is Java, EJB 3, services, etc.
The code I wrote calls a service to get things and to create things. Problem was that I got null pointer exceptions in places that didn't make sense. For…
i have stumbled upon these GUI tools that could help you manage your linux server through a web interface.
ebox, webmin, ispconfig, zivios, ispcp, plesk, cpanel etc.
i wonder what the pros and cons are with these solutions.
a lot of people is saying that they are not as good as using pure command line (ssh) to manage your…
Related
Using SO as an example, what is the most sensible way to manage tags if you anticipate they will change often?
Way 1: Seriously denormalized (comma delimited)
table posts
+--------+-----------------+
| postId | tags |
+--------+-----------------+
| 1 | c++,search,code |
Here tags are comma…
Pros & Cons of Google App Engine
[An Updated List 21st Aug 09]
Help me Compile a List of all the Advantages & Disadvantages of Building an Application on the Google App Engine
Pros:
1) No Need to buy Servers or Server Space (no maintenance).
2) Makes solving the problem of scaling much easier.
Cons:
1)…
Question
Is it a good rule of thumb for database IDs to be "meaningless?" Conversely, are there significant benefits from having IDs structured in a way where they can be recognized at a glance? What are the pros and cons?
Background
I just had a debate with my coworkers about the consistency of the IDs in our…
Hi guys,
I've got an Xserve where I've configured a Drobo Pro. Connected via firewire and USB, it works fine, but when connected to a separate network port, it doesn't mount. I've got the Drobo Pro configured to 2.0.1.2/255.255.0.0 and the network port to 2.0.0.1/255.255.0.0. I can ping the IP of the Drobo Pro…
We are a medium-large non-profit company, with around 1000 staff and volunteers, and have been using MS Exchange (currently 2003) for our mail system for years.
I recently attended a Google conference where they were positing that "Cloud computing is the way of the future", and encouraging us to switch from…
I run two completely independent websites. I am moving their MySQL databases to Amazon RDS.
I'm not going to do Multi A/Z deployment - let's remove that variable from this question.
I'm not sure whether to create a single RDS instance with two databases, or two Amazon RDS instances with a single database.…
A little off the wall perhaps, but ...
I have a cable modem and a router for a wireless home network. Is it a good or a bad idea to turn it off at night and during the day when we're all at work or school? Or should I leave it on 24/7.
I was thinking that leaving it on constantly makes me more vulnerable to…
I'm working with a web app that uses two machines, a BSD server and a Windows 2000 server. When someone goes to our website, they are connected to the BSD server which, using Apache's proxy module, relays the requests & responses between them and the web server on the Windows server. The idea (designed…