Pulse » Recent Items from 9/28/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.
September
-
Two Lines of Powershell = Random Passwords
One of the first things I translated from a previous script language to PowerShell was a random password generator. The previous script was 57 lines long. So, when I HAD to create a SQL Authenticated login I could provide a strong password. I googled (Bing wasn't out yet.) on ...
-
SQL SERVER – Interesting Observation – Execution Plan and Results of Aggregate Concatenation Queries
Working with SQL Server has never seems to be monotonous – no matter how long one has worked with it. Quite often, I come across some excellent comments that I feel like acknowledging them as blog posts. Recently, I wrote an article on SQL SERVER – Execution Plan and Results ...
-
What’s your access level?
Too often developers and administrators alike find an easy solution to providing data access is to give users more permissions than are truly required. In the development environments I’ve worked in, developers always worked with full local and server admin rights and full database rights. This usually resulted in ...
-
Need to re-send a Reporting Server subscription?
If you are working with Reporting Services then you might have noticed the pain of re-sending a subscription report. It’s a very tedious process and wrote a small neat script to make this process easy. This tip is posted on MSSQLTIPS and you can find it here (How to ...
-
Lessens learned – Report Server administration
It’s a long commute in the morning, so I thought I’d use this time to compile a few things I learned and noticed about administering a server hosting SQL 2005 or 2008 Report Services. Check the recovery model of the databases you create on your report server, including the ReportServerTempdb ...
-
Office 2010: Excel 2010, What-If Analysis aka Microsoft Finally has Built in Cube/OLAP Writeback!
Digging into the blog post from earlier this summer I wanted to see what was new and exciting in Excel 2010. Recently I have been working on an cube and we want to be able to budget right from the cube. There are also many other cubes/scenarios where the ability ...
-
Kick off Banned Book Week with "Beautiful Data"
It’s Banned Book Week! The American Library Association observes Banned Book Week the last week of September to celebrate intellectual freedom. Thanks to author Neil Gaiman (@neilhimself) for retweeting, or I wouldn’t have heard of it. I’ve decided to spread the joy with a little celebration of ...
-
If you only knew the power of the dark side….
Have you ever not done something just for the fact that you’re afraid that you might like it? LOL I’ve known enough Oracle to almost get by on a VERY basic level but I’m currently on a longterm gig and there is a bit of Oracle in ...
-
MVP book is available for preorder
Last year a large number of MVPs (mostly SQL Server) got together to write a book with all proceeds going to charity. The book consists of over 50 chapters, each on a different SQL-Server related topic, from database architecture through development administration, database development, performance tuning and even Business Intelligence. ...
-
Top 5 Free SQL Server Tools
Maybe there is no such thing as a free lunch but who cares when there are awesome tools for SQL Server that are available for free! That’s right, you can make life a whole lot easier for yourself by maximising your valuable time so you can concentrate on the good ...
Pulse is a section of SQLServerPedia that gives you a quick view of what's happening in the SQL Server community.