|
|
Senaste posterna
-
|
Ola has a set of stored procedures to do maint operations, see http://ola.hallengren.com/ . Ola has now updated them to support exclusions or inclusions of tables, indexes or even whole schemas from index rebuild/reorg. Check out http://ola.hallengren.com/Documentation.html#SelectingIndexes...(...
|
-
|
All my attempts so far to rebuild the system databases in 2008 R2 has failed. I first tried to run setup from below path: C:\Program Files\Microsoft SQL Server\100\Setup Bootstrap\Release But above turns out to be the 2008 setup program, not 2008R2 setup;...(...
|
-
|
Short answer seems to be "yes". I got this from a forum post today, so I thought I'd test it out. Basically, the discussion is whether we can somehow cut down backup sizes for filestream data (assumption is that filestream data isn't modified very frequently)....(...
|
-
|
Imagine a database mirroring setup where you have two LANs with a WAN link in between. Let's call them site A and site B. Say that principal is currently in site A, and both mirror and witness are in site B. I.e., we are running database mirroring with...(...
|
-
|
I've just updated the "Agent Alerts Management Pack" found here . I realize that some don't feel confident in reading and executing T-SQL code and they instead prefer to point & click in SSMS instead. So I added two tables with my suggestion on the...(...
|
-
|
You know the answer already: It depends. But I often see some percentage value quoted and the point of this post is to show that there is no such percentage value. To get the most out of this blog post, you should understand the basic structure for an...(...
|
-
|
This is really basic, but so often overlooked and misunderstood. Basically, we have a database, and something goes south. Can we restore all the way up to that point? I.e., even if the last backup (db or log) is earlier than the disaster? Yes, of course...(...
|
-
|
Seems like a simple enough question, right? This question (but more targeted, read on) was raised in an MCT forum. While the discussion was on-going and and I tried to come up with answers, I realized that this question are really several questions. First,...(...
|
-
|
As of today I’m moving my blog to my own WordPress installation. The blog address will still be http://blog.advisec.com but if you have an RSS reader you need to update it to http://blog.advisec.se/?feed=rss2.
Thanks for reading...
|
-
|
If you want to try the new version of DPM, you can now download the RC version. There is a couple of new features that wasn’t in the beta version, one that I know people have been waiting for – Support for workgroup machines.
Download from Microsoft Connec...
|
-
|
Yesterday Microsoft released the System Center Operations Manager 2007 R2 Cross Platform Cumulative Update 2 (KB979490). This update fixes the blow issues (plus the fixes in KB973583) The Log File provider rescans a file repeatedly if the size of the...
|
-
|
This week a updated version of the Windows Server Internet Information Services 7 was released:
2/8/2010 – Updated IIS managment pack to support monitoring Windows Server 2008 SP2 and Windows Server 2008 R2, version 6.0.7600.0
Download from Microsoft...
|
-
|
When I was at a customer, I run into two issues when configuring the Exchange 2007 MP that I thought I would share with you all: Problem 1 If your Exchange has multiple OWA virtual directories, you wont get any data in the synthetic transaction performance...
|
-
|
Yesterday Microsoft released the Cumulative Update 1 for System Center Operations Manager 2007 R2. This update included allot of fixes and is also a requirement if you plan to use the Exchange 2010 MP (Note that if you are using System Center Operations...
|
-
|
I just read in a forum about a user who want to replikate a table, but the table doesn't have a PK. The table is pretty large, and having the table not available while adding the PK is undesireable. The table has a clustered index already, and there are...(...
|
-
|
I recently read a discussion whether RPC events add overhead compared to just submitting text. I got curious and did some testing, which I want to share. Background, SQL events Using most APIs, if you just submit a query to SQL Server, you will get what...(...
|
-
|
In my previous post about using Silverlight 4 Commanding, I got a question why I didn’t use delegates etc instead of creating a lot of ICommand classes. In this post I’m going to show how you can reduce the number of ICommand classes. I have created a...
|
-
|
Note: This post is based on the WCF RIA Services VS 2008 PDC Beta and VS 2010 Beta 2 preview, changes can be done before the framework hits RTM. I have seen questions about how to dynamically create search criteria when using WCF RIA Services and LINQ....
|
-
|
This blog is not about avoiding logging in using the sa login. Hopefully we all know about this, and work towards avoidning this practice. Instead I want to talk about using sa, but not to login (authenticate), but as owner for jobs and databases. I want...(...
|
-
|
Note: This blog post will use the WCF RIA Services PDC Beta and VS2010 Preview, changes to the framework can me made before it hits RTM. Some questions that pops up about WCF RIA Services is how to enable transactions. So I decided to write a blog post...
|
-
|
One of the first things I want to do when I look at a new SQL Server is to get an idea of space usage details for each database, including total space usage. For this I have been using my own sp_db_space_usage for a while now, so I decided to add it to...(...
|
-
|
Note: The WCF RIA Services examples in this post is based on the WCF RIA Services PDC Beta for VS 2008 and VS 2010 Beta 2 Preview. I have notice that a lot of developers are passing a lot of data over the wire, like they have forgot or don’t see the network...
|
-
|
Note: Some examples in this post uses the WCF RIA Services PDC Beta, so changes can be done until it hit RTM. I have already mention about how to handle exceptions with WCF RIA Services here: http://weblogs.asp.net/fredriknormen/archive/2009/12/08/wcf-ria-services-exception-handling.aspx...
|
-
|
Note: This is post is based on the WCF RIA Services Beta for VS 2008 and changes can be done before WCF RIA Services hits RTM. There are several post on the forums about changing the default number of items passed passed from a DomainService to the client,...
|
-
|
You might just not get what you think. I would be surprised if this hasn't been blogged already, but if so, it would be worth repeating. Here's the deal (example from a forum,, slightly re-worked): I want the values in one column to be unique, assuming...(...
|
|
|
|