Sites anglophones


 

Boost productivity with ‘Solution Summary’ cards

Publié le 2 juillet 2022 sur simple-talk.com
 

Solution Summary cards are the name I have given to simple 1-page documents we provide to developers to get up-to-speed on a particular solution. The primary use-case for these cards is to provide better on-boarding for new team members. An additional …

 

Implementing ETL Logging on Lakehouse using Delta Lake's Time Travel capability

Publié le 1 juillet 2022 sur sqlservercentral.com
 

The post Implementing ETL Logging on Lakehouse using Delta Lake's Time Travel capability appeared first on SQLServerCentral.

Working with T-SQL function AVG ()

Publié le 1 juillet 2022 sur sqlservercentral.com
 

This article will explain SQL Server average function, AVG(), and its use cases. Many times, we need to find the average value of numeric data stored in a column to address our distinct business requirements. SQL Server offers an aggregate function, AV …

 

Searching through a database via SQL

Publié le 29 juin 2022 sur simple-talk.com
 

Imagine that while developing or testing a SQL Server database, you get an error message mentioning a database object, and you scratch your head, and mutter ‘by the bones of the saints, what is that?’. If it is a small database, then you ca …

 

[Video] Office Hours: Professional Development Questions

Publié le 29 juin 2022 sur brentozar.com
 

Most of the questions y’all post at https://pollgab.com/room/brento are technical ones, but there were a handful of interesting professional development and career ones in the queue, so I cherry-picked those for today’s episode: 00:00 Intro …

SQL Monitor: On-demand demo [Watch now]

Publié le 29 juin 2022 sur sqlservercentral.com
 

The post SQL Monitor: On-demand demo [Watch now] appeared first on SQLServerCentral.

How to tell what SQL Server versions you are running

Publié le 29 juin 2022 sur sqlservercentral.com
 

The post How to tell what SQL Server versions you are running appeared first on SQLServerCentral.

Is Remote Work the New Normal for DBAs?

Publié le 28 juin 2022 sur brentozar.com
 

An intriguing Office Hours question came in through my PollGab room. Anatoli asked, “Is remote work the new normal for DBAs? What are the pros / cons?” I happened to be teaching an online training class yesterday, so I asked my attendees wh …

 

Hybrid Cloud Monitoring

Publié le 28 juin 2022 sur journey to sqlauthority
 

For years database server’s were hosted on either on-premises or colocation data centers. It was straightforward to walk down to the actual host where the server was located and see the blinking lights of the server. However, things started to ag …

 

 

Parameterizing Azure Policy and Ensuring Azure SQL AD Authentication

Publié le 27 juin 2022 sur simple-talk.com
 

I wrote before about enforcing Azure SQL AD Authentication using Azure Policies in two different ways. First, only auditing if the Azure SQL is using AD Authentication or not. Later, automatically enabling the AD Authentication on Azure SQL Servers whe …

 

Now is the Right Time for the 2022 Brent Ozar Unlimited Scholarship Applications.

Publié le 27 juin 2022 sur brentozar.com
 

We normally do this in the fall, but given last week’s news, I bet you can understand why we’re doing this a little early, dear reader. You work at a charity or non-profit, helping them make a difference with data, fights for the rights of …

SQL Server Sample Databases

Publié le 27 juin 2022 sur sqlservercentral.com
 

Northwind, Pubs, Aventureworks, AdventureworksDW, WideWordImporters, etc are important sample databases used in SQL Server. In this article, we will explain these databases and help you to find them, install them and understand them. Also, you will und …

SQL Database Snapshots for Reporting, Auditing and Data Recovery

Publié le 27 juin 2022 sur sqlservercentral.com
 

The post SQL Database Snapshots for Reporting, Auditing and Data Recovery appeared first on SQLServerCentral.

I’m Coming Back to Israel for the Data.TLV Summit!

Publié le 26 juin 2022 sur brentozar.com
 

The Data.TLV Summit on September 15th is a big free conference on data engineering, business intelligence, data analysis, and … beer. I’m excited to announce that I’ll be back in Tel Aviv again for it, and this time I’m teaching …

Python Try Except Code Samples

Publié le 24 juin 2022 sur sqlservercentral.com
 

The post Python Try Except Code Samples appeared first on SQLServerCentral.


Pages :