|
|
|
|
Latest Blog Posts
-
|
In the next series of posts, I'll focus on SQL Server I/O, revisiting some common issues and taking a closer look at some others. In each post and as always, I'll make the case with specific data points from my tests. For the first two posts in this series,...
|
-
|
A lot of people sent me emails asking for a way to get ahold of Quest Software's new DMV poster. The poster shows all of the major DMVs in SQL Server 2005/2008, what they're used for, and how to query them. You can get the poster (for free, of course)...
|
-
|
Microsoft has publicly stated that SQL Server 2008 will RTM in Q3. It is Quarter 3 now. Where is it? :-) I'm sure that the final touches will now get taken care of now that Bill Gates is no longer a full-time MSFT employee. I'm sure that his "short-timer"...
|
-
|
I asked for some names of people who you would like to see interviewed here at Sqlblog and Jamie Thomson's name popped up a couple of times. I contacted Jamie and he was kind enough to take time out from his busy schedule to answer these questions. So,...
|
-
|
I was just tagged by Andy Leonard, and truth to tell, I don't read Andy's blog all that often because he talks about really developer oriented stuff, which is a little outside my focus area now. But I was intrigued by the concept of a techblog meme, which...
|
-
|
One of the dynamic management views (DMVs) that is very useful in troubleshooting query performance is sys.dm_exec_requests. The documentation around this DMV, however, is quite lacking in two areas. percent_complete This column shows the "percent of...
|
-
|
It's great that you are an MVP! Well done! https://mvp.support.microsoft.com/profile=BCCF7416-DA4E-4D73-83E2-65FD61BAB16D Share this post: email it! | bookmark it! | digg it! | reddit! | kick it! | live it!...
|
-
|
Andy Leonard called me out on the Software Development Meme, so here goes: How old were you when you first started programming? I was 16 and it was on a commodore 128. I still remember the GOSUB keyword :-) How did you get started in programming? I got...
|
-
|
Thanks to a comment sent by a reader of my M2M paper , I just found a possible bug (or " not supported by design feature") of the CREATE LOCAL CUBE mdx statement. In short, it seems that a simple many-to-many dimension relationship is supported, but if...
|
-
|
MDX Formatting functionality debuted in MDX Studio 0.2.8, and judging by the amount of feedback I got on it – it became the most popular feature of MDX Studio ever ! Couple of people mentioned that for SQL formatting/beautifying needs, they would go online...
|
-
|
I like the Vista interface, but I know that under the covers Vista is a bit bloated. I've blogged before that the one of the problems with the Vista vs. XP debate is that not every computer needs the power user UI of Vista. Many production machines are...
|
-
|
Can you say it out loud? You might have known the capital was Boise, but if you pronounced it Boy-zee, you were wrong. I was there last Wednesday for the kickoff meeting of the Boise SQL Server User Group, and was told that if I didn't pronounce the name...
|
-
|
Frank La Vigne called me out on the Software Development Meme, so here goes: How old were you when you first started programming? I was 11 - almost 12. It was 1975, about this time of year. Has it been 33 years? Goodness... How did you get started in...
|
-
|
One of my most popular blog posts was “ Analysis Services 2005 protocol - XMLA over TCP/IP ”. Previously this information wasn’t available from anywhere else. But things changed today. Microsoft now has engaged in the “ Open Specification program ”. Citing...
|
-
|
I've said many times that my favorite new feature in SQL Server 2005 is the new metadata, in particular the new Dynamic Management Objects. When I have to do troubleshooting on a SQL Server 2000 system, it is worse than painful, not to have my favorite...
|
-
|
I am honored to present Cool Stuff With SSIS at the 1 July 2008 meeting of the Central Maryland Association of .Net Professionals (CMAP)! If you read this blog and attend, please introduce yourself! :{> Andy Share this post: email it! | bookmark it!...
|
-
|
PASS has structured its registrations to give the best deals to those who register the earliest. The current rate of $1395 expires June 30th. As Greg pointed out in his blog, community speakers have been announced. Register for the summit at http://summit2008.sqlpass.org/...
|
-
|
...continuing to follow the Entity Framework critics I mentioned earlier... If A == B and B == C,... A lot of life and nearly all business is based upon relationships. In business, it's possible to lose money and remain afloat - and thrive in some cases...
|
-
|
Wow, it's been a crazy month! Two weeks of Tech Ed in Orlando, where I spent time helping people with questions on SQL Server in the Database Platform area and presented two sessions on SMO and PowerShell (one with my friend Peter Ward from Australia)....
|
-
|
I had a note from Bill Graziano this morning telling me that our spotlight sessions for the PASS Summit in Seattle in November have been posted, along with details of some of the other sessions. I'm really looking forward to the summit this year as I...
|
-
|
I had an interesting note from David Silverlight today pointing out the INETA Community Champion awards. I'd encourage all to take a look at them, at the prizes and see if you should be participating. Details at: http://www.community-credit.com/cs/blogs/community_credit_news/archive/2008/06/17/the-ineta-community-champion-award.aspx...
|
-
|
Introduction I just wrapped up an ETL With SSIS class in the Rochester, NY area and one of the students in the class pointed out "You haven't blogged in over a week!" He's right - I need to blog more and more often. I've been distracted with preparations...
|
-
|
<Denis Gobo’s mode on> Suppose you have an empty table: SELECT COUNT (*) FROM SampleTable --- 0 What would be the result of the following query: DBCC CHECKIDENT ( 'SampleTable' , RESEED , 1 ) INSERT SampleTable ( j ) SELECT 1 SELECT SCOPE_IDENTITY...
|
-
|
In the SSWUG Virtual conference, Earl asks, Paul, I am looking @ several million records. In each record is a nvarchar that IDs the record and a datetime for when the transaction took place for that nvarchar ID. I need to capture the nvarchar ID when...
|
-
|
Now that Hyper-V is RTM, why should you care? Because it performs very well! If you do demos using virtual machines on a laptop, do yourself a favor and upgrade to Hyper-V. If you have a production data center with lots of virtual machines, you might...
|
|
|
|
|
|