Pulse » Recent Items from 7/20/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
-
SQL Server – "Denali" – String Formatting using FORMAT()
SQL Server "Denali" introduces a new function FORMAT() for formatting of DATETIME and numeric values. In Earlier versions we did date and time conversions using CAST and CONVERT as below: – © 2011 – Vishal (http://SqlAndMe.com) DECLARE @d DATETIME = GETDATE() SELECT CONVERT(VARCHAR, @d, 103) AS 'dd/MM/yyyy', CONVERT(VARCHAR ...
-
Announcing SQL Saturday #99
Seriously, what’s going on in Minnesota? Our government is shut down and… we are hosting a SQL Saturday on a Friday (again). We are shaking up our event a little bit over last year though… instead of a casino, we’re moving the event to a local church. So ...
-
ACID Properties By Example (And Counterexample) Part Zero
ACID Properties By (Counter) Example Part Zero: ACID Properties Part One: Atomic Part Two: Consistent Part Three: Isolation Part Four: Durable So I’m introducing a small series about ACID properties as it applies to databases. (For other acid properties, talk to a chemist or Timothy Leary). When talking about ...
-
SQL Server “Denali”: New Certifications
According to the post SQL Server “Denali” Experts–We Need You! that asks for your feedback on the Microsoft certifications for the next version of SQL Server, there will be seven exams: Four certification exams are planned for SQL Server “Denali” Business Intelligence roles: Writing queries with Transact-SQL (T-SQL) ETL ...
-
Microsoft Windows Platforms Blog Watch
Remote Desktop Services Component Architecture Poster Grab your own poster! A visual guide to key Remote Desktop Services technologies in Windows Server 2008R2 Virtually Free Get the latest update rollup package for the Hyper-V role in Windows Server 2008 R2 and be sure to bookmark the Windows Virtualization Team Blog ...
-
2nd Quarter Review
Half a year down already? This year is flying by a such a rapid rate and it seems hard to keep up at times. However, things are progressing and I’ve managed to stay on top of a few of my goals for this year. To recap what those goals ...
-
Powershell sql server security audit
Often there is a requirement to enforce SQL Server Security Policies. This powershell script - in part 7 - will take a list of sql server instances, iterate through every instance , generate a list of Logins and return TRUE or FALSE for the fixed server roles:SYSADMIN,SECURITY,SERVER ADMIN,SETUP ADMIN ...
Pulse is a section of SQLServerPedia that gives you a quick view of what's happening in the SQL Server community.