|
|
|
|
Latest Blog Posts
-
|
I received this request in many courses , messages and also forum discussions: having an Analysis Services Tabular model, it would be nice being able to extract a correspondent PowerPivot data model. In order of priority, here are the specific feature...
|
-
|
The SQL Server team has released CU #8 for SQL Server 2012 RTM. KB article: http://support.microsoft.com/kb/2844205 Build # is 11.0.2410 This build has 6 fixes Relevant for builds 11.0.2100 -> 11.0.2409. Do not attempt to install on SQL Server 2012...
|
-
|
Well, surely at least partly in response to the CU6 mess I reported earlier today , and partly because they were due, Microsoft has released new cumulative updates that contain - among other things - updated code that avoids the symptom introduced with...
|
-
|
In April and May, Microsoft released cumulative updates for SQL Server 2008 and 2008 R2 (I blogged about them here and here ). They are: CU #11 for 2008 SP3 (10.00.5840) ( KB #2834048 ) CU #12 for 2008 R2 SP1 (10.50.2874) ( KB #2828727 ) CU #6 for 2008...
|
-
|
Does your CHECKDB hurt, Argenis? There is a classic blog series by Paul Randal [ blog | twitter ] called “ CHECKDB From Every Angle ” which is pretty much mandatory reading for anybody who’s even remotely considering going for the MCM certification,...
|
-
|
Load testing used to be a standard part of the software development, but not anymore. Now people express a preference for assessing performance on the production system. There is a lack of confidence that a load test reflects what will actually happen...
|
-
|
The query optimizer does not always choose an optimal strategy when joining partitioned tables. This post looks at an example, showing how a manual rewrite of the query can almost double performance, while reducing the memory grant to almost nothing....
|
-
|
Excel add-ins Data Explorer and GeoFlow work well together, mainly because they just work. Simple, fast, and powerful. I started Excel 2013, used Data Explorer to search for, examine, and then download latitude-longitude data and finally used GeoFlow...
|
-
|
It was an offer I could not resist. I was promised a free copy of one of the newest books from Red Gate Books , SQL Server Transaction Log Management (by Tony Davis and Gail Shaw ), with the caveat that I should write a review after reading it. Mind you,...
|
-
|
In July and October, I will be doing my "How To Design a Relational Database" full day conference in two places. First on July 26 for the East Iowa SQL Saturday , and then for the big daddy SQLPASS Summit in Charlotte, NC on October 14. You...
|
-
|
I have to say that I continue to be frustrated with finding out how to do things in Windows 8. Here's another one and it's recorded so it might help someone else. I've also documented what I tried so that if anyone from the product group ever reads this,...
|
-
|
Eighteen posts for T-SQL Tuesday #43 this month , discussing Plan Operators. I put them together and made the following clickable plan. It’s 1000px wide, so I hope you have a monitor wide enough. Let me explain this plan for you (people’s names are the...
|
-
|
Late last year, I was invited by Raoul Illyés, a SQL Server MVP from Denmark, to present a precon at the 2013 edition of SQLRally Nordic. I agreed and decided to skip the US PASS Summit this year and instead visit an area of Europe I've never seen before....
|
-
|
This is a post for T-SQL Tuesday #43 hosted by my good friend Rob Farley . The topic this month is Plan Operators . I haven’t taken part in T-SQL Tuesday before, but I do like to write about execution plans, so this seemed like a good time to start. This...
|
-
|
I’m glad there is no minimum length requirement for T-SQL Tuesday blog posts , because this one will be short. I was in the classroom for almost 11 hours today, and I need to be back tomorrow morning at 7:30. Way long ago, back in SQL 2000 (or was it...
|
-
|
Sewing has never been my thing. I barely even know the terminology, and when discussing this with American friends, I even found out that half the words that Americans use are different to the words that English and Australian people use. That said –...
|
-
|
One of the coolest technologies Microsoft released with SQL Server 2005 was Database Mirroring, which provided the ability to have a failover copy of a database on another SQL Server instance, and have the ability to automatically failover to that copy...
|
-
|
If you've been redirected here because you posted on a forum, or asked a question in an e-mail, the person wanted you to know how to get help quickly from a group of folks who are willing to do so - but whose time is valuable. You need to put a little...
|
-
|
It feels just like yesterday that I went to Munich for the very first German edition of SQL Saturday – and it was a great event. An agenda that was packed with three tracks of great sessions, and lots of fun with the organization, attendees, and other...
|
-
|
Normally I try to put topics in the positive in other words "Do this" not "Don't do that". Sometimes its clearer to focus on what *not* to do. Popular development processes often start with screen mockups, or user input descriptions. In a scale-out pattern...
|
-
|
Wow, so far in this series, I have interviewed some very good friends, and some truly excellent writers (and usually both), but today, following on the heels of Jason Strate , we are going to hit someone whose name is synonymous with community, a person...
|
-
|
Recently Microsoft announced that they’re releasing a new XBox which was apparently big news and was reported on at length around the globe. One article in particular on the BBC News website caught my attention because it contained what I thought to be...
|
-
|
Tech Ed isn’t even over yet, and my new Hekaton Whitepaper is already generating questions I can’t answer yet! Here are the two questions that were in my inbox this morning: 1. The whitepaper says “There are other wait types, such as waiting for a log...
|
-
|
This morning I presented my session Manage SQL Server System and Performance Data with PowerShell at Tech Ed NA in New Orleans. We had a good sized audience who were very responsive and had many great questions. I had a great time presenting and the feedback...
|
-
|
Today at TechEd in New Orleans I delivered a breakout session entitled " Data, Faster: Microsoft SQL Server Performance Techniques with SQLCLR ." This session covered a number of techniques for using SQLCLR as a query tuning tool, especially for big,...
|
|
|
|
|
|