Sites anglophones


Hack-Attaching a SQL Server database with NORECOVERY

Publié le 24 janvier 2017 sur sqlblog.com
 

Let me just start this post with a huge disclaimer/warning: what I’m about to show you in this post is NOT SUPPORTED by Microsoft at all. It’s a hack, and it might not work whatsoever in your environment.But I think it’s pretty cool.You might …

Analyzing Temporary Stored Procedures with sp_BlitzCache

Publié le 24 janvier 2017 sur brentozar.com
 

All the cool kids Know that when you’re trying to figure out why a stored procedure is slow sometimes, you should use a temporary stored procedure instead of pulling the code out and running it ad hoc. We frequently point people to Erland Sommars …

Year-over-year comparison using the same number of days in #dax

Publié le 24 janvier 2017 sur sqlblog.com
 

When you use the time intelligence functions in DAX, it is relatively easy to filter the same dates selection in the previous year by using the SAMEPERIODLASTYEAR or DATEADD functions. However, if you follow the best practices, it is likely that you ha …

Using Power BI and SSRS for visualizing SQL Server and R data (Part 4)

Publié le 24 janvier 2017 sur sqlservercentral.com
 

Using R with Power BI, SSRS or RTVS for easier data visualization 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 bott …

SQL Server – When to Use a Sledgehammer and When to use a Screwdriver

Publié le 24 janvier 2017 sur journey to sqlauthority
 

Some organizations use SQL Server Always On Availability Groups to help boost performance of applications where the users are geographically dispersed. They accomplish this by placing the secondary database in the same facility as the remote users. Whi …

SQL Server Management Studio Version 16.5.2 Now Available for Download

Publié le 23 janvier 2017 sur sqlmag.com
 

The latest release from the SQL Server product group at Microsoft has just gone public and is available for download today. Read on to see what has changed. read more

SSIS Catalog Compare v2.0 Launch Event 7 Mar 2017!

Publié le 23 janvier 2017 sur sqlblog.com
 

The Data Integration Lifecycle Management Suite ( DILM Suite ) helps SSIS Developers and Database Administrators manage SQL Server Integration Services (SSIS) deployments in the enterprise lifecycle. Join Kent Bradshaw and me at 1:00 PM EST 7 Mar 2017 …

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

Publié le 23 janvier 2017 sur brentozar.com
 

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 sqlservercentral.com
 

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 sqlservercentral.com
 

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 sqlservercentral.com
 

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 sqlblog.com
 

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 sqlblog.com
 

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 …


Pages :