Sites anglophones


Implementing DevOps Doesn’t Get Rid of Database Administrators

Publié le 21 janvier 2019 sur simple-talk.com
 

I hear from a lot of database administrators who are worried about being automated out of a job. These kinds of worries are not new. Over the course of my career, I’ve seen CTOs outsource large groups of IT jobs to different regions around the wo …

Which Version of SQL Server Should You Use?

Publié le 21 janvier 2019 sur brentozar.com
 

Wait! Before you install that next SQL Server, hold up. Are you sure you’re using the right version? I know, management wants you to stay on an older build, and the vendor says they’ll only support older versions, but now’s your chanc …

The 4 capabilities you need to introduce true database DevOps

Publié le 21 janvier 2019 sur sqlservercentral.com
 

The latest Accelerate State of DevOps Report from DORA concludes that successful software delivery unlocks competitive advantages, including “increased profitability, productivity, market share, customer satisfaction and the ability to achieve or …

SQL SERVER – FCB::Open Failed – TEMPDB Files Fail to be Created with Error: “CREATE FILE Encountered Operating System Error 3”

Publié le 21 janvier 2019 sur journey to sqlauthority
 

Once there was an urgent request from my client and they asked my assistance. Without wasting any time, I sent them GoToMeeting invite and started working. In this blog we would learn how to fix FCB:: Open failed for TempDB database. As soon as I joine …

Does NOLOCK Really Applies No Lock? – Interview Question of the Week #209

Publié le 20 janvier 2019 sur journey to sqlauthority
 

Question: Does NOLOCK Really Applies No Lock? Answer: The answer is NOLOCK do apply the lock and it is Sch-S lock. Sch-S stands for Schema Stability. Quite a few people say it is actually Schema Shared lock and it is not correct. Sch-S or Schema Stabil …

SQL Server Data Migration: Tools and Services

Publié le 19 janvier 2019 sur sqlblog.com
 

The Database Migration Team of the SQL Server Product Group has created the following tools and services to facilitate migration between different versions of SQL Server or between on-premises and SQL Azure DB in the cloud (but not only)! Azure Da …

Why Attend 21 Essential Scripts: Performance Tuning for EVERYONE?

Publié le 19 janvier 2019 sur journey to sqlauthority
 

After sending out the previous email where I explained that anyone who will attend SQLBits 2019: Pre-Con – 21 Essential Scripts: Performance Tuning for EVERYONE, will get 1 Hour FREE Consulting Hour, it seems that many of you have signe …

Wanna see Erik Darling as Freddie Mercury at #SQLbits?

Publié le 18 janvier 2019 sur brentozar.com
 

Erik Darling is raising money for the Mercury Phoenix Trust, fighting AIDS worldwide to help save lives. If we raise $5,000, he’ll present his SQLbits indexing session dressed like Freddie Mercury: If I hit my goal on this, I’m gonna deliver my @ …

Win Apple Watch Series 4 and Solve SQL Server Performance Problems

Publié le 18 janvier 2019 sur journey to sqlauthority
 

Ask any DBA what would they love to monitor in their SQL Server and I promise you that you will get quite many different answers to this question. Though every DBA would love to see their server always up upon asked what exactly they would like to watc …

Logging SQL and Change-Tracking Events in EF Core

Publié le 18 janvier 2019 sur sqlservercentral.com
 

Julie Lerman introduces you to the new logging APIs in .NET Core, concentrating on SQL and change-tracking events, with a focus on providers that output to the console and the debugger.

Manipulating Filetable Files Programatically

Publié le 18 janvier 2019 sur sqlservercentral.com
 

Learn how you can work with FileTable files from T-SQL as an alternative to the drag and drop methods of using Windows Explorer

Solve 3 Biggest SQL Server Performance Challenges with Spotlight

Publié le 18 janvier 2019 sur journey to sqlauthority
 

My primary responsibility is to help people with SQL Server Performance Tuning and Optimization, and I believe there are three important challenges any DBA faces. Today we will discuss why I prefer to use Spotlight to identify SQL Server Perf …

New Pluralsight Course Published

Publié le 17 janvier 2019 sur sqlskills.com - glen berry
 

On January 10, 2019, my latest Pluralsight course, SQL Server 2017: Diagnosing Performance Issues with DMVs was published! This makes fifteen courses that I have done for Pluralsight. Here is the official course description: Learn how to easily query S …

Upcoming Free Training Webcasts

Publié le 17 janvier 2019 sur brentozar.com
 

Hey, wanna learn about SQL Server for free? Feb 7 – PASS Data Expert Series: PASS is taking the top-rated Summit 2018 recordings and replaying them live, for free, on a webcast. I’ll be in the chat room too, taking your questions. Register …

Using T-SQL to Fix Bad Data in XML Documents Using FLWOR

Publié le 17 janvier 2019 sur sqlservercentral.com
 

Learn how to use T-SQL to fix contents of an XML document using FLWOR


Pages :