Sites anglophones


Synchronously Refreshing a Power BI Dataset using Azure Logic Apps

Publié le 25 décembre 2019 sur sqlservercentral.com
 

The post Synchronously Refreshing a Power BI Dataset using Azure Logic Apps appeared first on SQLServerCentral.

Learn PostgreSQL – New Technology Week

Publié le 24 décembre 2019 sur journey to sqlauthority
 

This is the last week of the year and most places it is a holiday. While we learn about SQL Server entire year, let us get out of the comfort zone and learn about different technology every day of the week. Today we will discuss where we can learn Post …

Performance Tuning Using Extended Events: Part 2

Publié le 23 décembre 2019 sur sqlservercentral.com
 

Performance tuning is the process of analyzing query plans, execution plans, indexes, partitioning, etc. and finding ways to reduce the time a query takes or reduce resource usage by that query. There are four events that I found can help you to i …

My Home Office Studio Setup: Winter 2019

Publié le 23 décembre 2019 sur brentozar.com
 

I run a lot of online training classes, and some of you who do webcasts from home might be interested to see how all this works. I did pretty well this year, so I upgraded my home office setup to sneak some expenses in on my taxes. Here’s what I …

Learn MariaDB – New Technology Week

Publié le 23 décembre 2019 sur journey to sqlauthority
 

This is the last week of the year and most places it is a holiday. While we learn about SQL Server entire year, let us get out of the comfort zone and learn about different technology every day of the week. Today we will discuss about where we can lear …

Querying database schema using graph tables

Publié le 23 décembre 2019 sur sqlservercentral.com
 

SQL Server 2017 introduced the concept of graph data tables as part of the SQL Server database engine. With SQL Server 2019, there were some enhancements like ‘shortest path’ function and constraints on edge tables that make this feature mo …

SQL Prompt by Keyboard

Publié le 23 décembre 2019 sur sqlservercentral.com
 

The post SQL Prompt by Keyboard appeared first on SQLServerCentral.

How to Restore Model Database in SQL Server

Publié le 23 décembre 2019 sur sqlservercentral.com
 

The post How to Restore Model Database in SQL Server appeared first on SQLServerCentral.

Can Admin Rename SA Account in SQL Server? – Interview Question of the Week #256

Publié le 22 décembre 2019 sur journey to sqlauthority
 

Question: Can Admin Rename SA Account in SQL Server?Answer: Yes, of course. The syntax for to rename SA account is very simple:Can Admin Rename SA Account in SQL Server?ALTER LOGIN sa WITH NAME = [SQLAuthority]Every single time when I ask this question …

SQL SERVER – Parameter Sniffing and OPTIMIZE FOR UNKNOWN

Publié le 21 décembre 2019 sur journey to sqlauthority
 

I consider myself fortunate that I often receive a follow-up question from my earlier blog posts. Today we will discuss Parameter Sniffing and OPTIMIZE FOR UNKNOWN. In the earlier blog post, I had discussed how one can avoid the parameter sniffing by d …

Database Security, People and Processes

Publié le 20 décembre 2019 sur simple-talk.com
 

Database developers and DBAs can use many “mechanical” security mechanisms to safeguard corporate data. Robert Sheldon has written an excellent six part Introduction to SQL Server Security covering most of them. However, DBAs know that thes …

SQL SERVER – Parameter Sniffing and Local Variable in SP

Publié le 20 décembre 2019 sur journey to sqlauthority
 

After reading yesterday’s blog post about SQL SERVER – Parameter Sniffing Simplest Example, I received a follow-up question from my client with whom I have worked earlier in a recent consulting engagement of Comprehensive Database Perf …

Overview of Azure SQL Database Networking

Publié le 20 décembre 2019 sur sqlservercentral.com
 

The post Overview of Azure SQL Database Networking appeared first on SQLServerCentral.

Voting Open for #SQLBits Sessions, and Here’s My Oddball Idea

Publié le 19 décembre 2019 sur brentozar.com
 

Voting is open now for SQLBits sessions, and I have to warn you that there are a LOT of sessions to choose from. Bits doesn’t just flat out take the top vote-getting sessions – they use votes as part of the session selection factor – …

Wait statistics workshop at SQLBits in London 2020 – finally!

Publié le 19 décembre 2019 sur sqlskills.com - paul randall
 

We’re coming to SQLBits finally! Both Kimberly and I will be there for the first time in London in March/April – at long last the dates work for us – plus Erin will be there again too. The training day schedule for the conference …


Pages :