Sites anglophones


[Video] What Every Developer Needs to Know About Databases

Publié le 8 mars 2022 sur brentozar.com
 

I had the pleasure of sitting down with David Giard virtually and discussing what developers need to know about databases. I always have fun talking with David – he’s a great follow on Twitter – and I think it shows in this conve …

Moving to Team-Based Database Development with Flyway

Publié le 7 mars 2022 sur sqlservercentral.com
 

The post Moving to Team-Based Database Development with Flyway appeared first on SQLServerCentral.

Use Cases for WHILE and GOTO Loops with T-SQL for Time Series Data

Publié le 7 mars 2022 sur sqlservercentral.com
 

The post Use Cases for WHILE and GOTO Loops with T-SQL for Time Series Data appeared first on SQLServerCentral.

The Central Management Servers Extension in Azure Data Studio

Publié le 7 mars 2022 sur sqlservercentral.com
 

Introduction The Azure Data Studio comes with a lot of extensions. One of these is the Central Management Servers (CMS) extension. This extension allows adding servers in groups in order to run a query in multiple SQL Server at the same time. If we wor …

Office Hours: 7 Questions for You to Answer Edition

Publié le 4 mars 2022 sur brentozar.com
 

Sometimes, I see questions and go, “You know, I’d rather let other people answer this.” And today, I’m gonna let you do it. My blog post this week about PollGab.com and about its data model brought out all kinds of interesting O …

How to back up and restore in PostgreSQL: Learning PostgreSQL with Grant

Publié le 4 mars 2022 sur sqlservercentral.com
 

The post How to back up and restore in PostgreSQL: Learning PostgreSQL with Grant appeared first on SQLServerCentral.

The evolution of SQL Monitor: it keeps getting better and better

Publié le 4 mars 2022 sur sqlservercentral.com
 

The post The evolution of SQL Monitor: it keeps getting better and better appeared first on SQLServerCentral.

Oracle ASM: Migrating from UDEV devices to the ASM Filter Driver

Publié le 4 mars 2022 sur sqlservercentral.com
 

I recently had a client express some interest in migrating from UDEV managed devices in Oracle ASM to the ASM Filter Driver (AFD). There is a Metalink document describing the migration from ASMLIB to AFD that is quite informative: ASMFD: How to Migrate …

Building PollGab.com: February’s Hosting Bill: $1.85.

Publié le 3 mars 2022 sur brentozar.com
 

Earlier this week, I wrote about how we designed the database for PollGab.com. Because we went with AWS DynamoDB for the database storage and AWS Lambda for the processing work, costs are really, really low: That is not a typo: that’s $1.85 …

Who’s Hiring in the Database Community? March 2022 Edition

Publié le 2 mars 2022 sur brentozar.com
 

Is your company hiring for a database position as of March 2022? 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 …

Can We Please Stop Sending Passwords Over the Wire?

Publié le 2 mars 2022 sur sqlservercentral.com
 

While analyzing SQL Server’s network protocol, I came across a weird fact: when a database client logs in using SQL Server authentication (as opposed to Windows authentication), it has to send the user’s password to the server, in blatant violation of …

Eight Azure SQL configurations you may have missed

Publié le 2 mars 2022 sur sqlservercentral.com
 

The post Eight Azure SQL configurations you may have missed appeared first on SQLServerCentral.

Join us at SQLBits, March 8-12

Publié le 2 mars 2022 sur sqlservercentral.com
 

The post Join us at SQLBits, March 8-12 appeared first on SQLServerCentral.

Building PollGab.com: Designing the Data Model

Publié le 1 mars 2022 sur brentozar.com
 

In the last post, I talked about how Richie and I sketched out the goals of PollGab.com, the site where you can post questions for other folks to answer during their live streams. I challenged you to decide: What data needs to be stored to make all thi …

Building PollGab.com: Design a Database for Live Session Questions

Publié le 28 février 2022 sur brentozar.com
 

Years ago when we did online presentations or live Office Hours webcasts, attendees would type their questions into the “Questions” section of whatever webcast platform we were using – WebEx, GoToWebinar, Zoom. This sucked because: Pe …


Pages :