Articles

Méthodes de sauvegarde et restauration de base de données SQL Server

Les bases de données SQL Server sont essentielles pour les entreprises. Apprenez à sauvegarder et à restaurer ces bases de données en utilisant des méthodes fiables et efficaces.

Dans SQL Server, la création d’une sauvegarde et la réalisation d’une opération de restauration sont essentielles pour assurer l’intégrité des données, la récupération après sinistre et l’entretien de la base de données. Voici un aperçu des procédures de sauvegarde et de restauration :

BACKUP DATABASE [DatabaseName] TO DISK = 'C:BackupDatabaseName.bak' WITH INIT;

2. Differential Database Backup

BACKUP DATABASE [DatabaseName] TO DISK = 'C:BackupDatabaseName.bak' WITH DIFFERENTIAL;

3. Transaction Log Backup

BACKUP LOG [DatabaseName] TO DISK = 'C:BackupDatabaseName.bak' WITH INIT;

Restore SQL Database Using Transact-SQL (T-SQL) Commands

1. Full Database Restore

RESTORE DATABASE [DatabaseName] FROM DISK = 'C:BackupDatabaseName.bak' WITH REPLACE;

2. Differential Database Restore

RESTORE DATABASE [DatabaseName] FROM DISK = 'C:BackupDatabaseName.bak' WITH RECOVERY;

3. Transaction Log Restore

RESTORE LOG [DatabaseName] FROM DISK = 'C:BackupDatabaseName.bak' WITH RECOVERY;

Architecture de sauvegarde et restauration de la base de données SQL Server

Dans SQL Server, créer une sauvegarde et effectuer une opération de restauration est essentiel pour assurer l’intégrité des données, la récupération en cas de sinistre et l’entretien de la base de données. Voici un aperçu des procédures de sauvegarde et de restauration :

Méthode 1. Sauvegarde et restauration de la base de données à l’aide de SQL Server Management Studio (SSMS)

Suivez les étapes SSMS pour sauvegarder la base de données SQL

  • Ouvrez SSMS et connectez-vous à votre instance SQL Server.
  • Faites un clic droit sur la base de données que vous souhaitez sauvegarder.
  • Accédez à « Tâches » > « Sauvegarde ».
  • Choisissez le type de sauvegarde (complète, différentielle, journal des transactions).
  • Définissez les options de sauvegarde, telles que la destination, le nom, la compression, etc.
  • Cliquez sur « OK » pour exécuter la sauvegarde.

Suivez les étapes SSMS pour restaurer la base de données SQL

  • Ouvrez SSMS et connectez-vous à votre instance SQL Server.
  • Faites un clic droit sur « Bases de données » > « Restaurer la base de données ».
  • Choisissez la source (dispositif ou fichier de sauvegarde).
  • Spécifiez les ensembles de sauvegarde à restaurer.
  • Configurez des options telles que les chemins des fichiers, l’état de récupération, etc.
  • Cliquez sur « OK » pour exécuter le processus de restauration.

