jump to navigation

ODBC Survey by MSFT February 23, 2010

Posted by msrviking in General.
add a comment

Why don’t you take survey on ODBC support on non-msft platforms over here?

Advertisements

Ask the core team? February 18, 2010

Posted by msrviking in DB Administration.
add a comment

I was doing morning rituals (reading blogs of my blog roll) and got a reference from Grumpy Old DBA to this interesting blogging site. If you want to know how Windows work SQL Server and much more beyond that, then why not visit this.

Cheers!

Name That Caption Contest February 3, 2010

Posted by msrviking in DB Administration.
add a comment

Tom LaRock is conducting an interesting contest over here. My captions would be

“I am done with my work today,  here is what I want to do for tomorrow?”.

“How do I achieve 99.99% SLA with all these jokers around?”.

“What is that I should budget for this year?”.

“How do I fly between these tall buildings?”

SSAS named instance February 2, 2010

Posted by msrviking in Security.
add a comment

Here is what I have learnt today while configuring a static port for a named instance of AS for one of my clients.

As per best practices for Security guidelines given by MSFT, SQL Server Browser could be disabled and to connect to named instance of Analysis Services we would need a static port. It was fun doing this although there are good steps around in BOL, and few other links.

However for benefit of having this stored in a knowledge repository I decided to list down steps clearly in here.

1) Goto SQL Server configuration manager and over the named instance in the SQL Protocols, click on the TCP/IP.

2) Under protocol table make the “Listen All” to “No”.

3) Under IP Addresses tab, make “TCP Dynamic Ports” to blank from “o” for IP1, “Enabled” value to “Yes”. Also don’t forget to put in a value “TCP Port”.

4) Under IP 2, set “Enabled” to “No”, and in IP All set TCP Dynamic Ports to blank from “o”, and the TCP Port to the port number you want listen.

5) And before restarting the service ensure that you put the port number you want to listen in the server property page of analysis services.

At the end restart the service, and you will have the analysis services named instance up and running, and connecting on your defined port without SQL Server Browser service running.

Some of the links that gave me leads are

http://dinesql.blogspot.com/2009/08/connecting-to-analysis-services-with.html
http://blogs.msdn.com/sqlserverfaq/archive/2009/09/08/sql-server-analysis-services-port-sql-2005-2008.aspx
http://support.microsoft.com/kb/823938
http://msdn.microsoft.com/en-us/library/cc966526.aspx

I hope this quick post helps. Enjoy!

MSFT SQL Server blog’s February 1, 2010

Posted by msrviking in Technical Documentation.
add a comment

Glenn Berry has posted an entry on MSFT SQL Server blogs on BI & Relational Database. Please ensure that you have these blogs on your blog roll and of course don’t forget to include Glenn Berry’s in the list.

Enjoy!

SQL Bits (Nov’09) videos February 1, 2010

Posted by msrviking in Technical Documentation.
1 comment so far

I work out of India and unfortunately I don’t have opportunity to attend sessions like SQL Pass, SQL Bits. But I keep track of the happenings, and also wait for any freebies like recorded sessions, slide decks, documentation, conversations and so on. Recently SQL Bits has posted the recorded sessions of SQL Bits conducted during Nov’09. Some of my favorite speakers and the topics have been top picked by me from here. So go ahead, download or hear the sessions online and learn!

SQL Pass 2009 February 1, 2010

Posted by msrviking in Training.
1 comment so far

Although I couldn’t manage going to SQL Pass 2009 held in Seattle, WA, USA but I kept track of all the live blogging that happened by several MVP’s and others who had attended. One of the key things I was waiting for was this, and this is not the full list instead is the best picks. If you want a whole version of the technical gathering “Mela! of SQL Server Professionals” you could get it here.

Enjoy!