|
|
|
|
Browse by Tags
-
I've been learning a few things about troubelshooting login problems over the last few months. I first want to say that I've learned most of this through other blogs, comments etc. At the end of this blog post you will find an URL list where you can look Read More...
|
-
Frank Kalis has been kind enough to translate my datetime article ( http://www.karaszi.com/SQLServer/info_datetime.asp ) to German. I updated my article a while ago to reflect the new date and time related types in SQL Server 2008, and I just learned Read More...
|
-
Fire up your SQL Server 2008 Books Online (BOL) and check the date. You should find this in any article (except for the very start page). RTM of SQL Server 2008 shipped with a BOL which has ... hmm,... doesn't have a date (just checked in a virtual machine). Read More...
|
-
I was replying to a newsgroup post today, explaining the restore process. I find some confusion in various places about what actually happens during restore, and hopefully below can help a bit: Fact: All backups contains log records. A log backup contains Read More...
|
-
Two weeks ago, we did the "SQL 2008 Summit" roadshow here in Sweden. We did 4 cities around Sweden in 4 days ( http://www.expertzone.se/sql2k8/ ). It was a bit exhaustive, but even more fun - being able to travel and spend some time with persons wish Read More...
|
-
I just learned (thanks Josefin) that we now have an update of the SQL Server 2008 feature pack - the October "edition". Stuff like download of command-line tools, driver for PHP, native client, sync framework, upgrade advisor, bunch of BI related utilities Read More...
|
-
Actually, the article has been out for about a month now, but I first solicited feedback on errors and typo's and then I forgot to mention the update here... Anyhow, the article now also covers 2008 and the new date, time, datetime2 and datetimeoffset Read More...
|
-
I've started to produce my presentations for the "SQL Summit 2008". It is always fun to dive down into the details about some certain feature. For instance one of my presentations is about policy based management, which will also include a few words on Read More...
|
-
I just learned from Gail E. at MS that the system error messages are all documented in the SQL Server 2008 Books Online. For instance, search for 823. See the hits? Now, for instance, select the "Errors 1 - 999" page. Press the "Sync with Table of Contents" Read More...
|
-
You might have read an earlier blog entry about my problems to remove a Data Collector (DC) information in SQL Server 2008. I still haven't found any info on how to do this, but my questions in the MVP group triggered some activity. Bob Ward looked into Read More...
|
-
Let me start by saying that the contents of this post is not very advanced. If you have read the excellent paper "Batch Compilation, Recompilation, and Plan Caching Issues in SQL Server 2005", http://www.microsoft.com/technet/prodtechnol/sql/2005/recomp.mspx Read More...
|
-
Because of the problems I had removing Data Collector I decided to rebuild msdb. You probably heard about instmsdb.sql, but it was a long time since I actually used it. I asked about rebuilding in the MVP group and Dan Jones (MS) pointed me to a Blog Read More...
|
-
For various reasons I decided that I want virtual machines with older (pre-2008) SQL Server versions available on my various machines. For me, virtualization (in this case VPC) is great: I rarely use these installs, most often I just boot it and check Read More...
|
-
Short story: Turn on 2000 keyboard layout and then back to Standard layout. Long story: This topic has been discussed in both the MCT (MS Certified Trainer) as well as MVP groups. Also, see http://sqlblog.com/blogs/andy_leonard/archive/2008/08/08/sql-server-2008-management-studio-function-keys.aspx Read More...
|
-
I'm in a situation where I have configured the new data collector functionality for three instances. And there's no way to undo the config performed by the wizard! It cannot be undone by the wizard, and BOL doesn't have information on how to do this. Read More...
|
|
|
|
|
|