2012-06-07
2,010 reads
Seth Delconte
2012-03-26
2,191 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,716 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,345 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,585 reads
Blogs
Using a Local Large Language Model (LLM): Interacting with Local LLMs Using PowerShell
As AI continues to evolve, many of us are looking for ways to leverage...
Monday Monitor Tips: Finding the Hostname for Queries
By Steve Jones
I was chatting with a customer recently and they wanted to know which host...
Can AI Read Execution Plans?
Yeah, yeah, second AI post in a row. I promise not to make a...
Forums
SSIS Won't Create Log Entries
Hi everyone My SSIS package will not log to sysssislog. I am not sure...
SQL Server is terminating in response to a 'stop' request from Service error
Dear All, In one of the server its repeatedly restarting sqlserver services and not...
Question of the Day
Database Files on Shares I
I want to store database files on a file share for a SQL Server 2017 instance. Can I use \\fileserver\D$ as a location?
See possible answers