(Dave Cassel) During a recent working session, a question came up about how to quickly find all the values in one sequence that aren’t in another. A little poking around the web turns up what seems to be the standard approach:
Author: SSWUG Research
MVC Web API and ASP.NET Identity – Changing Identity Database Connection
(Alexander Wechsler) Sometimes simple things are hard, or at least hard to find.
.NET: How to create IComparer from anonymous Comparison
(Nuno Freitas) There are several functions in .NET that require an IComparer and thus cannot use a Comparison delegate, anonymous or otherwise. Starting with .NET 4.5 there is a new method to create a Comparer from an anonymous Comparison.
Smart Moves with SQL Server VMs – VM Proximity
(David Klee) Today I am starting a new series of short posts designed to help SQL Server administrators with virtualized SQL Servers twist the mind a bit and think about virtualization in a different light. I call it “Smart Moves with SQL Server VMs“.
max_connections – Performance impacts
(Hans-Juergen Schoenig) It has always been commonly known that settings max_connections to an insanely high value is not too good for performance. Generations of system administrators have followed this rule. Just out of curiosity I thought I’d give it a try to see, which impact setting max_connecti
Big Data: Three Ways to Choose Meaningful Analytics
(Dave Beulke) The NCAA tournament is going to start in a few weeks, and everyone is going to get their basketball winning prediction bracket ready. Quicken Loans, insured by Warren Buffet, is offering $1 billion dollar prize for anyone picking a prefect bracket for the NCAA tournament.
Find Type Dependents
(Michael McLaughlin) Somebody thought it was nice to show how to drop object type dependents in Oracle Database 11g, but they thought I should show how you discover dependent object types first. More or less, they were concerned how they discover type dependents when they raise the following error:
The Web Is 25 — And The Semantic Web Has Been An Important Part Of It
(Jennifer Zaino) Today the Web celebrates its 25th birthday, and we celebrate the Semantic Web’s role in that milestone. And what a milestone it is: As of this month, the Indexed Web contains at least 2.31 billion pages, according to WorldWideWebSize.
Working with Container Controls in VB.NET
(Hannes Du Preez) Container controls are a misunderstood concept for many a new programmer. It is as if newbies do not realize the true power of a container control. Today I will set this record straight with this article and explain exactly what Container controls are, which Container controls are
Using whoami to check for instant file initialization
(Tibor Karaszi) Read this if you want to read more about instant file initialization (IFI). In an earlier blog post, I posted a script that uses trace flags, created a dummy-database and then sp_readerrorlog to check for IFI.