Accel-Backed ForeScout Climbs After Raising $116 Million in IPO
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
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?
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?
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
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
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.
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
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
Phil Factor provides an overview and comparison of SSMS templates, SSMS snippets, and SQL Prompt snippets.
Backup SQL Server Databases in Parallel with PowerShell
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
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
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?
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)
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?
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 …