Pulse » Popular Items from 8/8/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.
August
-
SQL SERVER – Tips from the SQL Joes 2 Pros Development Series – Overriding Identity Fields – Tricks and Tips of Identity Fields – Day 9 of 35
Answer simple quiz at the end of the blog post and - Every day one winner from India will get Joes 2 Pros Volume 2. Every day one winner from United States will get Joes 2 Pros Volume 2. Identity Fields For students new to the database world, it helps ...
-
SQL MCM Training – Day 1
Today was my first day of SQL MCM training here in Bellevue. We started at 08:30am and now (05:30pm) Kimberly is currently talking about how to use the provided VPC J. The main theme for today's day was about learning the fundamental about performance tuning. We have ...
-
Microsoft Document Watch for Operational Excellence
Back when my day-to-day duties included database administration work and enterprise architecture, I became rather obsessed with the idea of operational excellence. I read everything I could on the topic. I made a list of favorites, which became somewhat shabby over time, as I dog-eared important pages and scribbled notes ...
-
Check Constraints That Call Functions
Originally this blog post was going to be about how using check constraints that call functions basically eliminates SQL Server’s ability to do set-based operations and I was going to setup an example that inserted 10 rows to show that because of the check constraint that calls a function ...
-
Now is a good time to start planning your 2012 conference schedule.
The 2011 conference season is starting to come to a close. There are only a few large conferences left such as VM World, SQL PASS, and Dev Connections. Many people are currently working with their bosses to get sent to these conferences. However while going through these conversations here’s ...
-
Denali Sequence Numbers
I’m just back from vacation following some great training from Pragmatic Works. With apologies to Billy Joel, this is a little post to get me back in a SQL state of mind. One of the new features in the upcoming Denali release are Sequences, database objects that create numeric ...
-
SSRS Export En Masse
Have you ever found yourself in need of exporting all of the reports from a Report Server? I have found myself in need of extracting all RDLs from a Report Server on more than one occasion. Reporting Services 2008 would rather have you do that in a rather monotonous and ...
-
SQL Server Cluster Changing Port Number
changing the port number for a sql server cluster should be a pretty straight forward task. Most Clustered sql servers will be mission critical, hence the clustering; this also means it will be properly secured behind a firewall. This means you will need to run the SQL Server instance on ...
-
Want To See The Next Version of SQL Server?
Then go and download it, right now, for free. https://www.microsoft.com/betaexperience/pd/SQLDCTP3CTA/enus/ OK, so it is not exactly the RTM version. Fine. How many CTPs do you believe will be released then? I think we are at the limit. So most of what you will ...
-
SQL Server – How to cascade UPDATEs and DELETEs to related tables
In most cases we use stored procedures to update or delete rows from related tables. But, you can also cascade the actions using foreign key constraints. This is generally not used due to the fact that it is transparent, and leads to *mysterious* results. Let’s see how it works ...
Pulse is a section of SQLServerPedia that gives you a quick view of what's happening in the SQL Server community.