Articles

SQLServerCentral Article

Connecting to Amazon DocumentDB with MongoDB Drivers

With Amazon DocumentDB developers and DBAs can balance availability, read scalability, and latency with five pre-configured consistency levels. The data in an Amazon DocumentDB cluster is accessible just like a MongoDB 3.6 cluster. The CData Software Drivers for MongoDB provide a SQL-like interface to MongoDB data through standards-based drivers. This allows users to see their data in the […]

2021-10-27

107 reads

External Article

5 things to look for in a monitoring tool

A key finding from Redgate’s recent State of Database Monitoring Survey of over 2,500 IT professionals was that 79% of respondents reported using either a third-party or in-house monitoring tool. It’s notable because it’s an increase of 10 percentage points from the same survey last year. But when should you use an in-house tool, and when should you take the plunge and invest in a third-party monitoring tool like SQL Monitor?

2021-10-27

SQLServerCentral Article

Design your systems and processes for auditability

I have worked in more than one regulated industry, and since the banking crisis of 2008, I have witnessed a sea change in the approach to regulation.  The UK Financial Services Authority (FSA) was seen to be a toothless tiger.  The UK government replaced the FSA with two separate bodies, each with its own more […]

5 (3)

2021-10-25

905 reads

SQLServerCentral Article

CData Connect: Derived Views and Query Federation

Big data plays a key role in promoting both manufacturing and scientific development through industrial digitization and emerging research. Integrating big data demands scalable tools for enabling not only big data ingestion and curation but also efficient large-scale exploration and discovery. There is a solution to scale up to large volumes of data distributed across multiple […]

2021-10-22

178 reads

Blogs

What’s my MAC Address in a Command Prompt?–#SQLNewBlogger

By

Another post for me that is simple and hopefully serves as an example for...

You don’t need a blockchain

By

After writing several posts about a neat feature in Azure SQL called system-versioned ledger...

Daily Coping 27 Oct 2021

By

I started to add a daily coping tip to the SQLServerCentral newsletter and to...

Read the latest Blogs

Forums

Intermittent sqlmail success - troubleshooting

By brambor

Microsoft SQL Server 2016 (SP2-GDR) (KB4583460) - 13.0.5103.6 (X64) SQLMail Account configured with SSL...

T-SQL help

By leo_dec

I need help to write the T-SQL with scenario that if room got multiple...

From the sys.sql_modules (linked.db.schema.vw_xxx) seperate column

By GG_BI_GG

Hi All, Im working an a issue and have some thinks I would like...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers