Sites anglophones


Accel-Backed ForeScout Climbs After Raising $116 Million in IPO

Publié le 30 octobre 2017 sur sqlmag.com
 

The company sold 5.28 million shares for $22 apiece Thursday, after marketing them for $20 to $22 each, according to a statement.

FAQs: Handling UPN Suffixes in AD and Removing People Bar in Windows 10

Publié le 30 octobre 2017 sur sqlmag.com
 

Three times a week (Monday/Wednesday/Friday), John Savill tackles your most pressing IT questions. Read through the FAQ archives, or send him your questions via email. In these group of FAQs we look at handling UPN suffixes in AD and rem …

Why Learn About SQL Server Internals?

Publié le 30 octobre 2017 sur sqlblog.com
 

It’s not just about performance tuning! https://www.dbbest.com/blog/learn-sql-server-internals/ Please also stop by the DB Best booth if you’re at the PASS Summit this week! https://www.eventbrite.com/e/live-qa-sql-pass-2017-with-kalen-delaney-tickets- …

Security Sense: How Do You Do Knowledge Based Authentication When All Knowledge is Public?

Publié le 30 octobre 2017 sur sqlmag.com
 

How do you authenticate people based on data attributes they know when that very information is continually popping up in data breaches? It’s a hard problem with no easy answers.

SQL Server Diagnostic Information Queries for November 2017

Publié le 30 octobre 2017 sur sqlskills.com - glen berry
 

This month, there are more minor updates to the all of the versions of the queries, primarily in the comments and documentation. I often make additional minor updates to the queries periodically during the month, so if you are in doubt, downloading the …

Presenting Two Sessions at the PASS Summit 2017 in Seattle

Publié le 30 octobre 2017 sur sqlskills.com - glen berry
 

I’ll be presenting two sessions at the PASS Summit 2017 in Seattle, WA. There will be a half-day session called Migrating to SQL Server 2017 on Wednesday, November 1 in Room 6A, starting at 3:15PM, and then a regular session called Improving SQL …

Announcing my new Mastering class series – and registration opens Wednesday.

Publié le 30 octobre 2017 sur brentozar.com
 

We’ve talked about why traditional training sucks, how our all-new series is different, and what our early-access students said. Now it’s time to unveil the new lineup: Always On Availability Groups: The Senior DBA’s Field Guide …

Office 365 Subscribers Now Have Access to Enhanced Security

Publié le 30 octobre 2017 sur sqlmag.com
 

Office 365 Home and Office 365 Personal subscribers who use Outlook.com are getting three new benefits for their email service.

Templates and Snippets in SSMS and SQL Prompt

Publié le 30 octobre 2017 sur sqlservercentral.com
 

Phil Factor provides an overview and comparison of SSMS templates, SSMS snippets, and SQL Prompt snippets.

Backup SQL Server Databases in Parallel with PowerShell

Publié le 30 octobre 2017 sur sqlservercentral.com
 

I have a need to decrease the time my SQL Server database backups are taking to run. I thought about trying to run multiple backups at the same time to see if that would work. I could have created multiple SQL Server Agent Jobs to run at the same time, …

Parse Data from a Field Containing Multiple Values using CROSS APPLY

Publié le 30 octobre 2017 sur sqlservercentral.com
 

It is possible for a field in a character-delimited text file to contain a list of further-delimited values instead of the customary single value. This article demonstrates how to load such a file into a staging table, then use a CROSS APPLY query to p …

SQL SERVER – Adding New Database to AlwaysOn Replica is Slow

Publié le 30 octobre 2017 sur journey to sqlauthority
 

First, let me clarify, the words in the subject of this blog are the exact words used by my client and whatever you do and say but “customer is always right!“. Here is the complete story where we faced issue related to AlwaysOn Replica. One …

SQL SERVER – How to Auto Start SQL Followed by a Crash?

Publié le 29 octobre 2017 sur journey to sqlauthority
 

Sometimes I do get some quick questions from my existing clients. I try to help them as much as possible. Most of the time, I provide them link to my blog or someone else’s blog. If there is no relevant information based on my search, then I prov …

[Video] Office Hours 2017/10/25 (With Transcriptions)

Publié le 28 octobre 2017 sur brentozar.com
 

This week, Brent, Erik, and Richie discuss database corruption, multi-instance clusters, career advice, whether you should transition from contract work to full time, VMware vMotion, reducing failover time with AGs, query tuning, and more. Here’s …

SQL SERVER – How to Remove TempDB File?

Publié le 28 octobre 2017 sur journey to sqlauthority
 

In the last 11 years of blogging, I have never received a question which I have received yesterday. The question which I often receive is about how to add TempDB files in SQL Server but I have never received a question about how to remove a TempDB file …


Pages :