SqlServer-QA.net

You might be aware (from other bloggers on this site) that there is a new web-only Books Online for SQL Server 2008 available at http://msdn.microsoft.com/en-us/library/dd239407.aspx.  Like Tibor, I prefer a downloadable BOL, partly because I do a lot of research and writing while traveling and I don't always have an internet connection, ...

I have been thiking to write this topic in this blog since last 3 months, before that I have done fair amount of work to get you sensible & helpful resource in securing your SQL Server environment.  This was the question asked by one of the user when there was a discussion about securing the SQL Server code. The obvious answer is yes ...

Here is the list of information which is a Technical Rollup email we receive from TRM team. The list is ongoing and I have outlined the important ones that I feel and fits for 'generic' SQL Server environment. Make sure to review, download, test and apply to your production environment.  SQL Server 2008 Report Builder 2.0 ...

I realize probably no one reads Books Online cover to cover, so there are probably lots of little details that easily slip by you. I was introduced to one of the hidden 'features' just last week. Here it is: CHECKPOINT can take a parameter! It's right there in BOL:  CHECKPOINT [ checkpoint_duration ] This parameter allows you to specify ...

I realize probably no one reads Books Online cover to cover, so there are probably lots of little details that easily slip by you. I was introduced to one of the hidden 'features' just last week. Here it is: CHECKPOINT can take a parameter! It's right there in BOL:  CHECKPOINT [ checkpoint_duration ] This parameter allows you to specify ...

In continuation with the BOL update topic on SQL2008-RC0_BOL post here I have had troubles in installing the RC0 Books Online on to my laptop. As per the error below I thought it may be problem with the Windows Installer service on my laptop (Vista Ultimate) and tried to install afresh on a central monitoring server (Windows 2003 server) ...

As in continuation with the latest release of SQL Server  2008 that is Release Candidate, I strongly recommend you update your local copies of SQL Server Books ONline aka BOL. Here is the link to download the latest copy of SQL Server 2008 RC0 BOL - Link_to-Download and also I recommend the SQL Server 2008 ...

In the past week SQL Server 2008 RC0 has been made available for early download by MSDN and TechNet Plus subscribers. RC0 is the final step before SQL Server 2008 RTMs in Q3 of this year. After logging into their respective accounts, subscribers can view Product Keys and download SQL Server 2008 RC0 from the following links: MSDN subscribers: ...

It is 1 year (first anniversary) that SQL Server 2008 Community Technology Preview is released, I have seen many good things and few peeves about this new version of SQL Server. Not to mention about largest conference is lined up for the users aka 'Tech-ed 2008' which is a huge learning opportunity too. So what you have learned from last 4 ...

Have you ever seen or used the PowerShell? If so have you worked on PowerShell within SQL Server 2008, it has 2 kinds of snap-ins that are called as Powershell Provider and set of Cmdlets. The provider will enables the simple navigation mechanism similar to file system paths, within that associated to SQL management object model and ...