Sites anglophones


Justify the Remote access requirement for Biztalk Log Shipping

Publié le 29 mars 2017 sur sqlservercentral.com
 

This article will show why there is a need for remote access with a Biztalk server that uses log shipping.

SQL SERVER – Express and SQL Server Agent – Free Alternative

Publié le 29 mars 2017 sur journey to sqlauthority
 

“How come my database is only a few MBs big and I am facing performance problems?” My customer asked. I replied, “Well, this is because you are not running job using SQL Server Agent to keep your indexes in the best health. …

VarsoviaNewTech–unique conference in Poland (available for all–live streaming!!!)

Publié le 29 mars 2017 sur sqlblog.com
 

Hello folks, Maybe you have some time today? You can join a pretty cool conference – VarsoviaNewTech. var Sovia = new Tech(); is a Microsoft developer conference that showcases newest dev technologies and solutions. The event puts spotlight on Mi …

Analyzing Wait Events for Faster Database Troubleshooting

Publié le 28 mars 2017 sur sqlmag.com
 

Thomas LaRock, Head Geek, SolarWinds Most database administrators, regardless of platform, are familiar with the concept of wait events. Wait events are a natural part of a database engine processing requests. When a connection is made to the database …

How to Share Management Studio Templates

Publié le 28 mars 2017 sur sqlmag.com
 

It’s not possible to change the template directory in any version of SQL Server Management Studio which means sharing any custom templates you create between team members or different devices you own is not possible… out of the box that is. Tim Ford, …

SQL Server 2016 SP1 CU2 Released

Publié le 28 mars 2017 sur sqlmag.com
 

The latest cumulative update for Microsoft’s flagship data platform, SQL Server 2016, has been released. Learn more about how to obtain the latest update as well as the new source page for updates on Microsoft SQL Server now. read more

Confession: I recommended that a 5GB database get split up.

Publié le 28 mars 2017 sur brentozar.com
 

Listen, I can explain. Really. Photo by Toa Heftiba We had a client with a 5GB database, and they wanted it to be highly available. The data powered their web site, and that site needed to be up and running in short order even if they lost the ser …

Performing a Right and Comprehensive Age Calculation

Publié le 28 mars 2017 sur sqlservercentral.com
 

Age calculation based on the right method used in real life.

Who Changed My Database Schema?

Publié le 28 mars 2017 sur sqlservercentral.com
 

Have you ever wanted to know who made a schema change to your database? If so, that information is tracked in the default trace – Greg Larsen shows how to view it.

SQL SERVER – Huge Size of Table catalog.execution_component_phases in SSISDB

Publié le 28 mars 2017 sur journey to sqlauthority
 

Have you ever faced a situation where the table size in SSISDB is very huge? Are you are wondering what this SSISDB database is? It has information about the SSIS catalog execution and we should not truncate them as they belong to SSIS subsystem. Once …

[Video] Office Hours 2017/03/22 (With Transcriptions)

Publié le 27 mars 2017 sur brentozar.com
 

This week, Tara, Erik, and Richie discuss statistics updates, in-place upgrades, row vs page compression, deadlocks, replacing SQL backup vendors, server load, ETL, and whether they think that database mail should be used by user applications to send t …

Building Better Entity Framework Applications

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

In this article, I’ll describe six principles and patterns I use when building applications that use Entity Framework (EF). All six approaches are based on software principles and patterns that many of you will be familiar with. This article show …

Generating Plots Automatically From PowerShell and SQL Server Using Gnuplot

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

There are many excellent ways of plotting data from SQL Server databases. There are many R libraries for example, there is Reporting Services, Plotly or PowerBI. I’ve even used Excel and JpGraph. If I had to learn just one though, I’d use G …

This Is Your Backup Schedule On Drugs

Publié le 27 mars 2017 sur brentozar.com
 

I’ve seen things Terrible things. I mean, not just working here (which, as I write this, I’m three days away from the two year mark, fingers crossed!), but also out there on the internet. Once you leave the safe confines of Brent Ozar Unlim …

Azure Networking for SQL Server DBAs

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

Continuing our series on Microsoft Azure for DBAs, we come now to a second very important component: networking. Most DBAs have a cursory understanding of how networking functions; we might know how subnetting works, what kinds of firewall rules are re …


Pages :