Pulse » Recent Items from 7/13/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
-
BI Documenter: Impact Analysis and Object Lineage
Are you considering making a change to your view or stored procedure? Or possibly you are considering moving your database to another server and you want to know how the move would impact your SQL Server. With one of Pragmatic Works software tools, BI Documenter, you can easily identify how ...
-
BI Documenter: Impact Analysis and Object Lineage
Are you considering making a change to your view or stored procedure? Or possibly you are considering moving your database to another server and you want to know how the move would impact your SQL Server. With one of Pragmatic Works software tools, BI Documenter, you can easily identify ...
-
Resetting SSMS shortcut keys in SQL Server “Denali” CTP 3
If you did what I did when you installed CTP 3 of SQL Server “Denali” you’ll be in for a rude surprise, a lot of your shortcut keys that you’ve been using for years don’t work any more. This is to say the least VERY annoying, and ...
-
Do you use T-SQL debugging?
T-SQL debugging is not 100% in SQL Server. It has few bad drawbacks starting from difficulties when setting it up and ending with inability to view any data table during debug. I have an idea for post for DBAs who use T-SQL debugging and are interested in improving debugging experience ...
-
Do you use T-SQL debugging?
T-SQL debugging is not 100% in SQL Server. It has few bad drawbacks starting from difficulties when setting it up and ending with inability to view any data table during debug. I have an idea for post for DBAs who use T-SQL debugging and are interested in improving debugging experience ...
-
DAX Queries, Part 1
So at long last Denali CTP3 has been released and I can blog about all the cool new stuff in it. It feels like years (in fact it has been years) since I’ve had anywhere near this much new functionality to learn and discuss here – it’s better than ...
-
Calculate Rows Inserted per Second for All Tables
Ever needed to calculate the number of rows inserted every second, for every table in every database on a server? Or, have you ever needed to validate that all processes have stopped writing to tables? These types of questions come up routinely for me. To help with this, I’ve ...
-
Table Auditing with XML
When working with meta data tables it can be very useful to track when people make changes to the data. How do you track any change against any number of columns for any table? I have implemented a fairly simple solution that uses triggers and stores all changes as XML ...
-
Table Auditing with XML
When working with meta data tables it can be very useful to track when people make changes to the data. How do you track any change against any number of columns for any table? I have implemented a fairly simple solution that uses triggers and stores all changes as XML ...
-
SQL Server – Login Auditing using Logon Triggers
Since SQL Server 2005 we have LOGON Triggers, these are DDL Triggers which are created at Server level. These triggers are created to respond to a Login Event. LOGON Trigger executes after the Authentication has been made successfully. LOGON Triggers can be useful in may ways, such as to restrict ...
Pulse is a section of SQLServerPedia that gives you a quick view of what's happening in the SQL Server community.