Sites anglophones


 

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.

Randomizing the Day Inside a Month Using T-SQL

Publié le 24 juin 2022 sur sqlservercentral.com
 

I recently ran across an interesting situation in our development databases. We have begun to protect various PII information in our systems by running scripts in the development databases when we restore a production backup. We do this as we have had …

DevOps 101 webinar: The role of Automation

Publié le 24 juin 2022 sur sqlservercentral.com
 

The post DevOps 101 webinar: The role of Automation appeared first on SQLServerCentral.

I Wish SQL Server Warned About Hard-Coded Estimates.

Publié le 23 juin 2022 sur brentozar.com
 

I wish we got a yellow bang on execution plans when SQL Server was making up an estimate out of thin air. I’ll give you an example: if you compare two columns on the same table, looking to find rows where they’re equal, SQL Server has a har …


Pages :