Introduction to PostgreSQL Database on Amazon RDS
This article explains how to get started with PostgreSQL on AWS.
2020-12-15
1,529 reads
rds
Enforce SSL for connecting to AWS RDS Instance of SQL Server
Learn how to force all SQL Server connections to an AWS RDS instance to use SSL encrypted connections.
2019-04-02
Native SQL Backups for Amazon RDS Databases
Use native SQL Server backups with Amazon RDS databases to easily import and export data between local server and the AWS cloud.
2020-08-21 (first published: 2018-12-13)
3,345 reads
SQL Server on Amazon RDS vs SQL Server on Amazon EC2
Exploring briefly the difference between using Amazon Machine Images running SQL Server and using SQL Server instances on Amazon's Relational Database Service.
2020-09-18 (first published: 2018-04-12)
15,377 reads
RE: Wot! No RecordCount??
Here's how I open a record set that uses a stored proc proc code : CREATE PROCEDURE [dbo].[SPNDemo] @ObjectName as varchar(50), @id as int output AS SET NOCOUNT ON SET @id = object_id(@ObjectName) SELECT name , XType FROM dbo.SysObjects WHERE name like '%' + @ObjectName + '%' ORDER BY XType, Name IF @@Rowcount > 0 […]
2005-05-27
RE: CASE in computed column
Ah - I do have an index on it. It's a name though - not very like to chnage much.
2005-05-06
RE: Trying connect through QA and typing IP of virtual sql server I''''ve got error
Yes, Siva, I've allready checked these IP addresses. It doesn't work. Neither physical nor virtual. On sql server log it's said that one node listen to xx.xx.xx.x1 :1433 , other node- xx.xx.xx.x2:1424These ports have been assigned dynamically. When I try to connect from cluster node to outside SQL server by its IP address all works […]
2005-05-06
2005-03-31
Displaying relationships on databases/tables
Is there a sql command that would list all the relationships on a database or even just a table?uanita
2005-03-29
1 reads
Blogs
Enabling an Index: #SQLNewBlogger
By Steve Jones
I don’t do a lot of work with disabled index, but I learned how...
Back to Boston for SQL Saturday
By Steve Jones
I’m leaving again tomorrow for a trip. This time I head back to Boston...
T-SQL Tuesday #179: What’s In Your Data Detective Toolkit?
By Tim Mitchell
Most of us who work with data have, at least a few times, been...
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