Pulse » Recent Items from 7/6/2011
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.
July
-
Less code with rethrowing “exception” in SQL Server 2011
I wrote about some skeletons in the Denali’s closet here. Let’s also put some good on the table. Very handy new thing in Denali is the way how you can rethrow error in catch block. In SQL Server 2008 you must do this to rethrow error: BEGIN TRY ...
-
Less code with rethrowing “exception” in SQL Server 2011
I wrote about some skeletons in the Denali’s closet here. Let’s also put some good on the table. Very handy new thing in Denali is the way how you can rethrow error in catch block. In SQL Server 2008 you must do this to rethrow error: BEGIN TRY ...
-
Make Your Life Easier With Fun Denali Tricks
I’ve given SQL Server Denali a spin and I have to say that I really like it. I want to demonstrate how I use some of the new features to make my life easier. How much easier? The Scenario Using the Adventureworks database, I want to perform the following ...
-
SQL Functions – STUFF() and REPLACE()
STUFF() can be used to stuff a string into another string. It inserts the string at a given position, and deletes the number of characters specified from the original string. – © 2011 – Vishal (http://SqlAndMe.com) DECLARE @string1 VARCHAR(20) = 'Microsoft Server' DECLARE @string2 VARCHAR(20) = 'SQL Server 2005' ...
-
July 2011 S3OLV Meeting
We have had a bit of a lag between meetings for the User Group of Las Vegas. In June, a meeting was scheduled but did not happen. The cause of that was due to being locked out once again by our meeting place. That should not happen this month – ...
-
How to add your CMS server to a group
You cannot add a connection to your CMS server, on your CMS server. Well that is what I thought until SQLSaturday in Houston, where John Sterrett (Blog|Twitter) pointed out that you can use an IP address. I think Microsoft prevents this primarily because you already have a connection defined ...
-
SQL Server Analysis Services Operations Guide published
Another whitepaper to add to your “to read” list: SQL Server 2008 R2 Analysis Services Operations Guide This white paper describes how you can test, monitor, capacity plan, and troubleshoot Microsoft SQL Server Analysis Services OLAP solutions in SQL Server 2005, SQL Server 2008, and SQL Server 2008 R2. It ...
-
Pliant Technology, Enterprise Flash Drives For Your SQL Server: Part 2
Adding In Others For Contrast In our first part we introduced Pliant and the LS 300 drive. In part 2 we get down to the details. To give a better idea where you stand with the setup described last time I’m throwing in two other storage setups. A RAID ...
-
Meme Monday for July
With the 4th of July holiday falling on the first Monday of the month (AKA “Meme Monday”), I bumped our writing exercise to the second Monday in July. This month we are going to dive into something a bit creative, and something I hope you can have fun with: SQL ...
-
How cluttered is MSDB?
.csharpcode, .csharpcode pre { font-size: small; color: black; font-family: Consolas, "Courier New", Courier, Monospace; background-color: #ffffff; /*white-space: pre;*/ } .csharpcode pre { margin: 0em; } .csharpcode .rem { color: #008000; } .csharpcode .kwrd { color: #0000ff; } .csharpcode .str { color: #006080; } .csharpcode .op { color: #0000c0; } .csharpcode ...
Pulse is a section of SQLServerPedia that gives you a quick view of what's happening in the SQL Server community.