2012-06-07
2,003 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
7,012 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,464 reads
Blogs
Daily Coping 21 Oct 2021
By Steve Jones
I started to add a daily coping tip to the SQLServerCentral newsletter and to...
#PowershellBasics: Get a list of files from a directory.
I’ve got a project I’m working on at the moment and it includes a...
Join me next week at my first GroupBy session
2021 has been the year people want to learn about Temporal Tables, it seems....
Forums
Managed Instance, cross-database queries. What are the hidden requirements?
Have a managed instance with 2 databases. In theory I should be able to...
Need the (default) port to connect - why is this not implicit.
So I have 2 instances (1 x 12, 1 x 19). Both have the...
Extract data from XML field
Hello, I have a SQL view with a column called GlobalCountryRegionXML. Here is an...
Ask SSC