SQL Server 2005 Tidbit 041 I always like reading up on how Microsoft “does IT”. And I recently saw on the main TechNet page that we have a nice write-up on how Microsoft rolled out SQL Server 2005 internally.Check it out.—Got an IT question? Give me a comment here, or contact me.
SQL Server 2005 Tidbit 040 This one is just for fun and nostalgia value. It’s a copy of Microsoft SQL Server 1.1 running as a Virtual Machine under Microsoft Virtual PC.http://blogs.virtualserver.tv/blogs/dugie/archive/2005/12/12/345.aspxThanks Andrew Dugdell!—Got an IT question? Give me a comment, or contact me.
Incredible… I can’t believe he did this…The two guys in this video are famous at Microsoft these days for a very well-done series of video-blog postings around Windows Vista. Lots of cool video demos that I’d likely be fired for telling you anything about. (seriously cool stuff; you’ll just have to believe me!) This video, … Continue reading I love Vista, too! (But maybe not THAT much…)
SQL Server 2005 Tidbit 039 I have talked about and demonstrated the new SQL Server Upgrade Advisor in my live events recently. When showing that you can include a profiler trace file for the sake of the analysis, I was asked,“But what events should we trace? What trace would be the most useful for the advisor?”And the … Continue reading SQL Server 2005 Tidbit 039
SQL Server 2005 Tidbit 038 The MSDN web site has links to some SQL Server 2005 Virtual Labs.“What’s this ‘virtual lab’ thing of which you speak?”Virtual labs are hosted sessions on a pre-installed virtual machine, along with lab notes to work through various scenarios on the installed software.“But, can’t I just do that on my … Continue reading SQL Server 2005 Tidbit 038
SQL Server 2005 Tidbit 037 This question was asked at our event TODAY in Des Moines, IA.“Can the SQL Server 2005 Database Engine Tuning Advisor (DTA) aslo tune databses running on SQL 2000?”Short answer. YES!And in fact, something I didn’t mention at the event, but is also quite useful in the new tool; the new … Continue reading SQL Server 2005 Tidbit 037
If you haven’t seen this yet, you really need to. It’s fantastic! And if you don’t speak Korean, it’s okay. The text of the video is printed below the video.
SQL Server 2005 Tidbit 036 Credit for this one goes to Chris Avis, who had this asked of him in an event recently…“With ‘instant file initialization’, what is it really doing?”Here’s a document that describes it well.From the document: In SQL Server 2005, data files can be initialized instantaneously. This allows for fast execution of … Continue reading SQL Server 2005 Tidbit 036
SQL Server 2005 Tidbit 035 Credit for this one goes to Chris Avis, who had this asked of him in an event recently…“What is the max number of filegroups supported as part of a single database?”Well… it’s a nice big binary number: 111111111111111 (or 32,767 for you decimal lovers). The answer is found here.—Got an … Continue reading SQL Server 2005 Tidbit 035
SQL Server 2005 Tidbit 034The following question was asked at a Recent “Best of SQL Server 2005 Launch” TechNet Event in Kansas City (Overland Park Kansas, actually. Had a lovely time there, thank you! …and although it was a bit of a dive, the Karaoke at the Red Balloon was a lot of fun!)“DDL Triggers… … Continue reading SQL Server 2005 Tidbit 034
Absolutely Full of I.T. 