Sites anglophones


Azure DWH part 26: Creating your ASDW in Cloud Shell using PowerShell

Publié le 15 février 2018 sur sqlservercentral.com
 

In this article, we will show how to create an ASDW in PowerShell using the Cloud Shell.

How to Test SQL Server Functions and Procedures using SQL Prompt

Publié le 15 février 2018 sur sqlservercentral.com
 

When writing functions or procedures, a common chore is to devise and implement the tests that ensure that the routine always works as expected.

SQL SERVER – Don’t Ignore Warning: Cluster Resource DLL Update Restart Check

Publié le 15 février 2018 sur journey to sqlauthority
 

This was one of the hard lessons learned, so I am sharing with blog readers. This is about an error in cluster resource DLL. While applying the patch to SQL instance, I cluster, sometimes we get warning “Cluster Resource DLL Update Restart Check. …

How to Suck at Database Admininstration

Publié le 14 février 2018 sur brentozar.com
 

This isn’t about having a sucky job, this is about you sucking at your job. There’s a big difference. You could be sucking at your job because you hate your job and just don’t care. I get that. In that case though, you know better but …

Calculating DTU’s for Azure SQL Database

Publié le 14 février 2018 sur sqlservercentral.com
 

This calculator will help you determine the number of DTUs for your existing SQL Server database(s) as well as a recommendation of the minimum performance level and service tier that you need before you migrate to Azure SQL Database.

Solving SQL Server Performance Issues Caused by Problematic SQL Queries – The Tools You’ll Need

Publié le 14 février 2018 sur sqlmag.com
 

Date: Wednesday, March 21, 2018Time: 12:00 PM Eastern Daylight TimeDuration: 1 hour The added time it takes to process problematic SQL queries costs significant money. So does the effort to resolve and improve those queries unless you use effective t

SQL SERVER – Unable to Connect to SQL Server in Azure Virtual Machine from SSMS on On-Premise Machine

Publié le 14 février 2018 sur journey to sqlauthority
 

From past few months, I am seeing a few of my client moving their development workload to Cloud. When I asked the reason, it was mostly cost reduction in terms of hardware lifetime, licensing and connectivity advantage and their developer can work from …

T-SQL Tuesday #99: Home Brewing

Publié le 13 février 2018 sur sqlskills.com - glen berry
 

It is T-SQL Tuesday time for February 2018, which is being hosted by Aaron Bertrand. One of the choices that Aaron offered was to write about something you are passionate about, outside of the SQL Server or tech community. T-SQL Tuesday Making Beer at …

#TSQL2sday: What I’m Passionate About – Sas Christian’s Art

Publié le 13 février 2018 sur brentozar.com
 

For this month’s T-SQLTuesday, Aaron Bertrand asked what we’re passionate about – but outside of the tech community, and asked for pictures. Seems like a great way to get to know about us. From my personal blog and my Instagram feed, …

How to monitor the impact of patching on SQL Server performance

Publié le 13 février 2018 sur sqlservercentral.com
 

In this article, Redgate use the Spectre/Meltdown bugs as means to demonstrate how you can use a tool like SQL Monitor to assess the impact of patching on your SQL Server estate. How to fix SQL Server disk I/O bottlenecks (without a hammer)In this new …

Restore a Database with CDC Enabled

Publié le 13 février 2018 sur sqlservercentral.com
 

In this post, I’m going to talk about an issue that I found while restoring a backup of CDC enabled database to different SQL instance. You may receive below warning message that includes information about the cause of the warning, which can help …

Updating an expired SQL Server TDE certificate

Publié le 13 février 2018 sur sqlservercentral.com
 

Simon Liew explains how to generate a new TDE certificate to replace the previous, and also looks at the steps needed if the database is in an Availability Group.

SQL SERVER – Script Level Upgrade for Database ‘master’ Failed Because Upgrade Step ‘sqlagent100_msdb_upgrade.sql’ – Error: 5041: MODIFY FILE Failed

Publié le 13 février 2018 sur journey to sqlauthority
 

I have helped many clients in upgrade failures via my On-Demand consulting and I am amazed to see various ways which can break SQL Server upgrade. In this blog we would learn about fixing error Script level upgrade for database ‘master’ fai …

Attending our SQLBits Pre-Con? Prepare Your Laptop Now.

Publié le 12 février 2018 sur brentozar.com
 

If you’re joining Erik & I at our SQLBits precon, Expert Performance Tuning for SQL Server 2016 & 2017, you’ll be able to follow along with the demos on your laptop. We’re going to be showing you some common and not-so-common …

Baselining a ReadyRoll project from an existing database

Publié le 12 février 2018 sur sqlservercentral.com
 

When creating a new ReadyRoll project, the schema of your production environment can also be imported as a baseline. Further work can be built on top of the baseline in a sandbox development environment and, when you’re happy with the changes, th …


Pages :