Data Mining Part 34: Preparing for a certification exam
In this article we will talk about the Microsoft certifications related to Data Mining.
2015-12-24
2,822 reads
certification
Exam 70-462: Using Azure for the Practice Setup
A step-by-step guide to creating a practice setup for the 70-462 exam using Azure virtual machines.
2018-03-30 (first published: 2015-08-25)
5,553 reads
RE: How to shrink logfiles
I have tried regular transaction log backups (daily), but the .trn files just keep piling up in the backup directory and and are not being removed even though i specified to have them removed (files older than a day) in the maintenance plan. Any suggestions?
2004-09-08
RE: Linked server security
Sorry about that. Here is what the error message says:The server detected the following syntax errors in the command: Error 7314: OLE DB provider 'server2' does not contain table 'Rbc_datawarehouse.dbo.cmsbatch'. The table either does not exist or the current user does not have permissions on the table. OLE DB error trace [Non-interface error: OLE DB […]
2004-08-25
Dynamically Build Table Data Type
I am attempting to write a UDF that reads from INFORMATION_SCHEMA.COLUMNS and then based on a given TABLE_NAME, creates a new table datatype that mimics the structure of the aforementioned table. my first guess was to implement a scalar UDF and return a single value of type table.I declared my UDF as:CREATE FUNCTION udf_clone_table (@TableName […]
2004-08-11
1 reads
RE: Question of the Day for 27 Jul 2004
I created the two tables and entered data in them exactly as stated in the question and ran statements A and B. Both returned the exact same result as below. The only difference was the heading for the third column, one said UniqueID, the other Unique_ID. FRED 1 3 FRED 2 3 FRED 3 3 […]
2004-07-27
Blogs
EightKB 2024 – Schedule and Registration
Hello Hello, We. Are. Back! The schedule for EightKB 2024 Edition has been announced!...
Inside SQL Server Backup and Restore History Pruning with sp_delete_backuphistory
By Steve Jones
I had a customer that was looking to document a restore that had occurred...
T-SQL Tuesday #176: That Piece of Technical Advice for the Past Me
By DataOnWheels
DIVERSIFY! We devote a lot of time to mastering the technology that we are...
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