Sites anglophones


SQL 101 Learn SQL. Not too much. Mostly online.

Publié le 21 août 2017 sur sqlblog.com
 

I’ve had people ask me how to learn SQL without installing a database. This past Sunday afternoon I saw a packed class of current and aspiring data scientists learn SQL in a great class taught by Ted Petrou . You can indeed learn SQL for free wit …

SQL Server 2017: Potentially Interesting New Extended Events

Publié le 21 août 2017 sur brentozar.com
 

You still won’t use them And I predict that Extended Events will remain as niche-only use for specific troubleshooting scenarios. Very few monitoring tools use them, and the ones that do still rely on traces and DMV queries for the bulk of their …

Extending DevOps practices to SQL Server databases with Redgate, Git & Jenkins

Publié le 21 août 2017 sur sqlservercentral.com
 

Join Microsoft Data Platform MVP, Grant Fritchey, for our next Database DevOps demo webinar. He’ll be plugging Redgate’s tools into Git and Jenkins to show you how Redgate’s Database DevOps solution helps you build, test and deploy your dat …

Azure DWH part 14: PolyBase to access to non structured data

Publié le 21 août 2017 sur sqlservercentral.com
 

In this article, we will learn how to work with PolyBase using Azure SQL DWH.

SQL Server Management Studio – New Feature – Object Explorer Query Tracking

Publié le 21 août 2017 sur journey to sqlauthority
 

A few days ago, I wrote a blog about a new feature in SSMS and I got few emails asking me to share such quick and fresh information. You can read my earlier blog here SQL Download – SQL Server Management Studio (SSMS) – Performance Das …

Upgrading SQL Server–Replacing Slow Hardware Part 2

Publié le 21 août 2017 sur sqlskills.com - glen berry
 

Previously, we talked about the single-threaded performance, CPU capacity and hardware cost difference between an extremely poor server model and processor SKU choice and a much better server model and processor SKU choice from about three and a half y …

How to Allow Only Alphabets in Column? – Interview Question of the Week #136

Publié le 20 août 2017 sur journey to sqlauthority
 

Question: How to Allow Only Alphabets in Column? Answer: This was a real world scenario and I have mixed feeling about this kind of question being asked in interviews. However, let us accept this question as it is and let us see how to solve this …

Upgrading SQL Server–Replacing Slow Hardware

Publié le 19 août 2017 sur sqlskills.com - glen berry
 

One unfortunately common scenario is a situation where someone made a very poor processor choice sometime in the past for a database server that runs a mission critical workload. When I do health checks for SQLskills, I encounter both good processor ch …

SQL SERVER – 3 Different Usage of DBCC SQLPERF

Publié le 19 août 2017 sur journey to sqlauthority
 

Have you ever wondered what does DBCC SQLPERF do in SQL Server? Well, I have often thought about it and here is the most simple answer for the same. Method 1: Displays the LogSpace This method displays the current size of the transaction log and t …

Tech Outbound SQL Cruise 2017 Mid-Week Update

Publié le 18 août 2017 sur sqlmag.com
 

Midweek Update on SQL Cruise Alaska 2017 read more

Upgrading SQL Server–Compelling Upgrade Arguments

Publié le 18 août 2017 sur sqlskills.com - glen berry
 

Over the course of my career, I can’t remember too many people coming to me and initiating the conversation about upgrading to a new version of SQL Server, a new version of Windows Server or a new set of server hardware and storage. As a DBA, Dat …

Using the Copy Wizard for the Azure Data Factory

Publié le 18 août 2017 sur simple-talk.com
 

The series so far: Creating a Custom .NET Activity Pipeline for Azure Data Factory Using the Copy Wizard for the Azure Data Factory Azure Data Factory is the integration tool in Azure which allows us to move data around in preparation for its storage a …

What If Week: What Would You Add?

Publié le 18 août 2017 sur brentozar.com
 

For this week’s What If series, we’re exploring what would happen if you had access to SQL Server’s source code – like if you got a job at Microsoft, signed a partner NDA, if the code leaked, or if it went open source. Today …

SQL SERVER – Cluster Patching: The RPC Server is Too Busy to Complete This Operation

Publié le 18 août 2017 sur journey to sqlauthority
 

If you have ever contacted me via email, you would know that I am very active in replying to emails. Many of the emails are for suggestions and I don’t get much time to help everyone, but I do reply to them letting them know the alternatives. If …

Upgrading SQL Server–Day 17

Publié le 17 août 2017 sur sqlskills.com - glen berry
 

As I discussed yesterday, it is sometimes possible to experience performance regressions after upgrading to a new version of SQL Server, even when it is running on a new, presumably faster database server. This is much less likely to happen if you have …


Pages :