|
|
Front Page News
-
|
Ever need to group dates and round them to intervals? I had this exact need for a report on wait stats I was working on for an upcoming post. I wanted the flexibility to be able to group a list of dates by either minute, hour, date, etc. ...
|
-
|
It’s that time of the month again. Time to network and learn about SQL Server with your peers. Location: 8300 Norman Center Drive, 9th Floor, Bloomington, MN 55437 Date: March 16, 2010 Time: 2:30 - 5:00 Please click here for meeting details and to RSVP...
|
-
|
If you’ve got the time, stop in to socialize and learn a bit about SQL Server. Kalen Delaney will be in town teaching a class over at Benchmark Learning and has offered to join the meeting to talk about Simple Recovery Model. Also, Barbara...
|
-
|
A couple weeks back I was asked, “How come Microsoft has yet to put TRIM() in SQL?” I don’t really know why there isn’t a TRIM() function in SQL Server. There is an LTRIM for function removing leading spaces. And an RTRIM function for removing trailing...
|
-
|
I have been working on a project modifying the ETL for a data warehouse. The source is a Pervasive database which, through SSIS 2005 packages, populates a SQL Server 2005 data warehouse and associated SSAS 2005 cubes. I encountered an issue which reminded...
|
-
|
A while back, I noticed that Paul Randal ( on twitter as @paulrandal ) had started a new blog meme on three events that brought their life to where it is today . I’ve skipped a lot the past year’s memes due to time constraints but thought I’d chime...
|
-
|
Looking for an introduction into the different high availability technologies available in SQL Server? Check out this webcast that I recorded for SSWUG . It’s being made available on Feb 24th and covers the following: With failover clustering,...
|
-
|
I’d like to thank Pam Shaw (twitter as @pamshaw ) and Jorge Nunez (twitter as @sqlchicken ) for letting me come down to Tampa this past weekend to present at SQL Saturday #32. Jeez, that picture doesn’t make me look very happy. For someone...
|
-
|
Two households, both alike in dignity, In fair Verona, where we lay our scene, From ancient grudge break to new mutiny, Where civil blood makes civil hands unclean. ~ Romeo and Juliet, William Shakespeare Those Montagues and Capulets don’t do so well...
|
-
|
Figured since I helped write the meeting announcement and newsletter for PASSMN this month that I'd just copy most of the details. Since last month we've moved from our old host to a new host, so the RSVP/registration process has changed a bit. Hopefully,...
|
-
|
My problem stemmed around needing to clear out records in the Operational Data Store (ODS) system during a quarterly process while leaving the data corresponding to the System products pristine. The problem was I didn’t explicitly know what the “System”...
|
-
|
I've been selected to speak at the Tampa SQL Saturday coming up at the end of January. I'm a bit pumped to be going down there since I woke up this morning to below zero weather for yet another day. Not that I'm complaining, but my feet could definitely...
|
-
|
SQL Server Reporting Services provides a great way to allows report users to select more than one value from the available values list in parameters, creating a multivalue parameter. SSRS dynamically creates a comma separated list of the values selected...
|
-
|
A few weeks ago I posted a job that I use to track wait stats in the DBA database that I bring to a number of clients. I had promised to follow-up with a couple or three reports that could be used to monitor the values that were being aggregated...
|
-
|
With the next release of SQL Server, data analysis is going to go through a major change with the PowerPivot add-in for Excel and SharePoint. If you haven’t been keeping up with these changes to Business Intelligence, SSWUG.org has an opportunity...
|
-
|
I’ve blogged about certifications a number of times in the past. One of the certifications that I really want to obtain in the future is the Microsoft Certified Master (MCM) for SQL Server 2008 . This is a great certification that really dives...
|
-
|
Another year is passing and with the end of the year it seems like a good time to do a quick update on where PASSMN is sitting. I had planned to mention this last week but that whole work thing got me all sidetracked. We had our final meeting...
|
-
|
In case you missed the last reminder or hadn’t heard. We are having a PASSMN meeting in December this year. Check out the event details below and take a chance to learn new things with some of your fellow SQL Server professionals. Don't Wait!...
|
-
|
It’s a very good question. One that might not seem to insidious. Nothing that should be able to bring down the system and cause failures. Or will it? I’ve been to a number of clients and done it myself before where I start to check out a stored procedure...
|
-
|
I got to work with deadlocks quite a bit recently. There were quite a few interesting ones that came up that I had the chance to research. Since I like easy, I’ll start with the one that I forgot to grab the deadlock details for. Well, maybe...
|
-
|
Hopefully everyone caught the news that the November PASSMN meeting was cancelled. We had some scheduling conflicts and things didn’t come together as expected. But to make up for that, we’ve managed to snag a speaker and room for the beginning...
|
-
|
If you don’t know where you’ve been, how can you expect to know where you are going. Seems like such a simple little line and I’m sure many of us can look at history, politicians, and maybe that restaurant review that you didn’t heed when it comes...
|
-
|
This summer I built an SSRS 2008 Report Model for a client. The end users report against the model using Report Builder 2.0. I shall pause here for a rave. <rave> Report Builder 2.0 is just outstanding, in my humble opinion. I built a SQL 2005 Report...
|
-
|
A few times this past week I heard the quote, “Hi, Eric Stratton, Rush chairman, damn glad to meet you”. That line kind of summarizes what the PASS Summit was like for me this year. It’s been like coming to a week long rush event for the best...
|
-
|
The SSWUG Ultimate Virtual Conference starts this morning. Are you planning to take advantage of this opportunity? The Rock Star speakers are waiting in the channels, anticipating you every move. But, have you registered? It’s not too...
|
|
|
|