Sites anglophones


Waits library now has infographics from SentryOne monitored instances

Publié le 10 mai 2017 sur sqlskills.com - paul randall
 

A few years ago I realized that there was a huge gap in knowledge in the SQL Server community – what do all the various wait types mean? – so I started a labor-of-love project to document all wait types and latch classes that have existed f …

Group Post: If I Took Another DBA Job, My First Question Would Be…

Publié le 10 mai 2017 sur brentozar.com
 

“Question 1: how do you predict how long a rollback will take?” Brent says: “How many people are in the on-call rotation with me, and can I give them each a technical test?” Once you get out of the on-call rotation, it’s r …

AlwaysON Availability Group and Jobs Part 1

Publié le 10 mai 2017 sur sqlservercentral.com
 

In this article (consist from 2 parts) , I will be focusing on one of the practical solutions for management of internal SQL Server jobs in AlwaysOn Availability Groups scenarios. How to fix SQL Server disk I/O bottlenecks (without a hammer)In this new …

SQL Data Mask: now featuring configurable masks

Publié le 10 mai 2017 sur sqlservercentral.com
 

SQL Data Mask is the latest prototype to come out of Redgate Foundry. It copies your database while anonymizing personal data, and you can use it to mask your databases right now, free of charge. Here are the details.

SQL SERVER – Edition Upgrade – Invoke or BeginInvoke Cannot be Called on a Control Until the Window Handle has Been Created

Publié le 10 mai 2017 sur journey to sqlauthority
 

One of a unique advantage of freelancing is learning more and more. I get a chance to hear some of the real word problem and it gives me immense pleasure to provide a feasible solution to them. This blog is interaction on the airport when I was coming …

The Heart of SSIS Framework Community Edition-Parent.dtsx

Publié le 10 mai 2017 sur sqlblog.com
 

I’m writing about SSIS Framework Community Edition because lots of people are using this free, open-source utility to execute collections of SSIS packages in their enterprises. Earlier I wrote Schedule an SSIS Application with SSIS Framework Comm …

Building a Faux PaaS, Part 1: The SQL Server DevOps Scene in 2017

Publié le 9 mai 2017 sur brentozar.com
 

In the cloud, treat your servers like cattle, not like pets. Rounding up a herd of servers in Texas In the cloud, systems administration is very different than the on-premises stuff you’re used to. When you build VMs in the cloud with Infrastruct …

Adding an SSIS Application to SSIS Framework Community Edition

Publié le 9 mai 2017 sur sqlblog.com
 

I’m writing more about SSIS Framework Community Edition because lots of people are using this free, open-source utility to execute collections of SSIS packages – called SSIS Applications – in their enterprises. Earlier I wrote Schedul …

What You Need to Know about Adaptive Joins over Rowstore

Publié le 9 mai 2017 sur sqlmag.com
 

SQL Server 2017 CTP 2.0 introduces support for adaptive query processing capabilities. Traditionally, the query optimizer made all of its plan choices ahead of query execution, and SQL Server wasn’t able to change those during execution. With ada …

Date and Time Conversions Using SQL Server

Publié le 9 mai 2017 sur sqlservercentral.com
 

There are many instances when dates and times don’t show up at your doorstep in the format you’d like it to be, nor does the output of a query fit the needs of the people viewing it. One option is to format the data in the application itself. Another o …

Best option for working with Files in SSIS

Publié le 9 mai 2017 sur sqlservercentral.com
 

This time we will compare different solutions to copy system folders using different SSIS tasks.

Schedule an SSIS Application with SSIS Framework Community Edition

Publié le 9 mai 2017 sur sqlblog.com
 

The coolest thing about SSIS Framework Community Edition is it’s free . You can click that link to head over to the DILM Suite site where you can learn more and find a link to the source code, documentation, and sample SSIS projects on GitHub. I …

“Stored procedures don’t need source control…”

Publié le 9 mai 2017 sur sqlblog.com
 

Hearing this is one of those things that really bugs me. And it’s not actually about stored procedures, it’s about the mindset that sits there. I hear this sentiment in environments where there are multiple developers. Where they’re u …

SQL SERVER – SQL Audit Date Time Does Not Match Machine Date Time – Solution

Publié le 9 mai 2017 sur journey to sqlauthority
 

Even though my consulting is mostly around performance tuning, I can see many customers who want to start using the new capabilities of SQL Server for their existing application as they plan to do an upgrade of their infrastructure. In one of engagemen …

The Case of Entity Framework Core’s Odd SQL

Publié le 8 mai 2017 sur brentozar.com
 

Recently, Julie Lerman contacted me about some strange SQL that Entity Framework Core (EF Core) was generating. Now, EF Core is fairly new and works with Microsoft’s newest framework .NET Core. I haven’t had a chance to get my han …


Pages :