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
SSL
Workplace Encounter: Effects of TLS 1.2
In this article we share a recent experience we had with implementing TLS 1.2 ONLY support on our databases and particularly with respect to its effect on Transaction Log Shipping sessions.
2019-01-03
2,000 reads
Configure SSRS with an SSL Certificate
A short demonstration on how to configure Reporting Services (SSRS) with an SSL certificate.
2017-03-02
77,530 reads
How to troubleshoot SSL encryption issues in SQL Server
Tibor Nagy explains how to find the root cause of SSL encryption configuration problems in Microsoft SQL Server.
2014-12-08
6,634 reads
How to configure SSL encryption in SQL Server
Tibor Nagy explains how to configure Secure Sockets Layer (SSL) encryption on our SQL Servers, with a trusted certificate.
2014-08-19
11,226 reads
Man in the MIddle
Are you worried about man in the middle attacks on your database server? If you run Oracle you should be, but SQL Server DBAs should not assume they are safe. Adding communication encryption can be a good idea for SQL Server DBAs.
2010-04-29
258 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: What will be the method to parse/Manipulate data queries?
I definitly agree with David, using a view would solve your problem in a fast and very simple way. //Hanslindgren
2005-05-06
RE: Documentation templates for stored procedures
you can check out how we do it for ApexSQL Doc - we have a pretty extensive template for procedures see www.apexsql.com/sql_tools_doc.htm
2005-01-01
RE: Convert a Group By Row Result into Columns (holy grail...)
This is a classic Crosstab query. Search on this forum for "Crosstab" and you will come up with some tips, tricks and procs.eg. http://qa.sqlservercentral.com/scripts/contributions/936.asp/rokmooose
2004-06-04
Blogs
Small Data SF 2024
By Steve Jones
I can’t remember how I heard about Small Data SF 2024, but it caught...
A New Word: Moledro
By Steve Jones
moledro – n. a feeling of resonant connection with an author or artist you’ll...
Snowflake + Azure blob
By Arun Sirpal
Let’s go back to data platforms today and I want to talk about a...
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