|
|
-
|
|
This is a new error associated to BACKUP related issues and to be specific first time on this environment.
There was no setting of BACKUP COMPRESSION enabled on the SQL 2008 instance which is used by a 24/7 application, by default after the installation backup compression is off. The default behavi......
|
|
-
|
|
When you are dealing with SQL Server performance issues, not every issue can be classified as a problem for SQL Server. There are common characteristics within the issues, such as:
Ad-hoc query execution typical taking longer time.
Intermittent High CPU.
Blocking irrespective of slow ......
|
|
-
|
|
As promised SQL Server release services has done it again, a great job in
releasing SQL Server 2008 Service Pack 2. Continung from SQL-2008-CU10
blog post here, it is recommended (I say MUST) to go through the SP2 release
notes the download link confirms on :
Service Pack 2 contains upd......
|
|
-
|
|
From SQL Server 2005 version onwards database mirroring has been a good resource to provide High Availablity for the systems without having special hardware requirement.
While I was assisting at the SME lounge within Database Platform area in Tech-Ed North America conference, I had few interesting......
|
|
-
|
|
Following up from Madhivanan's blog post on Different ways to know Server's Version information here is another interesting question & replies on SSP forums lead to this post:
Hi, I want to a script based on sql server version year, because some objects are not supported in 2000. We have two ......
|
|
-
|
|
Continuing with our promise of providing you in-depth insights into latest Microsoft Technologi......
|
|
-
|
|
If you've already registered then you're probably trembling with excitement in a child-on-Xmas-Eve type way right now. But if you haven't then don't worry, it isn't too late - some of the training days are now full but we've still got space on Friday and Saturday. With almost 700 people r......
|
|
-
|
|
Whenever the new version of SQL Server is released the first thing I search for Books Online update to upgrade the local copy. In similar to that Microsoft have been releasing lot of free resources and tools that can enhance the learning experience for Developers, DBA and Architects. So here are few......
|
|
-
|
|
In the High Availability and Disaster Recovery techniques, have you ever gone through the techical case study whitepaper released by Microsoft.
They are very helpful to understand how you can define and design the existing requirement of HADR for your mission critical applications. There are certai......
|
|
-
|
|
One of the newest additions from SQL Server 2008 R2 is StreamInsight, Its high-throughput stream processing architecture and the Microsoft .NET Framework-based development platform enable you to quickly implement robust and highly efficient event processing applications.
This is helpful for the da......
|
|