2012-06-07
1,997 reads
Seth Delconte
2012-03-26
2,178 reads
Verify SQL Server Login and Login Settings
Verifies that a specified login name exists and has correct settings.
2011-07-27 (first published: 2011-07-11)
1,673 reads
Randomizing Result Sets with NEWID
Seth Delconte brings us a technique to solve a common request. Using the NEWID function to return a random record from a result set.
2010-03-01
6,943 reads
Get Rid of Duplicates!
This article contains instructions on how to use some of my favorite methods to remove duplicate fields from a table.
2009-11-30
13,421 reads
Blogs
A simple powershell script to look up server hardware and OS information
By SQLPals
This is a simple powershell script to query and display hardware and OS information...
Collecting Server Performance Metrics: Performance Monitor
Whether you’re a DBA/administrator looking to tune a server, planning for hardware updates, or...
Introduction to SQL Server Execution Plans
By Bert Wagner
Watch this week’s episode on YouTube! I nearly always use execution plans as the...
Forums
Evergreen SQL Server
Comments posted to this topic are about the item Evergreen SQL Server
Do you really know what’s happening with your servers?
Comments posted to this topic are about the item Do you really know what’s...
Going from long to wide
Comments posted to this topic are about the item Going from long to wide
Ask SSC