Sites anglophones

[Video] Office Hours 2017/01/18 (With Transcriptions)

Publié le 23 janvier 2017 sur

This week, Brent, Erik, Tara, and Richie discuss sp_Blitz capabilities, what’s best to use for resolving SQL performance issues, CDC, tools for capturing wait stats, their favorite monitoring tools, temp tables vs table variables, partitioning wi …

Getting Started with R Services in SQL Server 2016 – Part 2

Publié le 23 janvier 2017 sur

SQL Server 2016 brings native support for doing advanced analytics, using R Services, in the database itself. Arshad Ali takes a look at a detailed conceptual execution flow, executing R scripts from SQL Server Management Studio and other R client tool …

Need to run multiple scripts against multiple servers?

Publié le 23 janvier 2017 sur

Let Chris Yates give you a quick overview of Redgate’s SQL Multi Script to learn more about a quick and easy way to solve the problem. How to fix SQL Server disk I/O bottlenecks (without a hammer)In this new article, Simple-Talk editor Tony Davis expla …

Join Two CSV Files with a Common Column

Publié le 23 janvier 2017 sur

In this example we will join two CSV files with a common column using SQL Server.

SQL SERVER – Script level upgrade for database ‘master’ failed – There is already an object named ‘DatabaseMailUserRole’ in the database

Publié le 23 janvier 2017 sur journey to sqlauthority

SQL Server troubleshooting topics seem to be the most searched for in this blog. In continuation to this, blog for today is also inspired with one such error message. Some time back I have written below blog which talks about the upgrade script mode of …

SQL Data Partners Podcast Episode 79: SSIS Catalog

Publié le 22 janvier 2017 sur

I was honored to be interviewed by Carlos Chacon ( @CarlosLChacon | SQL Data Partners ) and Steve Stedman ( @SqlEmt | Blog ) for the SQL Data Partners podcast . We had a great discussion about the SSIS Catalog . We talked about how the SSIS Catalog wor …

An Example of Data Integration Lifecycle Management with SSIS, Part 3

Publié le 22 janvier 2017 sur

In this post I will demonstrate how to use SSIS Catalog Environments, References,  and Reference Mappings to override SSIS parameter values at execution time. There three sources of SSIS parameter values: Design-time defaults – these are the …

When was Database Last Backed Up in SQL Server? – Interview Question of the Week #107

Publié le 22 janvier 2017 sur journey to sqlauthority

Question: When was Database Last Backed Up in SQL Server? Answer: I had received this question doing my recent training on SQL Server Performance Tuning. Though this training is about performance tuning, I do enjoy answering pretty much all the questio …

SQL SERVER – Generate Live Currency Exchange Rates using dbForge Data Generator for SQL Server

Publié le 21 janvier 2017 sur journey to sqlauthority

When you test an application that implements billing features, meaningful test data is extremely important. This article teaches how to quickly obtain and populate your database with live currency exchange rates in a few simple steps. Let us learn abou …

Handling Graphs in SQL

Publié le 20 janvier 2017 sur

Graph databases can answer several types of questions about data that are difficult with a relational database. They are particularly useful for social networking applications, fraud detection, optimizing LAN topologies, forensic work or any requiremen …

Infrastructure Challenges with Microsoft SQL Server In-Memory Features

Publié le 20 janvier 2017 sur

Sponsored by: Pure Storage Date: Thursday, March 23, 2017 Time: 02:00 PM Eastern Daylight Time Duration: 1 hour read more

Development Delusions: That it is Enough to Build a Better Mousetrap

Publié le 20 janvier 2017 sur

You’ve written a superb, clever, application that you are trying to encourage your colleagues to use. They’re not interested. Why? You’ve neglected the documentation. Surely, the saying goes ‘Build a better mousetrap and the world will beat a path to y …

Data Mining Introduction

Publié le 20 janvier 2017 sur

Many people that work for years with SQL Server never use the Data Mining. This article has the objective to introduce them to this magic and exciting new world.

SQL SERVER – Beautify SQL Code with dbForge SQL Complete

Publié le 20 janvier 2017 sur journey to sqlauthority

Often when you write a large piece of SQL code, it eventually becomes a bit disorganized, or when a big team of developers is working on one project, the code differs between individual developers, the code formatting throughout the project gets incons …

Saving a Few Lines of Code by Performing Multiple Operations in a Single Command

Publié le 20 janvier 2017 sur

I was in Mike Byrd’s session on in-memory technologies the other day and I saw him do something I had never seen and it prompted me to write this blog today. It has nothing to do with in-memory, as the title notes, but has to do with stacking commands …

Pages :