Sites anglophones


[Exclusive] Practical Real World Performance Tuning – Live Training Session for Limited Time

Publié le 12 mars 2018 sur journey to sqlauthority
 

I am happy to announce that the new course Practical Real-World Performance Tuning, along with Brent Ozar (blog) is now live. We are accepting the registration for a limited time. This is very unique opportunity …

Building SQL ConstantCare®: The Vision

Publié le 12 mars 2018 sur brentozar.com
 

We’re starting to roll out a new product, SQL ConstantCare®, and now that we’ve got over 50 customers, it’s time to start sharing some behind-the-scenes details about what we’ve built. Over the next several Mondays, I’ …

Redgate’s support for Azure SQL Database Managed Instances

Publié le 12 mars 2018 sur sqlservercentral.com
 

Last week Microsoft released the public preview of Azure SQL Database Managed Instances – an exciting new option for running SQL Server workloads in the cloud. This blog post explains what they are, and how Redgate’s SQL Toolbelt supports them.

Intervals Part 1 – Definitions and Terms

Publié le 12 mars 2018 sur sqlservercentral.com
 

Learn the basic terms and definitions for intervals in SQL Server. How to fix SQL Server disk I/O bottlenecks (without a hammer)In this new article, Simple-Talk editor Tony Davis explains step-by-step how to find and fix the root causes of disk I/O bot …

Non-Standard Delimiters for Columns and Rows Using SQL Server Bulk Insert

Publié le 12 mars 2018 sur sqlservercentral.com
 

In this tip, Tim Smith looks at how to use bulk insert to load data into SQL Server when the column and row terminators are not what you typically see.

SQL SERVER – Fix Error 3271: A nonrecoverable I/O error occurred on file. The remote server returned an error: (404) Not Found

Publié le 12 mars 2018 sur journey to sqlauthority
 

In SQL Server one error message can be caused due to many reasons. One of such error message is 3271 which is caused during failure of backup to URL command. Here are two earlier blogs about same error message 3271. (404) Not Found. SQL SERVER …

[Video] Office Hours 2018/03/07 (With Transcriptions)

Publié le 11 mars 2018 sur brentozar.com
 

This week, Brent, Erik, Tara, and Richie discuss database restores, opening a case with Microsoft, buying a pre-built server vs building your own, auto-shrinking all databases with a single command, SQL Server dev environment options, the best way to l …

What is Alternative to CASE Statement in SQL Server? – IIF Function – Interview Question of the Week #164

Publié le 11 mars 2018 sur journey to sqlauthority
 

Question: What is Alternative to CASE Statement in SQL Server? Answer: IIF Function. Honestly, when I write this blog post I feel a bit sad that IIF Function has not received necessary adoption since its release in the year 2012. When I am writing this …

How to Back Up SQL Server to Azure Blob Storage

Publié le 10 mars 2018 sur brentozar.com
 

When you’re planning for disaster recovery, offsite backups in the cloud are an attractive option. SQL Server Management Studio makes it easy to back up to the cloud inside the GUI, and you can learn how in just 90 seconds:

SQLAuthority News – 3 Performance Tuning Presentations at SQLBits 2018 – London

Publié le 10 mars 2018 sur journey to sqlauthority
 

I have so far attended many different technology conferences all over the world. SQLBits 2018 is my all time the favorite conference ever. This year, I was fortunate to present 1 Pre-Con and 2 Breakout Sessions on SQL Server subjects. I had r …

I Most Certainly Do Have A Join Predicate

Publié le 9 mars 2018 sur brentozar.com
 

FREAK OUT You wrote a query. You joined tables. You have the right ON clause. You have the right WHERE clause. But the query plan has a problem! BugBurg How Could This Happen To Me? Oh, relax. You’re not crazy. You just assumed the worst. Like me …

The top 7 benefits of DevOps for CIOs

Publié le 9 mars 2018 sur sqlservercentral.com
 

When CEOs consider the benefits of DevOps and whether or not they should introduce it, their viewpoint will be influenced by their ongoing concerns with lowering costs and increasing revenues. As a result, factors like gaining a faster time to market a …

Introduction to the Biml Language

Publié le 9 mars 2018 sur sqlservercentral.com
 

Biml or Business Intelligence Markup Language is an open-source XML dialect to generate Integration Services (SSIS) packages. Take a look at this Biml tutorial to learn how you can use Biml to generate SSIS packages.

SQL SERVER – Fix Error 3271: A nonrecoverable I/O error occurred on file. The remote server returned an error: (403) Forbidden

Publié le 9 mars 2018 sur journey to sqlauthority
 

One of my blog readers contacted me via email for an error message which he was receiving while using the backup to URL feature. Using this feature, SQL Server can take database backup directly to Azure Blob Storage. I have already written a blog about …

Low Latency Memory

Publié le 8 mars 2018 sur sqlblog.com
 

For the last twenty years, the standard practice has been to scale server performance with multi-processor (MP) systems. What is not widely understood is that after processors integrated the memory controller, the initial step from single processor to …


Pages :