Sites anglophones


Masking your on-premise database with SQL Data Mask

Publié le 24 mai 2017 sur sqlservercentral.com
 

In the last update from Redgate Foundry three weeks ago, they announced their intention to build a version of SQL Data Mask that would mask on-premise SQL Server databases, as well as Azure SQL Databases. They’re pleased to say this version of the prot …

Stairway to Columnstore Indexes Level 12: Clustered or Nonclustered?

Publié le 24 mai 2017 sur sqlservercentral.com
 

The previous levels of this stairway describe details, features, and limitations of columnstore indexes in SQL Server. But they do not answer what should be the first question for every database professional: should columnstore indexes be used in my da …

SQL SERVER – How to Find Row Count of Every Table in Database Efficiently?

Publié le 24 mai 2017 sur journey to sqlauthority
 

Question: How to Find Row Count of Every Table in Database Efficiently? Answer: There are some questions which are evergreen. I recently asked this question in the interview and user answered me that I can find this by looping over every single table i …

From ElasticSearch back to SQL Server

Publié le 24 mai 2017 sur sqlblog.com
 

Sharing with the community why we decided to move back from ElasticSearch to SQL Server Sometimes it happens: you move to something that is considered cool and bleeding edge back to something that has dust over it. Well, at least this is how SQL Server …

Azure database_id inconsistencies

Publié le 23 mai 2017 sur sqlblog.com
 

I am working on improvements to my SQL ExecStats tool, including Azure support. Previously, I had put try catch blocks around everything that bombs in Azure. Now I am putting IF EXISTS tests around SQL referencing system views and procedures not in Azu …

SQL Server User-Defined Functions

Publié le 23 mai 2017 sur simple-talk.com
 

User-Defined Functions are an essential part of T-SQL. They aren’t, however, quite like functions in a procedural language, or even the built-in system functions such as GetDate(). It is tempting to use them to write SQL code that conforms to goo …

Simple SQL: Attribute Splitting

Publié le 23 mai 2017 sur simple-talk.com
 

If you make the mistake of splitting an atomic data value in some way in the design of a database, you can make life very difficult for anyone doing the subsequent DML. This is one of the reasons why I tell people that 85% to 95% of the work in RDBMS i …

How to document multiple SQL Server databases using SQL Doc and PowerShell

Publié le 23 mai 2017 sur sqlservercentral.com
 

You can use SQL Doc’s command-line parameters to automate database documentation, but when you try with a group of databases on a server, they sometimes don’t give you enough control over the job. Phil Factor provides a solution that allows …

Yet another SSIS XML Destination

Publié le 23 mai 2017 sur sqlservercentral.com
 

See a simple script to generate an XML file in SSIS.

SQL SERVER- Error: 18204, Severity: 16 – Backup Failure – Operating System Error 1240 (The Account is not Authorized to Log in From This Station)

Publié le 23 mai 2017 sur journey to sqlauthority
 

Whenever you are into a business of “fixing the issue” – you should always find in error message first. The whole approach of solving the issue changes if we go behind the wrong error message. Let us learn about the error Backup …

#DevIntersection Keynote Notes: Jeffrey Snover on Azure Stack

Publié le 22 mai 2017 sur brentozar.com
 

Preface: data professionals, if you’re in a hurry, skip this post. Nothing in here is directly relevant to your career in the next couple of years. I found it interesting because it explains where Microsoft’s developer story is going, thoug …

This Year is Your Best Chance to Speak at the PASS Summit.

Publié le 22 mai 2017 sur brentozar.com
 

Me presenting, photo by John Martin The call for speakers at the PASS Summit is open now. As of this writing, there are less than 120 sessions submitted. To put that in perspective, in 2016, there were 758 sessions submitted overall, and about ~175 gen …

Chief Data Officer Playbook: How to Be Successful in This Ground-Breaking Role

Publié le 22 mai 2017 sur sqlmag.com
 

Companies looking to grow and extract value from their data are increasingly turning to Chief Data Officers (CDOs) to execute their data strategy. The role is new, and a playbook is necessary to address the many challenges CDOs face. read more

Azure DWH part 9: Azure PHP and ASDW

Publié le 22 mai 2017 sur sqlservercentral.com
 

In this new Azure Data Warehouse article, we will show how to insert data and retrieve it using PHP.

Step-by-step Installation of SQL Server 2016 on a Windows Server 2016 Failover Cluster – Part 4

Publié le 22 mai 2017 sur sqlservercentral.com
 

Continuing his series covering a step-by-step Installation of SQL Server 2016 on a Windows Server 2016 Failover Cluster, Edwin Sarmiento looks at adding a node to an existing SQL Server 2016 failover clustered instance (FCI).


Pages :