Sites anglophones


PostgreSQL Hibernate Integration

Publié le 16 juillet 2021 sur sqlservercentral.com
 

Overview PostgreSQL is a free and general purpose open source object-relational database system that uses and extends the SQL language while Hibernate is probably the most popular ORM tool. If you are not familiar with PostgreSQL then I suggest you to …

Why Are Linked Server Queries So Bad?

Publié le 15 juillet 2021 sur brentozar.com
 

No, I don’t want to be your valentine. Remember when you were in school, and you had a crush on someone? You would write a note asking them to be your valentine, and you’d ask a mutual friend to pass the note over to them. The adult equival …

Importing a CSV into SQL Server Shouldn’t Be This Hard

Publié le 14 juillet 2021 sur sqlservercentral.com
 

Like many of you, I recently had to import some data in a CSV (comma-separated file) into SQL Server. This wasn’t a new process, or an application that needed enhancing, or even an ongoing ETL (Extract, Transform, Load) process that needed to be built. …

Mergers and acquisitions in Insurance

Publié le 14 juillet 2021 sur sqlservercentral.com
 

The post Mergers and acquisitions in Insurance appeared first on SQLServerCentral.

Autoscaling in Microsoft Azure

Publié le 14 juillet 2021 sur sqlservercentral.com
 

The post Autoscaling in Microsoft Azure appeared first on SQLServerCentral.

SQL ConstantCare® Population Report: Summer 2021

Publié le 13 juillet 2021 sur brentozar.com
 

Ever wonder how fast people are adopting new versions of SQL Server, or what’s “normal” out there for SQL Server adoption rates, hardware sizes, or numbers of databases? Let’s find out in the summer 2021 version of our SQL Const …

An Introduction to Power BI

Publié le 12 juillet 2021 sur sqlservercentral.com
 

Introduction Power BI is a collection of software services, apps, and connectors working together. It helps to connect different data sources and get visually immersive and interactive insights from the data. Power BI creates powerful reports to be sha …

Best of Summit 2020

Publié le 12 juillet 2021 sur sqlservercentral.com
 

The post Best of Summit 2020 appeared first on SQLServerCentral.

SQL Server Restore Database Options and Examples

Publié le 12 juillet 2021 sur sqlservercentral.com
 

The post SQL Server Restore Database Options and Examples appeared first on SQLServerCentral.

The key to great database CI is disposable databases

Publié le 9 juillet 2021 sur sqlservercentral.com
 

The post The key to great database CI is disposable databases appeared first on SQLServerCentral.

How to Restore a Snapshot in AWS RDS with the Same Name?

Publié le 9 juillet 2021 sur sqlservercentral.com
 

The demand for increasingly scalable, capable, and inexpensive database, backup, and recovery solutions has never been higher than it is now, as digital transformation reaches its pinnacle. Restoring is the process of recovering data from a backup and …

Who’s Hiring in the Database Community? July 2021 Edition

Publié le 8 juillet 2021 sur brentozar.com
 

Is your company hiring for a database position? Do you wanna work with the kinds of people who read this blog? Let’s set up some rapid networking here. If your company is hiring, leave a comment. The rules: Your comment must include the job …

But we’ve always done it this way?

Publié le 7 juillet 2021 sur sqlservercentral.com
 

The post But we’ve always done it this way? appeared first on SQLServerCentral.

More on Column Choice and Order for Multi-column Non-Clustered Indexes

Publié le 7 juillet 2021 sur sqlservercentral.com
 

In the last year I’ve published articles on indexes to include Indexes: When Column Selectivity Is Not Always A Requirement – SQLServerCentral and Query Optimizer Suggests Wrong Index and Query Plan — Why? – SQLServerCentral. This ar …

Get Ready: SQL Server 2016 Mainstream Support Ends in One Week.

Publié le 6 juillet 2021 sur brentozar.com
 

Brent Ozar, bearer of bad news Who am I kidding? You’re not really going to get ready, but let’s talk about this anyway. SQL Server 2016 mainstream support ends Tuesday, July 13, 2021. According to Microsoft’s SQL Server support polic …


Pages :