Sites anglophones


Using SQL Compare and SQL Data Compare within a PowerShell Cmdlet

Publié le 15 janvier 2021 sur sqlservercentral.com
 

The post Using SQL Compare and SQL Data Compare within a PowerShell Cmdlet appeared first on SQLServerCentral.

Azure Blob Storage Data Upload with SSIS

Publié le 15 janvier 2021 sur sqlservercentral.com
 

The post Azure Blob Storage Data Upload with SSIS appeared first on SQLServerCentral.

We Lost Gareth Swanepoel.

Publié le 14 janvier 2021 sur brentozar.com
 

Thirteen years ago, I met Gareth Swanepoel (@GarethSwan) for the first time, interviewed him for his first real sysadmin job, and … turned him down. Gareth Swanepoel circa 2007 Thankfully, my manager overruled me and hired him anyway. Thank good …

Getting your SQL Server Development Data in Three Easy Steps

Publié le 14 janvier 2021 sur sqlservercentral.com
 

The post Getting your SQL Server Development Data in Three Easy Steps appeared first on SQLServerCentral.

Dynamic Power BI Slicer Using DAX Logic

Publié le 14 janvier 2021 sur sqlservercentral.com
 

The post Dynamic Power BI Slicer Using DAX Logic appeared first on SQLServerCentral.

Working with NULL Values in an ADF Data Flow?

Publié le 14 janvier 2021 sur sqlservercentral.com
 

When you are working with ETL/ELT, sometimes you may need to transform NULL into a meaningful value. If you worked with SSIS, you probably know how you handle that. This blog post will describe how do we typically do this in SSIS and then how the very …

How to Resolve Merge Conflicts in Git for SSIS Projects

Publié le 13 janvier 2021 sur sqlservercentral.com
 

The post How to Resolve Merge Conflicts in Git for SSIS Projects appeared first on SQLServerCentral.

Which Microsoft Certification Should You Get?

Publié le 12 janvier 2021 sur brentozar.com
 

You work with data, and you’re thinking about getting a Microsoft certification. Which one should you get? If you need the certification to get a job… Then get the certification you see mentioned the most often in the descriptions of the j …

How to Check SQL Server Version When Service is Not Running

Publié le 12 janvier 2021 sur sqlservercentral.com
 

The post How to Check SQL Server Version When Service is Not Running appeared first on SQLServerCentral.

Analyze Azure Cosmos DB data using Synapse Link and Power BI

Publié le 12 janvier 2021 sur sqlservercentral.com
 

Introduction In my last article, Using Azure Synapse Link for Azure Cosmos DB , I discussed creating the Synapse Link to query data present in Azure Cosmos DB from my Synapse workspace. Here, I will create a new database in the serverless SQL …

Oracle archived redo size – the research

Publié le 11 janvier 2021 sur simple-talk.com
 

In an earlier article, I explained why you might see log file switches taking place much more frequently than expected, with the archived redo files being much smaller than the online redo log files. When I do presentations about the odd effects that c …

Import Data from PDF to SQL Server

Publié le 11 janvier 2021 sur sqlservercentral.com
 

The post Import Data from PDF to SQL Server appeared first on SQLServerCentral.

Data Element Names and Scoping Rules in SQL

Publié le 11 janvier 2021 sur sqlservercentral.com
 

How you name data elements in databases and applications programs has often been a matter of personal taste. Decades ago, when I worked for state government, there is a COBOL programmer who would pick a theme for his programs. The paragraphs and variab …

Masking Data in Practice

Publié le 11 janvier 2021 sur sqlservercentral.com
 

The post Masking Data in Practice appeared first on SQLServerCentral.

Kubeflow for data scientists introduction

Publié le 8 janvier 2021 sur simple-talk.com
 

Kubeflow is a Machine Learning platform that runs on top of Kubernetes and provides end to end functionality for executing machine learning projects. Google created it for internal use of running Tensorflow jobs on Kubernetes, and they later released i …


Pages :