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,823 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,594 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
What Do I Do to Relax?
By Steve Jones
I’ve republished an editorial today from another author, called What do you do to...
Daily Coping 9 Dec 2022
By Steve Jones
Today’s coping tip is to find out something new about someone you care about....
Advent of Code 2022
By Zikato
Foreword Advent of Code is an annual event in which participants solve a series of...
Forums
SSRS - Add end date for all SSRS subscriptions
Hi, Could you please advice if it is possible to add an end date...
blank page
Hi guys! The topic "Connect to SQL Server with Python to Create Tables, Insert...
Ask SSC