Sites anglophones


SQL Server and Undocumented Extended Procedures

Publié le 3 mars 2020 sur simple-talk.com
 

There are several undocumented stored and extended procedures that Microsoft uses internally in SQL Server. When you start to dig for information on them, the general line from Microsoft is not to use them because they could be removed at any time. Tha …

SQL ConstantCare® Population Report: Winter 2020

Publié le 3 mars 2020 sur brentozar.com
 

Ever wonder what’s “normal” out there for SQL Server adoption rates, hardware sizes, or numbers of databases? Let’s find out. Our SQL ConstantCare® service lets users send data in about their SQL Servers and get health & …

How to Create an Ubuntu PowerShell Development Environment – Part 2

Publié le 3 mars 2020 sur simple-talk.com
 

The series so far: How to Create an Ubuntu PowerShell Development Environment – Part 1 How to Create an Ubuntu PowerShell Development Environment – Part 2 Part 1 of this series covered the need for creating a Linux development environment f …

SQL SERVER – Truncating Data and ANSI_WARNINGS

Publié le 3 mars 2020 sur journey to sqlauthority
 

Today’s blog subject of Truncating Data and ANSI_WARNINGS was accidentally discovered while working on the Comprehensive Database Performance Health Check. Let us talk about the topic.It is very much known that in SQL Server 2019, Microsoft has f …

Knowledge Sharing with SQL Notebooks

Publié le 3 mars 2020 sur simple-talk.com
 

Whether presenting at a conference, to colleagues, or to an academic audience, choosing the best tool to share knowledge can be a challenge. PowerPoint is an effective presentation tool so long as the contents are static and there is no need for demons …

SQL Server Checkpoint Monitoring with Extended Events

Publié le 3 mars 2020 sur sqlservercentral.com
 

The post SQL Server Checkpoint Monitoring with Extended Events appeared first on SQLServerCentral.

Database Build Breakers: Avoiding Constraint Violations during SQL Server Deployments

Publié le 3 mars 2020 sur sqlservercentral.com
 

The post Database Build Breakers: Avoiding Constraint Violations during SQL Server Deployments appeared first on SQLServerCentral.

Text Mining and Sentiment Analysis: Power BI Visualizations

Publié le 2 mars 2020 sur simple-talk.com
 

The series so far: Text Mining and Sentiment Analysis: Introduction Text Mining and Sentiment Analysis: Power BI Visualizations The first article of this three-part series introduced Azure cognitive services Text Analytics API and Power BI. With a team …

Translating a SQL Server Schema into a Cassandra Table: Part II Integrity Constraints

Publié le 2 mars 2020 sur simple-talk.com
 

The series so far: Translating a SQL Server Schema into a Cassandra Table: Part I Problem Space and Cassandra Primary Key Translating a SQL Server Schema into a Cassandra Table: Part II Integrity Constraints  Integrity constraints, including funct …

SQL SERVER – SELECT INTO a Table Variable in T-SQL

Publié le 2 mars 2020 sur journey to sqlauthority
 

Recently one of my oldest clients of Comprehensive Database Performance Health Check asked me a very interesting question about a table variable and SELECT INTO. The question was it is possible to do SELECT INTO a Table Variable in T-SQL? The answer is …

Introduction to STRING_SPLIT function in SQL

Publié le 2 mars 2020 sur sqlservercentral.com
 

Introduction Recently, I was peer-reviewing some scripts written by my team and then I happened to stumble upon an interesting piece of code that I thought would be a good idea to share with the community. The script was a simple scalar-valued function …

New release: Mask SQL Server data 3x faster with Data Masker 7

Publié le 2 mars 2020 sur sqlservercentral.com
 

The post New release: Mask SQL Server data 3x faster with Data Masker 7 appeared first on SQLServerCentral.

Breaking News: SQL Server 2019 CU2 Breaks Agent.

Publié le 1 mars 2020 sur brentozar.com
 

That’s it, I’m rolling back to SQL Server 6.5 You reported it here in the comments, and over at SQLServerUpdates, and in this DBA.StackExchange.com question. The official word is in: yep, SQL Server 2019 Cumulative Update 2 breaks Agent job …

How to Join Two Tables Without Using Join Keywords? – Interview Question of the Week #266

Publié le 1 mars 2020 sur journey to sqlauthority
 

Question: How to Join Two Tables Without Using Join Keywords?Answer: In my life, I have attended many interviews as an interviewer. Sometimes the interview panel is asking progressive positive questions and sometimes they ask a question which is regres …

SQL SERVER – Import Data from Excel

Publié le 29 février 2020 sur journey to sqlauthority
 

One of the very popular questions I receive is how to import data from Excel in SQL Server. Let us learn about that in this blog post and we will use SQL Server Management Studio for this exercise.First, create any sample data in Excel. I will be using …


Pages :