-
Welcome to my first post in a series of "Must Knows" for SharePoint 2010. Since you cannot install SharePoint 2010 without a SQL Server, this fist part is about what people should know about SQL Server before installing SharePoint 2010. And of course before installing the SQL Server. This post...
-
This week I installed SQL Server 2008 R2 November CTP on my Windows 7 workstation. Because I want to delve somewhat deeper in building reports for SQL Server, I also installed the SQL Server Reporting Services. The installation went incredibly smooth and the configuration through Reporting Services Configuration...
-
The topic of the evening is SQL Server Service Broker and some of the things it can do for you . The session will cover the terminology and features of this framework, as well as discuss some of the scenarios in which it can be used, to round off we will be implementing a small service broker application...
-
Recently, I was responsible for the migration of a SQL Server 2000 server to a new installation of SQL Server 2005. This installation resided on another server. Most applications were easy to adjust to the new SQL Server name. For SMS 2003, it should be easy to configure a new database server by using...
-
We had an annoying problem while performing Windows Updates on the Windows Server 2008 Failover cluster at a customer. While testing the failover, we saw that the SQL Server 2005 cluster resource failover did not succeed. The strange thing was that nothing in the configuration had changed since previous...
-
As most of you will know, Reporting Services is not fully supported on a SQL Server cluster. More information can be found here: http://www.microsoft.com/dynamics/crm/using/deploy/clusteringssrs.mspx However, not supported does not mean not possible. I decided to experiment in my testing environment...
-
On Thursday, the 3rd of December 2009 SQLUG.BE (The Belgian SQL Server User Group) and Microsoft are teaming up to organize the second Belgian SQL Server Day. Focus of the day is off course SQL Server. Last year, SQL Server Day 2008 was the biggest community driven SQL Server event in the Benelux, with...
-
As you all know, in SQL Server (any version actually) you have the options "Auto Create Statistics" and "Auto Update Statistics". By default this is enabled (these parameters are set to true on the model database and thus to all newly create databases). So, what happened? At a customer...
-
Just one recommandation: do NOT use this. Lately I was at a customer who had scheduled the Shrink task every morning by using a maintenance plan. Since their SQL Server installation earlier that year they suffered from decreasing performance. Deleting this task and performing a rebuild of the index of...
-
Hello there, Before ranting about IT, a proper introduction seems fit. My name is Gert Lievens and I'm here to share some of my experiences related to SharePoint and SQL Server ... stuff :) Besides IT, I spend a lot of time: - Watching movies - Playing games - Going out - Listening to music - Reading...
-
This UG-evening will start with an introduction of the basics of index design (the heap,clustered/non clustered indexes and covering of a query by an index). Later we will discuss how the optimizer works, why it can be wrong (statistics, procedure cache) and how to correct this. Another part of the session...
-
Old news already (but since everyone was on holiday during most of December): SQL Server 2005 Service Pack 3 was released on December 15. You can download it here . Since you're downloading anyway, don't forget to download the update version of the SQL Server 2005 Books Online. You can download...
-
Hi! Just did another implementation of a DELL Equallogic PS5000XV iscsi array which is very nice and powerfull equipment well suited for the virtualisation project I'm currently working on. I just had a "few thingies" I wanted to try out offline so I booted up my virtual lab and started...
Posted to
Scratch The Surface
by
Bart Bultinck
on
10-26-2008
Filed under:
Filed under: SQL, SQL Server, virtual server, exchange 2007, windows server 2003, DFS, windows server 2008, Hyper-V, SQL SERVER 2008, SCDPM 2007, System Center Stuff, DPM 2007, SCVMM, fun
-
This Data Protection Manager Update Package consists of three separate updates. To install each update, follow these steps: Install the hotfix rollup package on the server that is running Data Protection Manager 2007. To do this, run the DataProtectionManager2007-KB949779.exe file on the server. Note...
-
Today I was searching some more information about why you should NOT use Auto-Shrink on your SQL Server databases. This primarily to prove my point to a customer . Then I bumped into this great post by Paul Randal , about never turning on Auto-Shrink. This post has been online for a while (November 12th...