Sites anglophones


Getting Started with Azure Data Studio and SQL Server 2019 Preview

Publié le 28 mars 2019 sur sqlmag.com
 

SQL Server 2019 is in the final rounds of Community Technology Previews, and if I wasn’t excited about it before, I definitely am now.

How to Prepare for SQL Server 2008 and 2008 R2 End of Support

Publié le 28 mars 2019 sur sqlmag.com
 

Microsoft is set to end support for SQL Server 2008 and SQL Server 2008 R2 in July. Are you ready?

SQLintersection Spring 2019

Publié le 28 mars 2019 sur sqlskills.com - paul randall
 

As we head towards our SQLintersection Spring 2019 in June (our 13th show), I’m excited to say that it’s once again our most diverse, complete, and information-packed show yet! One of the pieces of feedback we hear over and over is that att …

Registration Open for My SQLSaturday Sacramento Workshop

Publié le 28 mars 2019 sur brentozar.com
 

I’m coming to Sacramento this year for SQLSaturday #885. On Friday, I’ll be teaching a one-day pre-con: Performance Tuning in 21 Demos – You’re a developer or DBA who wants to tune indexes and queries to make your applicati …

Based in Dallas, TX? Join Redgate and Braumiller Law Group at their GDPR event tonight.

Publié le 28 mars 2019 sur sqlservercentral.com
 

Join the FACC DFW for a night of innovation and European-American networking across industries. We invite you to a discussion with experts from Braumiller Law Group and Redgate Software UK to help answer your questions and learn about GDPR in copious c …

Breaking the 4th Wall with Unity

Publié le 28 mars 2019 sur sqlservercentral.com
 

Even when creating games, your code has access to environment variables and document files. In this article, Lance Talbert shows how to access files to convince the player that maybe the game knows more than it should.

Offline R Services installation and patching

Publié le 28 mars 2019 sur sqlservercentral.com
 

The R Services installation package is not included in the MS SQL Server installation package. When you install MS SQL Server with R Services the installer actually download the package from the Internet.

Consulting 104 – Why Do I Give All the Performance Tuning Scripts to My Customers? – SQL Server Performance Tuning

Publié le 28 mars 2019 sur journey to sqlauthority
 

This is the fourth of my 5 part series on my over 10 years of experience in Comprehensive Database Performance Health Check consulting engagement. Here are the five blog posts which are the essence of my consulting business. You can also call it my bus …

Should we use stored procedures or queries built in the app?

Publié le 27 mars 2019 sur brentozar.com
 

A client asked a great architecture question that deserved its own blog post: Should we use more “stored procedures” for select, insert, update, delete or should that just be sent as queries from the application? If you ask a junior databas …

Indexes with Included Columns: Stairway to SQL Server Indexes Level 5

Publié le 27 mars 2019 sur sqlservercentral.com
 

Included columns enable nonclustered indexes to become covering indexes for a variety of queries, improving the performance of those queries and with the only overhead being an increase the size of an index.

Create Azure Data Lake Linked Service Using Azure Data Factory

Publié le 27 mars 2019 sur sqlservercentral.com
 

In this article we walk through a step-by-step example on how to create an Azure Data Lake Linked Service in Azure Data Factory v2.

Consulting 103 – Why Do I Assure SQL Server Performance Optimization in 4 Hours? – SQL Server Performance Tuning

Publié le 27 mars 2019 sur journey to sqlauthority
 

This is the third of my 5 part series on my over 10 years of experience in  Comprehensive Database Performance Health Check consulting engagement. Here are the five blog posts which are the essence of my consulting business. You can also call it a …

How to Determine Activity on Each Processor in SQL Server

Publié le 26 mars 2019 sur sqlmag.com
 

The contents of the SELECT, WHERE and ORDER BY clauses are all a matter of determining the story you need to tell.

Uploading On-Premises Data as JSON to Azure Blob Storage using SSIS

Publié le 26 mars 2019 sur sqlservercentral.com
 

SQL Server Integration Services (SSIS) provide a broad set of tools for working with data, mostly for ETL scenarios, but you can use it for other tasks, as data movement or monitoring solutions. Packages are stored as .dtsx files, and you use SQL Serve …

What Are You Going to Do About SQL Server 2008?

Publié le 26 mars 2019 sur brentozar.com
 

Last week, you used SQL ConstantCare® to analyze 2,396 SQL Servers across a variety of versions: Alas, poor SQL Server 2008 15% (362 instances) of SQL Server 2008 and 2008 R2 18% (438) SQL Server 2012 27% (650) SQL Server 2014 32% (777) SQL Server …


Pages :