Data Mining Introduction Part 3: The Cluster Algorithm
This is the part 3 of the Data Mining Series from Daniel Calbimonte. This article examines the cluster algorithm.
2013-03-12
12,683 reads
Daniel Calbimonte
- Skills: ssas, ssis, ssrs, Power BI, Azure
11 Tips to Backup databases with SMO, VB, C# Powershell, Command lines
Sometimes we need to create backups using code. Sometimes we need to do it manually or automatically, programmatically using C#, VB, Powershell.
2012-08-14
7,586 reads
The User Defined Server Roles in SQL Server 2012
This article describes how to create user defined server roles and use stored procedures and queries related.
2012-05-25
4,558 reads
New features in SQL 2012, the contained database
This article describe the problems about the migration of the databases and logins and the new feature contained databases
2012-05-22
10,858 reads
Run SQL Server Scripts using C#
In this article I will run a SQL Server script to backup a database using C# in visual studio. For this purpose, I am going to use the sqlcmd.
2012-04-27
17,891 reads
Linked server to MySQL Server.
In this article, we are going to create a linked server to the MySQL Database.
Once finished that task, we will select, insert, update and delete some data using SQL Server.
2012-04-17
9,889 reads
Sequences in SQL Server 2012
This article describes the sequence new feature used in SQL Server 2012
2012-04-13
9,420 reads
Bye Bye to the RAISERROR Function?
This article describes the use and advantages of the throw statement.
2012-04-03
2,698 reads
How to create a database backup using visual studio
This article describes how to backup a database using a C# Windows Form.
2012-03-30
15,353 reads
A Demo of the Power of Powershell
This demo will show you the how powerfull is powershell. We will use cicles and the get-content command.
2012-03-22
9,924 reads
Blogs
The Evolution of Data: From Databases to Spark to Lakebases
By Daniel Janik
The circle cylinder of life Maybe you’ve noticed all the twenty somethings tight rolling...
Why Microsoft Fabric Signals the Next Wave of Data Strategy
By Chris Yates
In today’s data-driven economy, organizations are no longer asking if they should invest in...
PostgreSQL Timeline: History and Evolution
By Rohit Garg
PostgreSQL, often referred to as Postgres, is a powerful, open-source object-relational database system that...
Forums
How a Legacy Logic Choked SQL Server in a 30-Year-Old Factory
Comments posted to this topic are about the item How a Legacy Logic Choked...
How to fix transactional replication latency
Good Morning All, We are facing replication latency issue. I checked for blocking, long...
Life's Little Frustrations
Comments posted to this topic are about the item Life's Little Frustrations
Question of the Day
The Updated Columns List
I have this table in SQL Server 2022:
CREATE TABLE CustomerLarge (CustomerID INT NOT NULL IDENTITY(1, 1) CONSTRAINT CustomerLargePK PRIMARY KEY CLUSTERED , CustomerName VARCHAR(20) , CustomerContactFirstName VARCHAR(40) , CustomerContactLastName VARCHAR(40) , Address VARCHAR(20) , Address2 VARCHAR(20) , City VARCHAR(20) , CountryCode CHAR(3) , Postal VARCHAR(20) ) GOIf I check the columns_updated() function return in a trigger, what is the data returned? See possible answers