Sites anglophones


Browsing SSAS Instance over the internet

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

Problem Developing OLAP cubes have always been fascinating to me. Right after completing the development of a data warehouse, my next line of action often becomes setting up Analysis Services for the warehouse. Although, there are multiple client tools …

2019 review: the year by the numbers

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

The last post of the year! It’s been a really excellent year all round and time for my traditional post counting down some of the numbers and showing some of the photos that have been my (and our) life this year. 1,069,463: my lifetime total butt …

Your Ten Favorite Blog Posts from 2019

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

Here are the 2019 posts you visited the most this year: 10. The Silent Bug I Find in Most Triggers – Once you know how to recognize this bug, you’ll see it everywhere. I wrote the post as an interactive Azure Data Studio notebook, something …

SQL SERVER – DATABASE SCOPED CONFIGURATION – PARAMETER SNIFFING

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

Just a few hours ago, I finished my very last consulting engagement of the year Comprehensive Database Performance Health Check. My client had hired me after reading my recent series on Parameter Sniffing. In this blog post, we will discuss Database Sc …

Blocking Private Messages

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

We have enhanced the SQLServerCentral site to provide a little more security and privacy for users, based on a request from the community. Everyone now has the ability to block unwanted private messages. This post will show how this can be accomplished …

Quickly Find and Mask Sensitive Data with Data Masker 6.3.1

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

The post Quickly Find and Mask Sensitive Data with Data Masker 6.3.1 appeared first on SQLServerCentral.

Move Data from SQL Server to Azure Blob Storage with Incremental Changes – Part 1

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

One of many options for Reporting and Power BI is to use Azure Blob Storage to access source data.  Most of the documentation available online demonstrates moving data from SQL Server to an Azure Database. However, my client needed data to land in …

How to Copy Files in SQL Server? – Interview Question of the Week #257

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

Question: How to Copy Files in SQL Server?Answer: SQL Server 2019 has very interesting features that can make a life of DBA’s and Developers very easy.Here is how you can copy a single file in SQL Server.EXEC master.sys.xp_copy_file ‘D:datatest.t …

2019: the year in books

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

Back in 2009 I started posting a summary at the end of the year of what I read during the year (see my posts from 2009, 2010, 2011, 2012, 2013, 2014, 2015, 2016, 2017, 2018) and people have been enjoying it, so here I …

5 Learning Paths to Learn Technology Online

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

This entire week we have discussed various technology and different learning path where we can learn new technology online. Today we will see the summary post to where we will list all the five different learning paths together.MariaDB Learning PathMar …

Learn SQL – New Technology Week

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

This is the last week of the year and this is the last post in the new technology week. While we learn about SQL Server entire year, the first four blogs we discussed different technology. There are many who reached out to me that they would love to kn …

How to Make SELECT COUNT(*) Queries Crazy Fast

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

When you run a SELECT COUNT(*), the speed of the results depends a lot on the structure & settings of the database. Let’s do an exploration of the Votes table in the Stack Overflow database, specifically the 2018-06 ~300GB version where …

Learn Blogging – New Technology Week

Publié le 26 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 Blog …

ASP.NET Core with GitOps: Deploying Infrastructure as Code

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

The post ASP.NET Core with GitOps: Deploying Infrastructure as Code appeared first on SQLServerCentral.

SQL Server Transparent Data Encryption vs. NetLib Encryptionizer

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

The post SQL Server Transparent Data Encryption vs. NetLib Encryptionizer appeared first on SQLServerCentral.


Pages :