Sites anglophones


Redgate Data Tools in Visual Studio 2017 Enterprise

Publié le 9 mars 2017 sur sqlservercentral.com
 

Today during the Visual Studio launch event, we announced that we’ve partnered with Redgate to include Redgate Data Tools in Visual Studio 2017. Redgate Data Tools includes three components that extend DevOps practices to SQL Server and Azure SQL …

SQL Migrator (Part 2)

Publié le 9 mars 2017 sur sqlservercentral.com
 

Automated UpgradeMigration Tool for 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 bottlenecks, including …

How to work with the command line in Azure SQL Data Warehouse

Publié le 9 mars 2017 sur sqlservercentral.com
 

This time we will work with the sqlcmd to handle our Azure SQL Data Warehouse

SQL SERVER – FIX : Msg 35295, Level 16 – Log Backup For Database ‘DBName’ on a Secondary Replica Failed

Publié le 9 mars 2017 sur journey to sqlauthority
 

Once, while doing a load testing with my client, I was shown below error while taking log backups on secondary replica. Msg 35295, Level 16, State 1, Line 1 Log backup for database “MyAppDB” on a secondary replica failed because the last ba …

Parsing SSIS Catalog Messages for Lookup Performance, v2

Publié le 8 mars 2017 sur sqlblog.com
 

A couple years ago I wrote Administering SSIS: Parsing SSIS Catalog Messages for Lookups . I’ve updated the script to return all Lookup Transformation performance messages captured by the SSIS Catalog with Basic logging enabled (the SSIS Catalog …

Using the DbFit Framework for Data Warehouse Regression Testing

Publié le 8 mars 2017 sur simple-talk.com
 

How do you, or should you, automate database testing? If you have a technique for doing so, how can you extend this for testing a data warehouse? How easy is it to use? There are some established tools that are designed for testing databases, and the F …

Encrypting SQL Server: Dynamic Data Masking

Publié le 8 mars 2017 sur simple-talk.com
 

SQL Server 2016 introduced dynamic data masking (DDM) as a way to prevent unauthorized users from viewing certain types of sensitive information. The database engine masks the data when it is retrieved from the database, based on masking rules defined …

New White Paper: How to Build an Always On Availability Group in Google Compute Engine

Publié le 8 mars 2017 sur brentozar.com
 

You’re a database administrator, Windows admin, or developer. You want to build a Microsoft SQL Server environment that’s highly available, and you’ve chosen to use Always On Availability Groups. Our newest white paper – downloa …

SQL Migrator (Part 1)

Publié le 8 mars 2017 sur sqlservercentral.com
 

Read about a free automated UpgradeMigration Tool for SQL Server.

Move Azure SQL Databases using the Export and Import PowerShell cmdlets

Publié le 8 mars 2017 sur sqlservercentral.com
 

John Miner shows how to move databases between a cloud development environment and an on-premise production environment using PowerShell cmdlets.

TempDB Database On a Local Disk for an FCI

Publié le 8 mars 2017 sur sqlservercentral.com
 

The article is about Configuring TempDB Database on Local Disk in SQL Server 2012/2014 Failover Cluster to improve performance. How to fix SQL Server disk I/O bottlenecks (without a hammer)In this new article, Simple-Talk editor Tony Davis explains ste …

SQL SERVER – Queries are in KILLED/ROLLBACK State with Wait PREEMPTIVE_OLEDB_RELEASE

Publié le 8 mars 2017 sur journey to sqlauthority
 

There are many wait types in SQL Server and not all of them are documented. Long ago I wrote blog on PREEMPTIVE and Non-PREEMPTIVE waits. SQL SERVER – PREEMPTIVE and Non-PREEMPTIVE – Wait Type – Day 19 of 28. In this blog post we …

SQLintersection Spring 2017

Publié le 8 mars 2017 sur sqlskills.com - paul randall
 

As we head into our 9th SQLintersection in May, 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 attendees love SQLintersection …

50 online SQL Server training courses and a free trial

Publié le 7 mars 2017 sur sqlskills.com - paul randall
 

With the publication of our most recent Pluralsight course last month, we now have a whopping 50 online training courses available through Pluralsight, totally more than 150 hours of content. If you’re unable to come to one of our in-person Immer …

In the Cloud: Visual Studio 2017

Publié le 7 mars 2017 sur sqlblog.com
 

Visual Studio 2017 has new functionality to help you build apps for both on-premise and cloud solutions. The screen capture of the Visual Studio 2017 Enterprise installer shows a different interface than the previous several versions of Visual Studio h …


Pages :