Browse by Tags

All Tags » sql server » msdn (RSS)
SQL Server databases - checkpoint, cache and I/O request - what you need to know?
Published 22 April 8 1:51 PM | SSQA.net
Have you ever wondered about flushing databases? Well not quite possible to flush it straight away and not a best practice too on the live server, so what it is about and you need to know about transactions state when they occur. Say when the changes...
Filed under: , , , , , , , , , , ,
Microsoft Empower Program - good deal for ISVs
Published 28 February 8 4:11 AM | SSQA.net
Microsoft has rolled out new program called - Empower Program that will enable the ISVs to receive software, support and additional resources designed to help you lower your development costs, test your software and speed your solution's time-to-market...
Filed under: , , , , , , , , , , , ,
Few hours to go for Windows Server, Visual Studio and SQL Server 2008 launch, here is big deal on SQL release date!
Published 27 February 8 2:1 AM | SSQA.net
I have been following Dan Jones's blog on " Launch_T-1 , Launch_T-3 & Launch_T-5 " series about SQL Server Launch in US (PST), as a Development Program Manager they have huge task ahead to complete and its not that easy to manage as...
Filed under: , , , , , , , , ,
SQL Server indexing - when to reorganize or rebuild?
Published 21 January 8 4:30 AM | SSQA.net
Re-organizing or rebuilding index would help the SQL optimizer to reduce the fragmentation for a better performance. In this case few users might have doubt that when to rebuild or reorganize (SQL Server 2005)? IN the series of Performance blog posts...
Filed under: , , , , , , , , , ,
SQL server Temporary Tables, Table Variables and Recompiles - interesting scenario
Published 17 January 8 2:23 AM | SSQA.net
Usage of Temporary tables or variables is a common scenario in SQL Server world, since SQL Server 2005 usage of TEMPDB references to the blog posts here: http://sqlserver-qa.net/blogs/tools/archive/2007/04/05/sql-server-index-optimization-best-practices...
Filed under: , , , , , , , , , , , ,
New whitepaper available on Analysis Services Many-to-Many Dimensions: Query Performance Optimization Techniques
Published 2 January 8 6:36 AM | SSQA.net
Got this update from SQLCAT blog on MSDN about new whitepaper on Analysis Services many-to-many dimensions that helps in MDX query performance optimization steps you need to take care. Many-to-many dimension relationships in SQL Server 2005 Analysis Services...
Filed under: , , , , , , , ,
SQL Server 2005 Reporting Services best resource for beginners
Published 28 December 7 6:0 AM | SSQA.net
What I like within the SQL Server Reporting Services is using RDL for own formatted reports, as this gives you the complete freedom to build your own reporting designer tool, if you are not experienced in using Visual Studio based report designer or crystal...
Filed under: , , , , , , ,
SQL Server 2005 Service Pack 2 Cumulative Update 5 instalment available for download with a request to CSS!
Published 27 December 7 2:2 AM | SSQA.net
From the series of the SQL Server 2005 Service Pack2 Cumulative Update packages blogs and for instance we blogged about SQL2005SP2CU5 earlier, it is available to download now and before that there is a catch to obtain this package. It is not that easy...
Filed under: , , , , , , , , , , ,
SQL Server 2005 Cumulative Update 5 for Service Pack 2 - available for download with a request to CSS!
Published 24 December 7 4:42 AM | SSQA.net
From the series of the SQL Server 2005 Service Pack2 Cumulative Update packages blogs and for instance we blogged about SQL2005SP2CU5 earlier, it is available to download now and before that there is a catch to obtain this package. It is not that easy...
Filed under: , , , , , , , , , , , ,
SQL Server 2005 Books Online September 2007 available for download - update your local copy
Published 18 December 7 4:25 AM | SSQA.net
As we blogged much on Books Online importance and recent changes to availablility of updated books online for SQL Server 2005 under BOL-Sep2007-MSDN-Technet the same update is available to download. Do not forget to update your local copies as it will...
Filed under: , , , , , , , ,
Rename a SQL Server instance, a little catch
Published 14 December 7 4:4 AM | SSQA.net
Can I rename an instance of SQL Server after I have already installed it on the computer? Simple answer is Yes and you can change the name of an instance as long as the server is not clustered. There is a little catch between 2000 and 2005 version, by...
Filed under: , , , , , , , , ,
MSDN labs - Developing a SQL Mobile Application with Visual Studio 2005 and SQL Server 2005
Published 11 December 7 10:11 AM | SSQA.net
Sometime ago I have blogged about MSDN labs- SQL Server Virtual Labs - fully featured virtual environment for testing! and I recommend and encourage all of my users to use Virtual labs and webcasts - use them for a better practice on product . Similar...
Filed under: , , , , , , , , ,
How to find whether that service pack file is a 32 bit or 64 bit?
Published 1 November 7 6:44 AM | SSQA.net
Whenever a service pack is released it will be available for 32-bit and 64-bit that also includes for SQL Express 2005 edition too, as it was for MSDE earlier. Since last year (I think) Microsoft Development team has adopted a standard in naming schema...
Filed under: , , , , , , , , , ,
Rename a SQL Server instance, is it possible?
Published 2 October 7 4:11 AM | SSQA.net
Another common question on the forums, may be not a frequently performed task and as a DBA you should discourage in performing such actions. Microsoft SQL development team has already documented the information over the KBA 303774 and for the server name...
Filed under: , , , , , , , ,
SQL Server 2005 Books Online update - September 2007 on MSDN & Technet
Published 29 September 7 9:49 AM | SSQA.net
SQL Server version 2005 Books Online aka BOL has been updated by SQL Development Team in September 2007 and not available for download yet. As usual they are awaiting customer feedback from the BOL or via MSDN/Technet pages. Refer in their words: In the...
Filed under: , , , , , , , , , ,
Other blogs we recommend
Published 12 September 7 5:22 AM | SSQA.net
Today I have started a new section here "Other Blogs we recommend" to roll the blog posts from SQL Server Experts such as Kalen Delaney, Kimberley Tripp, Bob Beauchemin and Paul Randall that I follow regularly. Until now I used to blog roll...
Filed under: , , , , , , ,
Microsoft ASP.NET Connections, Visual Studio Connections, SharePoint Connections, Mobile Connections, Architect Connections, and SQL Server Magazine Connections
Published 31 July 7 12:27 PM | SSQA.net
Event: Microsoft ASP.NET Connections, Visual Studio Connections, SharePoint Connections, Mobile Connections, Architect Connections, and SQL Server Magazine Connections When: November 5 - 8, Las Vegas, NV Dive hard into current and future releases from...
Filed under: , , , , , , , ,
Interesting point on SET OPTIONS in SQL Server 2005
Published 19 July 7 1:53 PM | SSQA.net
Cross post from KalenDelaney-SQLBlog content, very interesting!...( read more ) Read More...
Filed under: , , , , , , ,
ASP.NET & MSDN - How Do I series
Published 17 July 7 8:18 AM | SSQA.net
Speaking of ASP.NET, MSDN is now offering the ASP.NET "How Do I" video series , with dozens of videos designed for all ASP.NET developers, from the novice to the professional. If you are new to ASP.NET, you can learn the basics of how to create...
Filed under: , , , ,
Having 'black-box' recorder for SQL Server!
Published 2 July 7 3:34 AM | SSQA.net
Say you have a serious performance problem and few times you will have assertion issue with a dump files creation, in real world say this can be matched to a airplane crash. Where you will know the sequence of events from Black-box records in the flight...
Filed under: , , , , , ,
More Posts Next page »