SAP S/4HANA and Microsoft Azure SQL Integration and Hard Deletion Handling
This article shows how one can use SSIS to find differences in SAP.
2022-10-31
2,078 reads
Articles
How SQL Monitor gives developers the information they need to develop faster and smarter
Leading Danish pharmaceutical company, Orifarm, has a mission to be 'Number 1 in making healthcare a better deal'. Find out why they chose SQL Monitor to give their whole IT team, developers included, the real-time metrics they need to highlight development issues and resolve them before they become problems.
2022-10-31
SQL Cheat Sheet for Basic T-SQL Commands
In this article, we cover some basic T-SQL commands that show you how to interact with a SQL Server database table.
2022-10-31
SQL Server Engineering Using Free Tools
You can master engineering for your SQL Server databases, on premises or in the cloud, with a FREE toolkit!
2022-10-28
4,745 reads
Expert-led PASS Data Community Summit Pre-cons
Spaces are still available for next month's PASS Data Community Summit pre-conference sessions - but they’re booking up fast! Choose from 18 deep-dive full day pre-cons, featuring some of the best minds in the data industry, covering everything from technical processes to personal growth. Register now.
2022-10-28
SQL Stored Procedure Input and Output Parameters, Types, Error Handling, Security and more
In this article, we look at various aspects of creating SQL Server stored procedures along with several examples of how to build a stored procedure.
2022-10-28
Migrate the SSIS Catalog in Just a Few Clicks
This wizard migrates SSIS Catalog from one server to another in just a few clicks.
2022-10-27 (first published: 2021-08-17)
16,586 reads
10 Considerations for a Database Migration to AWS RDS
This article includes 10 things that you should consider when migrating to the cloud, with an example using RDS that explains how these are applied to an actual database being created.
2022-10-26
3,601 reads
5 Database DevOps Trends Landing on your Shoulders
Are these challenges heading your way?
Join us on Nov 15th at PASS Data Summit to discuss key trends that impact Database DevOps, such as Containerization, and Cloud Build/CI systems. Reserve your place now.
2022-10-26
Bringing SQL Server Data Quality Tools to Your Company
Learn how and why you should be using Melissa's data quality components that fully integrate into SSIS packages to fix data problems and save your company money.
2022-10-26
Blogs
From Planning to Practice: Setting Up Your FinOps Framework
By HeyMo0sh
As someone who works in DevOps, I’m always focused on creating systems that are...
“We love to debate minutiae”
By Brian Kelley
I am guilty as charged. The quote was in reference to how people argue...
Advice I Like: Knots
By Steve Jones
Learn how to tie a bowline knot. Practice in the dark. With one hand....
Forums
Restoring On Top II
Comments posted to this topic are about the item Restoring On Top II
SQL Art 2: St Patrick’s Day in SSMS (Shamrock + Pint + Pixel Text)
Comments posted to this topic are about the item SQL Art 2: St Patrick’s...
Breaking Down Your Work
Comments posted to this topic are about the item Breaking Down Your Work
Question of the Day
Restoring On Top II
I have a database, DNRTest, that has a number of tables and other objects in it. The other day, I was trying to mock up a test and ran this code on the same server:
-- run yesterday CREATE DATABASE DNRTest2 GO USE DNRTest2 GO CREATE TABLE NewTable (id INT) GOToday, I realize that I need a copy of DNRTest for another mockup, and I run this:
-- run today USE Master BACKUP DATABASE DNRTest TO DISK = 'dnrtest.bak' GO RESTORE DATABASE DNRTest2 FROM DISK = 'dnrtest.bak' WITH REPLACEWhat happens? See possible answers