Data Mining Part 38: Text Mining - The term lookup
In this new article, we will show how to use the SSIS term lookup transformation tool.
2016-04-27
1,746 reads
Lookup
Using Lookup Function to Bridge Datasets in Report Builder
The report function, lookup, can be used to link two independent datesets.
2013-07-29
12,891 reads
String Search
Search for a string value within columns of data types CHAR, NCHAR, NTEXT, NVARCHAR, TEXT, VARCHAR, XML.
2019-04-15 (first published: 2012-03-19)
6,358 reads
Master Data Services - SSIS MDM Load
The article will provide an overview of Master Data Services and a sample SSIS Package.
2010-03-02
9,462 reads
RE: Creating Sql users from an Active Directory export
I just looked up the original request and it says that there are 3000 users. I agree with the previous statement of IloveSQL that with this number of users who are the domain users you will be MUCH better off granting access to the domain user group, like a global group / groups. Please, read […]
2004-09-28
RE: Two fields into one
I am Sorry....... The table has two fields; Last Name, First Name.In the view I want Last name and first name into one field.Thanks
2004-09-03
RE: Problematic error messages - Diskkeeper and SQL Server
Can you reboot? I've seent he cursor message, but can't remember what it was. It was awhile ago and I think it cleared itself. As far as diskkeeper, do you exclude the SQL Files? I do and don't have any issues.
2004-05-11
RE: Suspect databases
This is the error : 17052 : Device activation error. The physical file name 'D:\MSSQL\Data\store_Data.MDF' may be incorrect.17204 : FCB:pen failed: Could not open device D:\MSSQL\Data\store_Data.MDF for virtual device number (VDN) 1.17207 : udopen: Operating system error 32(The process cannot access the file because it is being used by another process.) during the creation/opening of physical […]
2004-02-14
2003-12-05
1 reads
RE: SQL/Active Directory issue???
Maybe this would work: sp_grantlogin [@loginame =] 'login' sp_grantlogin sp_revokelogin Note that the SQL security account procedures and the NT security account procedures differ. If you got a snapshot of all of the logins/role membership/permissions for the NT accounts, and their NT account name has not changed, then you could scan through them and use […]
2003-12-01
Blogs
Set a Runtime Variable in an Azure DevOps Pipeline
By Steve Jones
Note: I DO NOT recommend this. Any changes to a pipeline should be in...
A New Word: Symptomania
By Steve Jones
symptomania – n. the fantasy that there’s some elaborate diagnosis out there that neatly...
Query Store Keeps Switching Itself Off, Getting it Moving Again
I recently received a complaint that Query Store for a particular database was turned...
Forums
7 sept, scheduled book
Comments posted to this topic are about the item 7 sept, scheduled book
7 sept, schedlued article
Comments posted to this topic are about the item 7 sept, schedlued article
6 sept, published book
Comments posted to this topic are about the item 6 sept, published book
Question of the Day
Azure Data Lake Storage Gen 2
Azure Data Lake Storage Gen 2 is built on ...?
See possible answers