2017-05-30
1,114 reads
SQL
Doing Fuzzy Searches in SQL Server
A series of arguments with developers who insist that fuzzy searches or spell-checking be done within the application rather then a relational database inspired Phil Factor to show how it is done. When the database must find relevant material from search terms entered by users, the database must learn to expect, and deal with, both expected and unexpected.
2017-04-27
7,260 reads
PowerShell 3rd Party tool Memory Alert
Keeps a memory leak under control until the bug fix is developed and applied. Short term band aid.
2017-04-25 (first published: 2017-04-13)
441 reads
2017-04-12
3,960 reads
SQL Login Password Audit
Audit your SQL logins to find passwords that have never been changed or that are very weak.
2017-04-04
2,482 reads
2017-03-21 (first published: 2017-03-15)
403 reads
2017-03-07 (first published: 2017-03-01)
976 reads
2017-02-28
4,864 reads
Azure DWH part 1:Common questions about Azure SQL Data Warehouse
This article compiles some common questions and answers about Azure SQL Data Warehouse.
2016-12-28
5,158 reads
Data Mining Part 37: The Data Mining query transformation task
This new chapter will show you how to work with the SSIS Data Mining Query Transformation Task
2016-04-14
1,771 reads
Blogs
Last Week Reading (2020-08-02)
By Kamil
Press ADF Release Notes 07/31/2020 I believe this is the first Release Notes from...
Online certification exams are definitely different
By DesertDBA
As you can tell from previous posts, I’ve taken a few Microsoft Certification exams...
Office Upgrade – A Secret Lab Chair
By Steve Jones
Last year I wandered over to Glenn Berry’s house for some lunch and a...
Forums
Offline Files
Comments posted to this topic are about the item Offline Files
Confidential VMs
Comments posted to this topic are about the item Confidential VMs
Change the Instance Collation by Rebuilding Databases in SQL Server 2017
Comments posted to this topic are about the item Change the Instance Collation by...
Ask SSC