Managing Registered servers with SQL Powershell
Learn how to generate Registered Servers with PowerShell in this article.
2016-10-25
3,578 reads
Registered Servers
Import/Export SQL Server 2000 Enterprise Manager Registered Servers
Exports and imports SQL Server 2000 Enterprise Manager groups and server registrations using Powershell.
2008-08-27 (first published: 2008-02-15)
2,557 reads
RE: Cursor V/S query
If you can do it using a single query then why bother with a cursor?SQL Server is optimised for set based operations. I tend to view cursors as an option of last resort. You can get locking problems with them because they itterate through recordsets on a row by row basis.If you are worried that […]
2004-11-25
2004-11-18
RE: How to keep and restore the deleted records?
a5xo3z1 use a "status" field ( I add also a timestamp , and a user field ). But adding a column on a production table sometimes it's not possible, but useful on critical DBs.It's also good check if this additional processing will have "side effects" in operation .
2003-05-29
1 reads
RE: cast varchar as datetime
CREATE FUNCTION MyStrip(@v varchar(50)) RETURNS DateTime AS BEGIN Declare @vv Varchar(50) Set @vv=Right(@v,DataLength(@v)-CharIndex(' ',@v)) RETURN Cast(Left(@vv,DataLength(@vv)-CharIndex(' ',Reverse(@vv))) as DateTime) END Select dbo.MyStrip('Fri, 06 Dec 2002 14:52:26 -0500') Select dbo.MyStrip('Fri, 6 Dec 2002 15:08:59 EST')
2003-05-17
1 reads
RE: Other databases
quote: MySQL has its fans though personally I suspect the MySQL vs other open source databases is the VHS vs Betamax thing again. ...and then there were Picture Discs, and now we have DVD Cheers, Frank
2003-05-15
Blogs
Real-World SQL Mastery: Your Hands-On, Mess-Free Sandbox
Are you ready to take your SQL skills from theoretical to tactical? If you've...
Set a Runtime Variable in an Azure DevOps Pipeline
By Steve Jones
Note: I DO NOT recommend this. Any changes to a pipeline should be in...
A New Word: Symptomania
By Steve Jones
symptomania – n. the fantasy that there’s some elaborate diagnosis out there that neatly...
Forums
7 sept, scheduled book
Comments posted to this topic are about the item 7 sept, scheduled book
7 sept, schedlued article
Comments posted to this topic are about the item 7 sept, schedlued article
6 sept, published book
Comments posted to this topic are about the item 6 sept, published book
Question of the Day
Azure Data Lake Storage Gen 2
Azure Data Lake Storage Gen 2 is built on ...?
See possible answers