Sites anglophones


How to automatically provision sanitized data using SQL Clone, Data Masker, and PowerShell

Publié le 15 janvier 2018 sur sqlservercentral.com
 

This article describes a strategy, using data masking, cloned databases, and PowerShell, which will allow you to sanitize data before it is copied or moved, for example from a production environment into testing or development environments.

Install Visual Studio 2015 in Server without Internet Connection

Publié le 15 janvier 2018 sur sqlservercentral.com
 

Install Visual Studio 2015 in Windows Server without Internet Connection

SQL SERVER – FIX: Number Data Type from Oracle Linked Sever Shown in Scientific Notation

Publié le 15 janvier 2018 sur journey to sqlauthority
 

One of my clients contacted me for an issue where they reported that they see a problem with numbers when they are accessed via Oracle linked server. Here is the query which they used to demonstrate the issue. IF (OBJECT_ID(‘TEMPDB..#TempDbTempTable’) …

[Video] Office Hours 2018/1/10 (With Transcriptions)

Publié le 14 janvier 2018 sur brentozar.com
 

This week Brent, and Richie discuss validating backups using the backup set table, how to figure out if you’re a Mid-Level or Senior DBA, rollbacks, compatibility modes while upgrading SQL Server versions, MAXDOP settings, and Brent’s car p …

How to Get Top N Records Per Group? – Ranking Function – Interview Question of the Week #156

Publié le 14 janvier 2018 sur journey to sqlauthority
 

Question: How to Get Top N Records Per Group? (using Ranking Function) Answer: During a recent interview, I had given this simple puzzle to over 40 candidates. This simple puzzle depends on Ranking Window Functions. First, let us create a sample r …

SQL SERVER – What Does SET NOEXEC Do?

Publié le 13 janvier 2018 sur journey to sqlauthority
 

Just the other day I received an email with a question – What Does SET NOEXEC Do? I was really happy to read this question as I have been meaning to write a blog post about it but I was just lazy about it. Here is the answer to the ques …

SQL Server 2017 CU3 adds optimizer row goal information in query plans

Publié le 12 janvier 2018 sur brentozar.com
 

Row Whats? Like it or not, the optimizer has row goals. We’re not going to go terribly in-depth here, because the point is just to make you aware that this is in executions plans, and I’ll be adding it to the FRK in an upcoming release. I a …

SQL Saturday Pordenone is back! Discover the 2018 edition!

Publié le 12 janvier 2018 sur sqlblog.com
 

Another SQL Saturday has been scheduled in Pordenone (Italy), it will be the SQL Saturday #707, as last year it will be an international event with international speakers and several sessions in English language!  SQL Saturday Pordenone …

Finding code smells using SQL Prompt: procedures that lack schema-qualification

Publié le 12 janvier 2018 sur sqlservercentral.com
 

It is a very good idea to get into the habit of qualifying the names of procedures with their schema. It is not only makes your code more resilient and maintainable, but as Microsoft introduces new features that use schemas, such as auditing mechanisms …

SQL Server 2017 and Python Basics

Publié le 12 janvier 2018 sur sqlservercentral.com
 

This tutorial from Siddharth Mehta is intended to help experienced T-SQL Developers, DBAs, Data Analysts and Data Science enthusiasts to start using Python language with T-SQL.

Binary Files Import and Export

Publié le 12 janvier 2018 sur sqlservercentral.com
 

Importing binary files is always a challenge in SQL Server. New Author Sergey Benner brings us a technique using bulk loading that has worked well for him.

SQL SERVER – How to Change Column Property From NULL to NOT NULL Value?

Publié le 12 janvier 2018 sur journey to sqlauthority
 

A Very popular question I often here whenever I am presenting at the developer conference – How to Change Column Property From NULL to Not NULL Value? Well, the answer is very simple, however, let us understand that with a simple exampl …

Checking Your Intel Processor Features Regarding the Meltdown Exploit

Publié le 11 janvier 2018 sur sqlskills.com - glen berry
 

By now, you have probably heard plenty about the Spectre and Meltdown exploits that affect many modern processors. The Meltdown exploit (CVE-2017-5754) in particular only affects Intel processors. Microsoft has already patched most of their client and …

Mobile Report Publisher – Dashboards Everywhere

Publié le 11 janvier 2018 sur simple-talk.com
 

When you think about reporting, two tools come to mind: SQL Server Reporting Services (SSRS) and Power BI. SSRS is an excellent choice for detailed, line item style reporting or reports with some basic graphs. You may have heard of this style as pagina …

Quick performance check with latest patches

Publié le 11 janvier 2018 sur sqlblog.com
 

there is some degree of press hysteria, lawsuits etc. concerning the kernel vulnerabilities of Intel processors with out-of-order execution (which originates to Pentium Pro), so I did a quick check. Earlier, I posted on testing with the TPC-H database …


Pages :