Dynamically process SSAS Cube from SSIS package
Learn how you can modify an SSIS package to dynamically process SSAS cubes.
Insert and Delete SQL Server Data with Views
In this tip we look at how to insert and delete data via SQL Server views.
Obsoleting Unused SSRS Reports
Learn about programmatically obsoleting unused SSRS reports from your Report Server.
Translating a SQL Server Schema into a Cassandra Table: Part I Problem Space and Cassandra Primary Key
As many companies consider moving data to NoSQL, Cassandra may be the choice. In this series, Shel Burkow discusses design considerations for porting a SQL Server schema to Cassandra. The first article explains the Cassandra primary key.
Use Polybase to consume Oracle data from SQL Server on Linux 2019
Learn how to set up Polybase in containers to access an Oracle database.
Replace Model SQL Server Database with a User Database
In this tip we look at what happens if we replace the SQL Server model database with a regular user database
A Problem with Cowboy Coding
Cowboy coding can be a problem, and in a case Steve talks about, a temptation for someone to get more work.
Blogs
Voice of the DBA | Writings from Steve Jones, the Voice of the DBA
By Steve Jones
Houston AI-Lytics 2026–Powerpoint Slides Thanks to everyone for attending my session on running a...
The Book of Redgate: Do the Right Things
By Steve Jones
I do believe that Redgate has been very customer focused since it’s inception. I’ve...
How to Connect to SQL Server When Nothing Else Works – DAC
By gbargsley
It's 2 AM. Your phone is going off. Users can't connect to the application,...
Forums
Warning: Could not open global shared memory to communicate with performance DLL
Hi everyone I am getting below warning when I run SSIS: Warning: 0x80049304 at...
Let's Talk Community Events!
Comments posted to this topic are about the item Let's Talk Community Events!
that one limitation in replication
Hi as shown below a replication target requires a primary key. if we want...
Question of the Day
Detecting Deadlocks
By default, how often is the SQL Server Database Engine checking for deadlocks?
See possible answers