2012-06-07
2,002 reads
Seth Delconte
2012-03-26
2,182 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,681 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,998 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,462 reads
Blogs
Goal Progress for July 2021
By Steve Jones
I set goals at the beginning of the year, and I’m tracking my progress...
Data Modeling at your fingertips
By Rayis Imayev
(2021-July-30) A picture is worth a thousand words, the same way a visual database schema...
How to put a SQL Server Database into Recovery Pending
By John
You might be asking why on earth would you want to get a database...
Forums
Migrate SQL Sever 2012 Database To Server 2014 and Subsequent Versions
Hi Guys, I have an SQL Server 2012 Express database that I would like...
Deploying SQL Server Automatically
Comments posted to this topic are about the item Deploying SQL Server Automatically
Setting data compression on a database or even server level possible?
I well realize data compression is a subject to a few variables, such as...
Ask SSC