Sites anglophones


Cross Tab Report in SSRS

Publié le 30 septembre 2020 sur sqlservercentral.com
 

The post Cross Tab Report in SSRS appeared first on SQLServerCentral.

Hidden treasures of SQL Prompt

Publié le 30 septembre 2020 sur sqlservercentral.com
 

The post Hidden treasures of SQL Prompt appeared first on SQLServerCentral.

Editor Tips and Tricks for Azure Data Studio

Publié le 30 septembre 2020 sur sqlservercentral.com
 

Azure Data Studio (ADS) is a lightweight IDE built on Visual Studio Code. I’ve written a few articles on how ADS works, shown here: Getting Started with Azure Data Studio Getting Comfortable Writing Code in Azure Data Studio Using Notebooks in Azure Da …

Questions about Comparing Databases with SQL Compare that you were Too Shy to Ask

Publié le 30 septembre 2020 sur sqlservercentral.com
 

The post Questions about Comparing Databases with SQL Compare that you were Too Shy to Ask appeared first on SQLServerCentral.

Announcing a New Class: Fundamentals of Columnstore

Publié le 29 septembre 2020 sur brentozar.com
 

Your report queries are too slow. Will columnstore indexes help? You’ve tried throwing some hardware at it: your production SQL Server has 12 CPU cores or more, 128GB RAM, and SQL Server 2016 or newer. It’s still not enough to handle your g …

Running Container Workloads in Microsoft Azure

Publié le 29 septembre 2020 sur sqlservercentral.com
 

The post Running Container Workloads in Microsoft Azure appeared first on SQLServerCentral.

How SQL Prompt Improves SQL Server Database Development

Publié le 29 septembre 2020 sur sqlservercentral.com
 

The post How SQL Prompt Improves SQL Server Database Development appeared first on SQLServerCentral.

When one of your DBA colleagues leaves the company, what is your checklist?

Publié le 29 septembre 2020 sur sqlservercentral.com
 

Whether it’s in our personal lives our professional one, we do have checklists for certain tasks. On the professional level, these checklists can be purely technical, like steps for a SQL Server installation, configuration, or even uninstall …

Why choose Oracle?

Publié le 28 septembre 2020 sur simple-talk.com
 

As an applications development professional, my career objectives are to do work that is fulfilling in the sense that it challenges my capabilities, keeps me on the cutting edge of technology, and pays me decently. I have established my career as an Or …

Building SQL ConstantCare®: Warning You About New Large Tables & Indexes

Publié le 28 septembre 2020 sur brentozar.com
 

When I’m doing a SQL Server health check, one of the things I like showing clients is a list of their top tables by size. Inevitably, there are a bunch of tables that: Tables whose names start with “temp” or “backup” or …

Solving the Provisioning Problem in Database Development using Clones

Publié le 28 septembre 2020 sur sqlservercentral.com
 

The post Solving the Provisioning Problem in Database Development using Clones appeared first on SQLServerCentral.

A Getting Started PostgreSQL Tutorial

Publié le 28 septembre 2020 sur sqlservercentral.com
 

Introduction to PostgreSQL PostgreSQL is a free and general purpose open source object-relational database system that uses and extends the SQL language. Though originally designed to run on UNIX platforms, PostgreSQL is eligible to run on various plat …

Database Development with GitHub

Publié le 25 septembre 2020 sur sqlservercentral.com
 

The post Database Development with GitHub appeared first on SQLServerCentral.

Searching and Finding a String Value in all Columns in a SQL Server Table

Publié le 25 septembre 2020 sur sqlservercentral.com
 

The post Searching and Finding a String Value in all Columns in a SQL Server Table appeared first on SQLServerCentral.

The 4 Presentations I’m Proudest Of, and What Inspired Them

Publié le 24 septembre 2020 sur brentozar.com
 

I was thinking back about the presentations I’ve been the most proud of over the years. I’ve written and performed a *lot* of stuff over time, but here are some of the free public presentations I’m the most proud of, and the stories o …


Pages :