technology

SQLServerCentral Article

SQL Access to Redis Data

  • Article

Traditionally, importing key-value data stores such as Redis into BI, reporting, and ETL tools is problematic, if not impossible. With the CData Drivers, there are several different ways to building a traditional database model to easily work with Redis data in the BI, reporting, ETL, and custom applications of your choice. In this article, we discuss […]

5 (1)

You rated this post out of 5. Change rating

2021-11-12

610 reads

External Article

Redgate Streamed: Embracing technology trends for database success

  • Article

Innovating in the database is crucial for success, and we’re seeing new trends impact the database, like cloud migration, SRE, and the growing need for big data and tools to support growing estates. On 23 June, Redgate Streamed brings you organizations who have implemented these database technology trends, including speakers from Google, Microsoft, and AWS, who will share their success stories and tips for embracing technology changes.

2021-06-07

Technical Article

RE: EXEC permission

  • Reply

You pretty much said it yourself. The user needs to have direct access to the table if you make the select in dynamic sql. Try this to solve your problem : Declare @maxrows as int set @maxrows = 10 Set rowcount @maxrows select * from dbo.SysObjects order by name set rowcount 0 This will allow […]

You rated this post out of 5. Change rating

2005-03-24

Technical Article

RE: CACHE HIT RATIO

  • Reply

How much memory do you have in your server. I dont believe dbcc perfmon will give an accurate cache hit ratio in configurations where AWE is enabled. Have tried monitoring the server the performance monitor using the specific sql objects? I wouldn't advise running this continually it eats resources. If you need a cheap and […]

You rated this post out of 5. Change rating

2004-04-22

Blogs

Query Store Keeps Switching Itself Off, Getting it Moving Again

By

I recently received a complaint that Query Store for a particular database was turned...

EightKB 2024 – Schedule and Registration

By

Hello Hello, We. Are. Back! The schedule for EightKB 2024 Edition has been announced!...

Inside SQL Server Backup and Restore History Pruning with sp_delete_backuphistory

By

I had a customer that was looking to document a restore that had occurred...

Read the latest Blogs

Forums

7 sept, scheduled book

By philip.scott

Comments posted to this topic are about the item 7 sept, scheduled book

7 sept, schedlued article

By philip.scott

Comments posted to this topic are about the item 7 sept, schedlued article

6 sept, published book

By philip.scott

Comments posted to this topic are about the item 6 sept, published book

Visit the forum

Question of the Day

Azure Data Lake Storage Gen 2

Azure Data Lake Storage Gen 2 is built on ...?

See possible answers