Pulse » Popular Items from 4/21/2009
Welcome!
Pulse has a simple goal: to give you a quick view of what's happening in the SQL Server community.
-
Browse
Finding interesting content on Pulse is easy – you can drill down to a specific time period (by clicking on the bars of the chart), toggle different types of content on and off, and sort the results by popularity or recency.
-
Vote
Discovered an informative blog post or a hilarious tweet? Tell the rest of the community about it by voting it up or down. Behind the scenes, our popularity algorithm will make sure it rises to the top of the list.
-
Comment
When a simple up-or-down vote isn't enough, voice your opinions in a comment. Or check out what others are saying about something you posted or tweeted.
-
Starting the SQL Journey: Part II
So in my last post I talked about my personal journey. In this post I’ll go step-by-step what I did to help along the path of learning all this SQL goodness. Tip 1 – Crawl Before You Walk… Don’t know what a SQL statement is? Think T-SQL is an ...
-
SQL SERVER – Difference Between SQL Server Compact Edition (CE) and SQL Server Express Edition
I often received question regarding what are difference between SQL Server Compact Edition (CE) and SQL Server Express Edition. In one line – SQL Server CE is for mobile application and embaded systems where as SQL Server Express Edition is limited feature light version of SQL Server Standard. SQL Server ...
-
SSWUG vConference Starts Tomorrow!
If you have ever dreamed about having me talk to you on all things SQL, then your chance starts tomorrow. The SSWUG vConference starts tomorrow morning and I have received a discount code for the. You can register for the conference here. And the code you want to use is ...
-
SQL Server 2008 – Saving changes is not permitted
Finally getting around to doing some work on SQL 2008, and after about 3 minutes, I run into this error: “Saving Changes is not permitted.. blah blah blah” See screenshot below. This is different than SQL 2005. Microsoft maybe trying to save us from ourselves? The thing is, I never ...
-
Great EXCEPTations
(OK I fully understand how lame the title of this post is but hey it’s the best I could do so live with it) I am guilty of favoring particular syntax over other options. This is mainly due to habit so every now and again I like to take ...
-
SQL 2005 Install Error
We have about eighty or so SQL 2005 instances running in our shop. Up until last week we had zero problems installing SQL 2005 on any of these instances. That all changed last week, when we were greeted with this error message: The SQL Server service failed to start. For ...
-
VMware Unveils New vSphere 4
Ok so now VMware has officially unveiled their new platform vSphere 4 (aka ESX 4.0) I figured I would give my quick reactions to today's announcements. First off, to be fair, I'm a rabid VMware fan-boy. Not that I won't give the other virtualization platforms a ...
-
Use SQL 2008 Express As A Central Management Server
I had the chance to catch Brent Ozar's webcast last week on creating a poor man's CMDB. In it he talked at length about the Central Management Server feature in SQL 2008. While I use SSMS 2008 my only SQL 2008 database installs so far are running inside ...
-
Register A Server More Than Once In SSMS
In yesterday's post about using SQL 2008 Express as a Central Management Server I mentioned that you can't register a server more than once in Object Explorer. Technically that's correct, but I meant to say Registered Servers. It turns out that you can register a server more ...
-
Analyze This – Analyze Your Indexes – Part 3
This is the third post in which I am walking through a query that I use to analyze indexes. Thus far I have added to the following to the query that I use: Combine existing index statistics and missing indexes into a single output (blog) Find existing duplicate and overlapping ...
Pulse is a section of SQLServerPedia that gives you a quick view of what's happening in the SQL Server community.