Wu Paul

41 Flips | 1 Magazine | 15 Likes | 1 Following | @WuPaul | Keep up with Wu Paul on Flipboard, a place to see the stories, photos, and updates that matter to you. Flipboard creates a personalized magazine full of everything, from world news to life’s great moments. Download Flipboard for free and search for “Wu Paul”

Is SQL Server Always Encrypted, for sensitive data encryption, right for your environment?

So, your manager wants you to figure out how to encrypt sensitive Data? Well, Microsoft has introduced a fairly easy way to configure feature called …

Databases

Understanding a SQL Server execution plan

How do you read execution plans? From right to left, left to right, or by checking out costs? Or what about objects like index scans, table scans, …

Newly Introduced Additional Features of SQL Server 2017

SQL Server 2017SQL Server 2017 is launched with too many features. One of the most awaited and advantageous features of this version of SQL Server …

Load data from PDF file into SQL Server 2017 with R

By: Siddharth Mehta | Read Comments (3) | Related Tips: More > SQL Server 2017<p>Problem<p>Portable Document Format (PDF) is one of the most prominent …

When to Use Row or Page Compression in SQL Server

A colleague asked me a very simple question: "How do I know to use row or page compression in SQL Server?" That's what this post is for, to help …

SQL Servers Assessment for the Meltdown and Spectre Vulnerabilities

In this tip we will provide a Meltdown/Spectre SQL Server Assessment Script that you can run against all of your SQL Servers to check for issues.

Databases

Intel AMT 發現新漏洞,只要 30 秒駭客就可掌控你的電腦

屋漏偏逢連夜雨,2018 年對 Intel 可說流年不利,面對 CPU 的 Meltdown 和 Spectre 漏洞急於推出解決方案,現在又被資安人員發現 AMT 也有嚴重漏洞,攻擊者不用 30 秒就可以得逞,全球數百萬台商務筆記型電腦都有可能淪陷。<p>來自芬蘭的網路資訊安全公司 F-Secure 報 …

Run SQL Server 2017 on Linux or Windows. For a limited time, get a discounted rate and install SQL Server on Linux with full Microsoft support and security.

Vin Yu, Program Manager<p>Join us for this session for an overview of the common operational tasks on SQL Server on Linux. These tasks help keep your …

Databases

Use SQL Server 2017 in Docker Containers

Are you interested in automating your database development process by using containers? This video presents the basics of running SQL Server 2017 in …

Installing SQL Server 2016 on a Windows Server 2016 Failover Cluster without Shared Storage - Part 2

By: Edwin Sarmiento | Read Comments (5) | Related Tips: More > Clustering<p>Problem<p>We are planning on deploying a SQL Server 2016 failover clustered …

premises SQL Server!

I am delighted to announce the public preview of our latest security development from the Microsoft SQL product team, the new SQL Vulnerability …

Bulk Copy Data from Oracle to SQL Server

By: Jeffrey Yao | Read Comments (3) | Related Tips: More > PowerShell<p>Problem<p>Copying data from an Oracle table to a SQL Server table is not as simple …

Databases

Read all errors and warnings in the SQL Server Error Log for all versions

By: Pablo Echeverria | Read Comments | Related Tips: More > Error Logs<p>Problem<p>A DBA is often required to setup monitoring on their SQL instances to …

Databases

SQL Server Best Practices, Part I: Configuration

Am I the only one who finds the Microsoft SQL server best practice guides to be a little painful to trawl through? Somehow, I doubt it. After being …

Databases

SQL Server 2017 on Windows Linux and Docker is now generally available

<b>Resumable online index rebuild</b> lets you stop and start index maintenance. This gives you the ability to optimize index performance by re-indexing …

Overview of Database Engine Changes in SQL Server 2017

By: Aaron Bertrand | Read Comments (3) | Related Tips: More > SQL Server 2017<p>Problem<p>On October 2nd, SQL Server 2017 became generally available; …

Databases

SQL Server 2017: Fast, faster, and the fastest database everywhere you need it

<i>This post was authored by Bob Ward, Principal Architect, Database Systems Group</i><p>“I feel the need, the need for speed”. That is a quote from the …

Tips on how to build your first SQL Server container

Follow:<p>Support for containers is one of the most important new features in Windows Server 2016 and, in turn, SQL Server....<p>And if you're looking to …

Setup Environment Variables in SQL Server Integration Services 2016

Attend this free live MSSQLTips webcast<p><b>SQL Server MVPs and Industry Experts Share Their Database Secrets</b><br>Thursday, June 28, 2018 - click here to learn …

SQL Server 2017 on Linux surpasses 1 million Docker pulls as the next preview version rolls out

<i>This post was authored by Rohan Kumar, General Manager, Database Systems Group</i><p>SQL Server 2017 makes it easier and simpler to work with data, with …

SQL Server does not use all assigned CPUs on VM

By: Kun Lee | Read Comments (1) | Related Tips: More > Virtualization<p>Problem<p>As Virtual Machines (VMs) are getting more powerful, we have been …

SQL Servers

Getting Started with SQL Server on Linux

By: John Miner | Read Comments (6) | Related Tips: More > SQL Server on Linux<p>Problem<p>Some companies have been deploying tier one mission critical …

Migrating a Disk-Based Table to a Memory-Optimized Table in SQL Server

In-Memory OLTP, also known as Hekaton, can significantly improve the performance of OLTP (Online transaction processing) database applications. It …

Databases

New features and enhancements in SQL Server 2016 SP1

SQL Server 2016 SP1 is released as announced by Microsoft. It comes with a bunch of new features and enhancements as a result of customer and …

Considerations for SQL Server on Linux

In this post, I give an overview of SQL Server on Linux, giving out a few ideas and tips for beginners.

Linux

SQL Server differences of char, nchar, varchar and nvarchar data types

By: Sherlee Dizon | Read Comments (3) | Related Tips: 1 | 2 | 3 | More > Data Types<p>Problem<p>The differences of SQL Server char, nchar, varchar and …

Databases