SQL Server 2008 R2 Service Pack 2 (SP2) has been released. Both the Service Pack and Feature Pack updates are available for download on the Microsoft Download Center Download SQL Server 2008 R2 SP2 Download SQL Server 2008 R2 SP2 Express Download SQL Server 2008 R2 SP2 Feature Pack Here is what has been fixed with this service pack: _FIX: Lots of messages that have message ID 19030 and message ID 19031 are logged in SQL Server 2005, SQL Server 2008 or SQL Server 2008 R2 Errorlog file when you use SQL Server Profile in SQL Server 2005, in SQL Server 2008 or in SQL Server 2008 R2
This is an archive of the posts published to LessThanDot from 2008 to 2018, over a decade of useful content. While we're no longer adding new content, we still receive a lot of visitors and wanted to make sure the content didn't disappear forever.
SQL Saturday #126 is ALMOST HERE! I’ve been looking forward to this event for a long time, and I’m excited to be selected as a presenter. Join me this Saturday, 7/28/2012, in Indianapolis, IN for an introduction to Tabular Mode SSAS in SQL 2012. We’ll spend lots of time talking about the Business Intelligence Semantic Model and what it means for you as a developer and for users as well.
Automation of tasks is a true art and skill that you learn through your career as a DBA, Consultant or even Developer. Unfortunately and fortunately, in today’s age, we have dozens if not hundreds of tools at our disposal for automation. Over my own career, I’ve managed to take a firm handle on many of the tools that are out there, refine their usage as they fit best and develop several sound, stable and efficient means to and overall automated foundation of administrative tasks.
Slicers are super cool! By extending the power of filtering to apply to multiple PivotTables (or PivotCharts) they have really increased the reporting and data delivery power of Excel 2010. Not only do they look cool and are fun to interact with, they are also extremely functional. The fact that you can indeed apply a slicer value to multiple PivotTable objects was a big step forward for Excel based dashboarding and reporting.
As I’ve moved from project to project, environment to environment, I’ve had opportunities to write unit tests after coding, do test first development, and once use unit tests as a living spec for an external developer (code none unit testing?). One of the biggest friction points, once you settle on a framework, is the constant cycle back and forth between coding, building, running tests, and flipping back. Whether you are using MS Test and the built-in test result viewer, the external NUnit GUI, or a 3rd party test runner, that constant switching is actually stealing precious moments of concentration and time.
Introduction I am a one man team of developers. This has the advantage that I work with the most awesome developers in the world. But this also means it is kind of difficult to learn new things. For this of course the internet is a great place. Blogging is a great way to learn and a great egoboost from time to time or a humbling experience when you get it wrong.
Introduction A long time ago (last week) I wrote about servicestack and easyhttp. now I would like to talk to you about restservice. Restservice is a way to make a restfull service with servicestack. The service First let’s build our service. Imports ServiceStack.ServiceInterface Imports ServiceStackModel.Response Imports ServiceStackModel.Request Imports ServiceStack.ServiceHost Public Class PlantService Inherits RestServiceBase(Of PlantRequest) Private ReadOnly _plants As IList(Of PlantResponse) Public Sub New() _plants = New List(Of PlantResponse) _plants.
I’ve created a new project on Codeplex for an SSIS package that performs collections in order to create a baseline of merge replication: ”Merge Replication Baseline Collector“ The baseline can be used for all types of situations. A few… – Questionable peak replication times – Assistance in analyzing upgrade paths – Adding or removing subscribers or re-publishers and impacts – Spike reporting and predictive analysis on synchronizing events – Determining better time periods for bulk data loads or mass updates
Erin Stellato (blog | twitter) announced the most recent incaration of TSQL Tuesday a couple of weeks ago. A Day in the Life. A very interesting topic indeed. I knew I wanted to participate, but I didn’t want it to be a normal day, as those are littered with meals, work, and answering a billion questions from a 6 year old mind.. I knew I had a trip to Boston coming up, so I thought, hey, I should chronicle a day on the road.
This month’s topic, A Day in the Life, is hosted by my friend Erin Stellato (blog | twitter). Erin doesn’t typically let the community down on brilliant topics and valued content for all of us. The topic really, to me, holds much value in mentoring and relating back to taking a look at what you do and how you can improve, or limit, your work and your life. A lot of the community leaders and contributors are asked, repeatedly, “how do you get all that done?