Technology Tips -SQL Server Management Studio
Showing posts with label SQL Server Management Studio. Show all posts
Showing posts with label SQL Server Management Studio. Show all posts

Sunday, October 19, 2014

As you know xml sitemap is a file based on xml tags giving url information of your site to web crawler like googlebot or bing bot etc.
If your site is hosted on web server and ideally you can create xml file using any
 Online xml sitemap generator and you could upload that file in .htaccess file  and that’s it you are done. You are ready with xml sitemap which you have created online and now you have told web crawler that hey my entire list of urls are there uploaded once you crawl browse them and display them to audience based on keywords.
But problem occurs when you are not using complete web server or let’s say you are using free hosting space where you have limited access to web server and actually you can’t upload any .htacess file. There is another way to tell web crawler about your index pages that is atom feed which is supported in blogger.

Submitting xml sitemap to blogger using Google webmaster only:

Ideally you can work with atom.xml or actually you can create that file by specifying its name atom.xml in google webmaster in order to create complete sitemap for blogger– so you don’t need to create any extra xml sitemap from other online sources etc- means where you will see date, time and modified xml tags in it.
So now we are assuming you have created xml sitemap type atom inside your blogger blog and fortunately you are dealing with custom domain as well.

People go somewhere if they want to generate xml sitemap blogger – you don’t need to go somewhere to get xml sitemap and do something with blogger. It’s a process of generating xml site map type atom using Google web master tool.
You are going to configure and create xml sitemap and configure it inside blogger using robot.txt which is used for customized entries-stopping Google to crawl some url.
Why we are using custom robot.txt file- because we don’t want some url to be crawled by Google or we don’t want to keep them in Google index. First you will generate xml sitemap using Google webmaster tool by entering simple atom.xml parameter in Google webmaster tool.

XML SiteMap for Blogger with custom urls:                      
Ideally your output could be one of the following: blog hosted on blogger
What you have done actually you have added atom.xml parameter using webmaster interface- in the sitemap section and added further parameters for all your blog posts to be indexed like in  the case above- these parameters can be used to index 500 url entries if you have 1000 or more posts entries in your blog so you can add them too – just define start index 501 and so on.
Now you have to test this sitemap too, you will do it in the same section in webmaster tool and you can define some posts that you don’t want to be indexed by Google and copy the entire chunk from there and go back to blogger.
Once you define and test your sitemap in webmaster robot.txt section so you will end up with the following chunk:

User-agent: Mediapartners-Google
User-agent: *
Disallow: /search
Allow: /

It's clearly mentioned above that your xml sitemap added as xml with 500 posts on blogger. Now you can add some more post url that you don’t want to be indexed in Disallow section and copy that above snipped and past in the blogger.
You are ready with your xml sitemap for blogger without visiting any other site -only webmaster tool and go to blogger dashboard point to setting and search preferences and past that snipped into this section called custom robot.txt. You are telling Google this is my full xml sitemap crawl and index site and there are some custom url entries.
Hope you enjoyed learning here.

Wednesday, April 7, 2010

SQL Server  2008 Management Studio is free version from Microsoft you can access, manage and administer your database, there are some limitation as Microsoft has released  sql server  management studio for free, this tools solely used by sql server developer and administrator as they could see graphical user interface once they install it and they can easily work with the database.
Ideal scenario of using sql server management studio, you have sql server running on machine A and you want to access your database from developer machine B with visual studio like you want to view data before manipulation. Then you need to install sql management studio on machine B and access you data from there.

If you want to access data that has been stored in sql server 2005 then you need this version otherwise you need SQL Server 2008 express is also a free tool if your data has been stored in SQL Server 2008.

There are different version available on Microsoft site of this free tool but recently sqlserver management studio express edition can the best choice for anyone who is going to manipulate data using this tool,but before mentioning all details I will elaborate how you can make auditing done with SQL Server 2008 and then you can find fine more details on Microsoft site.

Why audit has been very prominent in the entire life of DBA- it gives them detail about who has accessed and attempted to access your data, I will also outline few more things about regularity compliance why they are related with audit and all this.

There are many acts in the world in relation with the audit mentioned here- it means how they can monitor data stored in databases – so these compliances ensure the real audit theory as per the organization type.
SSMS can help you audit on sql server database level and sql instance level when you configure audit you have option at what level you want to trace it.

This audit is life for DBA's because they can track many events with this functionality.
You can create audit object by using ssms just point your location to security folder and right click on audit folder and create new option, and it's done.

SQL Server 2008 R2 has been supported and compliance with HIPAA, please read other article on this site for HIPAA and PCI.

Various versions of sql server management studio

there are some other versions of sql server management studio you may find -
Latest version of SQL Server management studio 2016
Along with this there are various previous version of sql server management studio by Microsoft.
Sql server management studio 2014 sp1 having some azure feature and
Sql server management studio 2012 sp3 with full feature
Sql server management studio 2008 express
Ideally you can install this client tool with the sql server running on server and if you have confusion with that which sql server is installed so simply load sql server configuration manager and click property from there you can see which version of sql server installed then you can install any client tool on any client machine in order to hook up with DB’s and other object and perform tasks.
You can also try all previous version of sql server management studio like
You can manipulate various sql server instances means is simple there are many sql server hosted instances has been installed and sql server management studio is the only tool that will help you to manage other instances on the same sql server.
So if you have ended up with correct version of sql server management studio installed along with your sql server you can easily manipulate data and DDL, DML on you relational databases.

sql server management studio
sql server management studio

we will elaborate on audit feature of sql in our next articles.
I will outline more details about audit next time but now you can download SQL Server  Management Studio from principal vendor Microsoft.

Wednesday, March 10, 2010

Sophisticated SQL Server Management Studio has many features we have outlined few new features added in SQL Server Management studio with latest release of SQL Server Management Studio 2008 R2.
Microsoft has introduced many features in it but few mentioned below.
In SSMS with 2008- Microsoft has introduced Intellisense for Query Editor Interface.
Query Editor with Intellisense functionality is oxygen for people who are writing complex queries in the editor.
This feature will make DBA’s life easier while writing query based on 100 lines; I mean lengthy query can be written easily with the intellisense functionality in Query Editor.
If you point your location in SQL Server Management Studio’s EDIT menu and then Intellisense and further you will find 5 more options there.
List Members, parameter info, quick info, complete word, refresh local cache.
MultiServer Query: a good one option for those DBA who has been facing dame problem when they have been working on multiple server, means one DBA managing more than 50 Server instances and run various queries to get the right information of each server now U need to open 50 different windows to run same command on each server, so MultiServer Query feature has made your life more easy and under one roof you can manage 50 different sql server instance and run various commands simultaneously.

Object explorer is another feature added in SQL Server Management Studio with many more options available there including this, OE result can be copied to excel and review there at later for a report type activity.

So far I could explore such feature in SQL Server 2008, please stay tuned to get to know more.

Please stay connected with this site because we are small team of MCSD, MCP and MCTS Sharepoint, have been invited by Microsoft for beta Exams, we will share our experience with you.