Installing PostgreSQL 11 on Windows with Step-by-step Instructions

PostgreSQL is a free database management system (DBMS). PostgreSQL 11 is the new version of this DBMS. We will take a look at how to install PostgreSQL 11 on Windows. This article covers where to download PostgreSQL 11, how the installation process looks like, and how to connect to the PostgreSQL server. Step-by-Step Installation on Windows […]

Updates to the Deployment Suite for Oracle

Redgate has added new capabilities to the Deployment Suite for Oracle, so it now supports automated migrations-based and state-based Oracle deployments on both Linux and Windows. They've introduced Redgate Change Control, a new capability for understanding development changes, generating migration scripts for version control, and getting precise control over the migration path during automated deployments. Our Schema Compare and Data Compare for Oracle command line tools have been extended to Linux as well as Windows, and we’ve added static code analysis that encourages teams to follow good coding practices on Windows or Linux.

Workplace Encounters: Using Volume Mount Points in SQL FCIs

How we overcame the A to Z Windows Drive-Letter limitation using Volume Mount Points

Would You Still Love Linux If Windows Was Free?

A guest editorial today looks at the OS debate: Windows v Linux.

Windows Group Membership Checker

A script to reveal which logins have access to your sql server via windows groups.

Memory Management

Windows Internal Database

This past Friday I received a call from our systems team stating that they were running low on Disk Space...

RE: Windows vs SQL Auth - Performance Issue??

SQL Server hitting the network for NT account verification has got to be a factor in here somewhere. I am by no means conversant with the subject, but if you're granting SQL Login access to NT security groups, SQL has to be going out to the network to check what groups a login attempting to establish […]

RE: BACKUP failed to complete the command BACKUP DATABASE.............

http://www.dbforums.com/t812439.htmlThis might help, Seems to different views but MVP and some suggestions for you to go on. Sorry cannot be any more help, James  

RE: Conditional DELETE

quote: Create linked server to Excel File. sp_addlinkedserver N'Excel', N'Jet 4.0', N'Microsoft.Jet.OLEDB.4.0', N'c:\data\MySheet.xls', NULL, N'Excel 5.0' GO sp_addlinkedsrvlogin N'Excel', false, sa, N'ADMIN', NULL GO And run query as following. delete account where acct_id IN (SELECT ColumnA FROM [FROM EXCEL...Sheet1] where ColumnA = 1000) I'm going to have to try this one.