Feed on
Posts
Comments

Archive for the ‘SQL Add-On’ Category

It was not possible to connect SQL Server 2008 to Visual Studio 2005 so far. Microsoft has released Service Pack once it is installed SQL Server 2008 can be connected to Visual Studio 2005.
Download Microsoft Visual Studio 2005 Service Pack 1 Update for Microsoft SQL Server 2008 Support
For connecting SQL Server 2008 to Visual Studio [...]

Read Full Post »

Quite often it happens that SQL Server Management Studio’s Dropdown box is cluttered with many different SQL Server’s name. Sometime it contains the name of the server which does not exist or developer does not have access to it. It is very easy to clean the list and start over.

Delete mru.dat file from following location.
For [...]

Read Full Post »

The CTP version of SQL Server 2005 Service Pack 3 (SP3) is now available. You can use these packages to upgrade any of the following SQL Server 2005 editions:

Enterprise
Enterprise Evaluation
Developer
Standard
Workgroup

For a summary list of What’s new in SQL Server 2005 SP3 CTP, review the What’s New document.
These packages have been made available for general testing [...]

Read Full Post »

Very frequently I have been asked to create a page, post or article where in one page all the important concepts of SQL Server are covered. SQL Server 2008 is very large subject and can not be even covered 1000 of pages. In daily life of DBA there are few commands very frequently used and [...]

Read Full Post »

Microsoft SQL Server 2008 Reporting Services Report Builder 2.0 supports the full capabilities of SQL Server 2008 Reporting Services including flexible report layout, data visualizations and richly formatted text. The download includes the following functionality above the RC0 release of Report Builder:

Easy to use wizards for creating table, matrix and chart data regions.
Support for directly [...]

Read Full Post »

Microsoft SQL Server 2008 Express with Tools
Microsoft SQL Server 2008 Express with Tools (SQL Server 2008 Express) is a free, easy-to-use version of SQL Server Express that includes graphical management tools. SQL Server 2008 Express provides powerful and reliable data management tools and rich features, data protection, and fast performance. It is ideal for small [...]

Read Full Post »

While developing often my developers need to know which IP address is of local network when looked from outside. I am working in large outsourcing company and we have local intranet setup. When connecting to remote servers from local system or from remote servers to local system we always want to know our Live IP [...]

Read Full Post »

SQL Server licensing and pricing are to intervined subjects and very important. I strongly suggest to use properly licensed SQL Server in any production environment. The concept of licensing can be confusing sometime to new administrators. If there is any confusion one should read following documentation from Microsoft for the purpose of clear idea and [...]

Read Full Post »

SQL Server 2008, the latest release of Microsoft SQL Server, provides a comprehensive data platform. Books Online is the primary documentation for SQL Server 2008. The Help viewer used by Books Online requires the Microsoft .NET Framework version 2.0.
Books Online includes the following types of information:

Setup and upgrade instructions.
Information about new features and backward compatibility.
Conceptual [...]

Read Full Post »

Just a day ago I received question from reader who just installed SQL Server 2008. After installation user did not find any samples database along with installation. User want to install samples database which he is very much used to.
Sample database are now moved to Microsoft’s opensource site of Codeplex. Visit following link to visit [...]

Read Full Post »

Sometimes things just go very convenient and we wish that how come it was not available in earlier versions.
Let us see two features here. If it was SQL Server earlier versions we might have to write more lines to achieve what we can achieve in lesser lines. Following small example with only one variable demonstrates [...]

Read Full Post »

After reading my previous article about SQL SERVER - 2008 - High Availability - Hot Add CPU the same developer who suggested Hot Add CPU asked me if there are any restrictions in Hot Adding Memory.
Yes, there are few restictions to Hot Add Memory as well. I am listing them here.
1) Underlying hardware is always [...]

Read Full Post »

One of team member suggested that we should upgrade to SQL Server 2008 because its new feature is very cool “Hot Add CPU”.
Yes, I agree it is very cool feature. I am eagerly waiting for RTM of SQL Server 2008 so I can upgrade our servers to SQL Server 2008. However, to use the feature [...]

Read Full Post »

I have received quite a few inquires if Microsoft is going to release SP3 for SQL Server or not?
Yes! Microsoft is going to release SP3 very soon. The exact date is not announced yet. You can read the announcement of SP3 here.
Reference : Pinal Dave (http://www.SQLAuthority.com)

Read Full Post »

I recently receive question from one of the blog reader that he is having problem creating database in Windows Vista. Read original comment here.
I have installed vista ultimate and sql server 2005 devloper edition in my computer.I also connect sql 2005 in window authentication but when I CREATE any database in following query
CREATE DATABASE MANEESH
USE [...]

Read Full Post »

One of the most popular request I have received on this blog is to create one page which list all the SQL Server FAQs. SQL Server technology is very broad as well very deep. This is my humble attempt to list few of the daily used details in one page. Let me know your opinion [...]

Read Full Post »

I enjoy reader’s articles to read as much as I enjoy expert’s articles. One of blog reader Praveen Barath always have good ideas to share. Here is Praveen Barath’s comment on my previous article Query Analyzer Shortcuts.
MSSQL server 2005 is a database platform , Platform because from one window you can connect to any of [...]

Read Full Post »

Read my article published at SQL Server Magazine Surface Area Configuration Tools Reduce Exposure To Security Risks

Read Full Post »

I am very pleased to write my 500th post. After 500 posts, I still have same feeling when I wrote first post on this blog. I would like to thank my family for their continuous support in writing this blog. Most of all I want to thank all of YOU for being wonderful readers of [...]

Read Full Post »

System Center is Microsoft’s family of systems management solutions designed to make IT more productive and efficient by allowing the IT department to apply best practices to systems management, deployment, and data protection.
System Center Operations Manager 2007

Inventory discovery and management
Events and alerts display
Multiple views ready to use out-of-the-box

System Center Configuration Manager 2007

Deploy consistent instances of [...]

Read Full Post »

Older Posts »