Méthode 2. Sauvegarde et restauration de la base de données dans SQL Server à l’aide des commandes Transact-SQL (

Source de l’article sur DZONE

Transfert de données depuis SQL Server vers Excel

Le transfert de données depuis SQL Server vers Excel est un processus important pour les entreprises qui souhaitent faciliter l’analyse et le partage des informations.

Dans cet article, je partagerai des informations sur la façon de transférer des données de n’importe quelle table de notre base de données vers un fichier Excel personnalisé à l’aide de l’outil SSIS fourni par les développeurs MSSQL.

Once the installation is complete, we can open Visual Studio and create a new project. We will select the Integration Services Project type, which will allow us to create a package that will contain our data transfer process. After that, we can add a Data Flow Task to our package. This task will be responsible for transferring data from any table in our database to the custom-designed Excel file.

In order to do this, we need to configure the Data Flow Task. We will start by adding an OLE DB Source component to our Data Flow Task. This component will be used to connect to our database and retrieve the data from the table we want to transfer. We then need to configure the Excel Destination component, which will be used to write the data into the custom-designed Excel file.

Finally, we can configure the Data Flow Task to run in debug mode. This will allow us to test the data transfer process and make sure that it is working correctly. Once we are satisfied with the results, we can deploy the package to our production environment and start using it for our data transfer needs.

Dans cet article, je partagerai des informations sur la façon de transférer des données à partir de n’importe quelle table de notre base de données vers un fichier Excel personnalisé à l’aide de l’outil SSIS fourni par les développeurs MSSQL.

Tout d’abord, pour permettre notre développement via Visual Studio, nous devons installer Microsoft SQL Server Data Tools sur notre ordinateur.

Une fois l’installation terminée, nous pouvons ouvrir Visual Studio et créer un nouveau projet. Nous sélectionnerons le type de projet Integration Services, qui nous permettra de créer un package qui contiendra notre processus de transfert de données. Après cela, nous pouvons ajouter une tâche de flux de données à notre package. Cette tâche sera responsable du transfert des données à partir de n’importe quelle table de notre base de données vers le fichier Excel personnalisé.

Pour ce faire, nous devons configurer la tâche de flux de données. Nous commencerons par ajouter un composant Source OLE DB à notre tâche de flux de données. Ce composant sera utilisé pour se connecter à notre base de données et récupérer les données de la table que nous voulons transférer. Nous devons ensuite configurer le composant Destination Excel, qui sera utilisé pour écrire les données dans le fichier Excel personnalisé.

Enfin, nous pouvons configurer la tâche de flux de données pour qu’elle s’exécute en mode débogage. Cela nous permettra de tester le processus de transfert de données et de nous assurer qu’il fonctionne correctement. Une fois que nous sommes satisfaits des résultats, nous pouvons déployer le package dans notre environnement de production et commencer à l’utiliser pour nos besoins de transfert de données.

Pour vérifier que le transfert des données se déroule correctement, nous pouvons utiliser l’outil SSIS pour exécuter des tests unitaires sur le package. Ces tests unitaires vérifieront que les données sont transférées correctement et que le fichier Excel personnalisé est correctement mis à jour avec les données provenant de la base de données. Une fois que les tests unitaires sont terminés

Source de l’article sur DZONE

Amazon Web Services (AWS) is the biggest cloud platform in the world, with over 200 features. In this article, we break down 10 AWS services that support at least some SQL syntax, talk about their use cases, and give examples of how to write queries.

Service Description SQL Support Use Case
RDS Postgres, MySQL, etc. Full Small-medium web apps
Aurora Serverless databases Full Serverless apps
Redshift Data warehouse Full OLAP, Petabytes of data, analytics
DynamoDB NoSQL database Some – PartiSQL Ecommerce, building fast
Keyspaces Managed Cassandra (key value) Some – CQL Messaging
Neptune Graph database Some – openCypher Social networks
Timestream Time series database Partial IOT, Logging
Quantum Ledger Cryptographically verified transactions Some – PartiSQL Finance
Athena Ad-hoc queries on S3 Some – CTAS Historical data
Babelfish MSFT SQL Server on Aurora Full .NET

The table above shows how SQL support varies between the services. A graph database cannot be queried in the same way as a classic relational database, and various subsets of SQL, like PartiQL, have emerged to fit these models. In fact, even within standard SQL, there are many SQL dialects for different companies like Oracle and Microsoft.

Source de l’article sur DZONE


Introduction

As a good DBA, it is critical to backup your data. However, sometimes, we have the backup, and the backup is corrupt. If that happens to a mission-critical environment, you could be fired because of the error.

This article will talk about the different ways to find out if a SQL Backup file is corrupt, automate the backup process, and some advice to test and avoid this problem.

Source de l’article sur DZONE

There exists two types of synchronisation techniques to make sure you avoid concurrency issues and race conditions when updating database records. These are as follows.

  • Optimistic locking
  • Pessimistic locking

Optimistic locking is usually performed by using native database mechanism such as RowVersion in SQL Server, TimeStamp in MySQL, or ETag in Cosmos DB. These are special field types that changes automatically as the record is updated, allowing you to inject the values of these fields as a criteria to your update invocations. For an example of how this works, imagine the following schema.

Source de l’article sur DZONE

It’s fun to see new website design tools that reflect current times and the state of the world. That’s very true this month with new databases devoted to diversity and women in technology, as well and resources to make your design life easier.

Here’s what’s new for designers and developers this month:

Ztext.js

Ztext.js is an easy to implement, three-dimensional typography tool for the web that works with any font you want to use. With the popularity of 3D effects and animation, this tool has a lot of practical applications. Everything you need, including documentation, is available from developer Bennett Feely on his website and GitHub. (It’s free but you can show appreciation with a donation if you like it.)

Gradient Magic

Gradient Magic is a free gallery of fun and interesting CSS gradients. You can sort through a random selection or by category of color to find just the right gradient for your project. Some of them would make really neat backgrounds or image overlays.

Impossible Checkbox

Impossible Checkbox is a fun little divot that you’ll want to play with and emulate. Click or tap the slider to activate and a nifty little friend pops up. Now here’s the fun part: You can’t leave it checked, and take note of the changing expression of the checkbox character.

Diversify Tech

Diversify Tech isn’t your average job board; it is a collection of resources – and opportunities – for underrepresented people in technology. It includes a weekly roundup and everything from scholarships, to events, to jobs, to speaking opportunities.

Women in Tech

Women in Tech is a list of apps made by women. The apps are ranked and chosen based on upvotes and is a good resource if you want to help support women-owned projects. Search or submit an app for inclusion.

Devello Studio

Devello Studio is a tool that allows you to write code in the cloud. You don’t have to install anything and no matter where you are, just can open a project in-browser, and continue development where you had left off last time. Plus, it works with GitHub support built right in.

Hustl

Hustl is a premium Mac app that allows you to create time-lapse videos of your screen. Use it to show off work or projects or create a cool video for your portfolio. Plus you can use it to capture just one active app so you don’t have to do a lot of editing later.

FeedBaxley

FeedBaxley is a user feedback tool that helps you (and users) figure out what’s frustrating before it becomes a real issue. You can customize everything to match your brand and set it up with copy and paste tools. Feedback integrates with Slack, making it easy for you to analyze information with a team.

BestTime

BestTime launched a major update with a new tool that makes it possible to analyze visitor peaks of public business (cafe, gym, etc) for whole areas. Using the heatmap API you can find businesses at popular times, locations, or by business type.

Pixeltrue

Pixeltrue is a new collection of free SVG illustrations and Lottie animations in a trendy style. They are available for commercial and personal use and add a bit of whimsical delight to website projects. (The error illustrations are particularly fun.)

Previewed

Previewed has tons of cool and realistic mockups that you can use to create the perfect setting for digital projects. You can find mockups for a variety of devices and cool panoramas that work perfectly for elements such as app store previews.

Alt Text Overlay Bookmarklet

The Alt Text Overlay Bookmarklet solves a common problem: It shows what images use alt text and what that text is. The tool was created by Christian Heilmann and he’s put it on GitHub for you to play with and test.

MergeURL

MergeURL allows you to merge and shorten up to five links. Enter the links and mergeurl.com/o/xxxxx, for example, will open all the URLs associated with that link. The tool is free to use and you don’t have to register to use the service.

Infinity Search

Infinity Search is a new search engine that lets you look for things privately and efficiently. Search the web, images, or videos. Here’s a little about how it works: “While we retrieve results from other search engines like Bing and Wikipedia, we also have our own indexes of links that are displayed in our search results. We are actively working on improving these indexes and they will only get better.”

Blade UI Kit

Blade UI Kit is a set of renderless components to use in Laravel Blade Views. It’s built for the tall stack and is completely open source. It includes 26 components and you can contribute as well.

Trusted News

Trusted News is a Google Chrome extension that uses AI to assist in evaluating the quality of the online content. In its first release, it scores the objectivity for a selected article, testing whether it is written from a neutral perspective as opposed to a subjective one.

BaseDash

BaseDash allows you to edit production data without coding. You can make changes to the database with the ease of a spreadsheet. This tool makes it easy to find and edit information in a hurry. It works with all major databases including MySQL, PostgreSQL, Amazon Redshirt, Microsoft SQL Server, and more.

Email2Go

Email2Go is a service that helps you create email templates and test them on dozens of physical devices and applications. It’s free right now while it is in early release.

Iconscout Converter

The Iconscout Converter allows you to convert icons and images from one file format to another for free. Convert SVG, PNG, JPG, and PDF with a single click.

Shape 2

Shape 2 is a massive collection of 5,000+ unique icons and illustrations with a full-blown web editor. Customize colors, stroke width, size and full variations that can export to SVG, PDF, PNG, GIF, and React. This is a premium tool and includes a discounted release price for now.

Aestetico

Aestetico is a beautiful sans serif that includes a massive family with 54 styles. This premium typeface is highly readable and has modern lines and curves that make it a great option for a variety of uses.

Arcades

Arcades is a modern display font with a retro, 1980s-style vibe. It includes regular and italic styles.

Brimington

Brimington is a handwriting style typeface with rough strokes and smooth curves. It includes a set of 227 characters and 219 glyphs in a readable design.

California Signature

California Signature is a typeface duo with a slab serif and handwriting style that are perfectly paired. The thick and thin options provide a yin and yang effect.

Eastblue

Eastblue is a script typeface with long swashes and interesting curves. It includes a solid character set and is free for personal use only.

Source


Source de l’article sur Webdesignerdepot


Agile 

AI

Big Data

Cloud

Database

DevOps

Integration

  • Mulesoft 4: Continuous Delivery/Deployment With Maven by Ashok S — This article is a great example of what we want every tutorial to look like on DZone. The main aim of this article is to provide a standard mechanism to release project artifacts and deploy to Anypoint Platform, from the local machine or configure in continuous delivery pipelines.
  • Integration With Social Media Platforms Series (Part 1) by Sravan Lingam — This article helps you to build a RESTful API through MuleSoft that integrates with LinkedIn and shares a post on behalf of one’s personal account. I like this article because, in the age of social media, it’s so important for businesses to be connected and integrated!

IoT

Java

Microservices

Open Source

Performance

  • What Is Big O Notation? by Huyen Pham — Aside from a silly name, this article is an example of an in-depth analysis on a little-spoken-about concept. In this article, take a look at a short guide to get to know Big O Notation and its usages.
  • Is Python the Future of Programming? by Shormisthsa Chatterjee — Where is programming going? This article attempts to answer this question in a well-rounded way. The author writes, "Python will be the language of the future. Testers will have to upgrade their skills and learn these languages to tame the AI and ML tools".

Security

Web Dev

  • A Better Way to Learn Python by Manas Dash: There’s so many resources available for learning Python — so many that it’s difficult to find a good and flexible place to start. Check out Manas’ curated list of courses, articles, projects, etc. to get your Python journey started today. 
  • Discovering Rust by Joaquin Caro: I’m a sucker for good Rust content, as there’s still so many gaps in what’s available. Joaquin does a great job of giving readers his perspective of the language’s features in a way that traditional docs just 

Source de l’article sur DZONE

On Twitter, Michael Dyrynda writes:

Never ever ever ever ever ever ever ever ever ever ever ever ever ever ever ever ever ever ever ever ever ever ever ever ever ever ever ever ever ever ever ever ever ever ever ever ever ever ever ever ever ever ever ever ever ever store currency as a float in your database.

Source de l’article sur DZONE

See the basics of how to automate database builds into a Linux SQL Server container running on Windows and then back up the containerized database and restore it into dedicated containerized development copies for each developer and tester.

An obvious use for Docker images of SQL Server is to run up a working database from a backup quickly, maybe to test it or possibly to mask the data. We’ll start by doing that in this article. We’ll then use SQL Change Automation (SCA) to synchronize an empty copy of a development database in a Docker container with the latest build in source control and fill it with data ready for testing. Finally, we’ll do a backup of the containerized database so we can restore it into each developer’s local container. These techniques, combined with ‘glue scripts,’ can be used for supporting continuous delivery of databases.

Source de l’article sur DZONE

 

Introduction

My previous posts discussed why you need automated database deployments and tips for getting started down that path. Enough talk, it is time for action! This article will walk through setting up an automated database deployment pipeline using the state-based approach for Redgate’s SQL Change Automation. I picked this tool to start with because it is easy to set up, integrates with SSMS, and…well…I already had a demo set up. I’m also a little biased towards Redgate’s tooling. So there’s that.

The end goal of this article is for you to have a working proof of concept for you to demo.

Source de l’article sur DZONE