Data Mining Part 21: Excel and Data Mining,validation methods
This article is part of the lesson 18 to 20 related to SQL Server Data Mining with Excel.
Removing Rows with the DELETE Statement in SQL Server
Greg Larsen explores how to remove rows from a SQL Server table using the DELETE statement.
SQL Monitor Custom Metric: Possible Duplicate Indexes
When a table has multiple indexes defined on the same columns, it produces duplicate indexes that waste space and have a negative impact on performance. This metric measures the number of possible duplicate indexes per database above a set threshold. You can then consider dropping the indexes and reverse the change.
Continuous Learning
It pays to continuously learn more about your job. SQL Server is so large, it really is a lifelong effort to drive yourself forward to master more and more.
Prepping for Winter
As winter approaches, many of us get ready in our personal lives, but Steve Jones notes that we might want to make sure we have regular preparation taking place on our systems for difficult times.
SQL Overview VII - SSRS Reports and Subscriptions
In the next installment of his series on the SQL Overview toolkit, David Bird looks at the information collected about SSRS.
SSIS 2012 Projects: Setup, Project Creation and Deployment
It used to be that SQL Server Integration Services (SSIS) packages had to be deployed individually. Now, they can be all deployed together from a single file by means of the Project Deployment Model introduced in SSIS 2012. Where there are tens or hundreds of SSIS packages to deploy, this system is essential.
Bucket List Data
This Friday Steve Jones is looking to see what data you're tracking about your life.
ETL Performance Auditing - Part 3: Auditing Data Warehouse Phase
Easy way to setup a comprehensive ETL Performance auditing Solution no matter how complicated your ETL setup.
Blogs
Understanding Fabric Ontology
By James Serra
What problem is Fabric Ontology trying to solve? For years, most data conversations have...
QUOTENAME Basics: #SQLNewBlogger
By Steve Jones
Recently I ran across some code that used a lot of QUOTENAME() calls. A...
When growing companies outgrow Excel
By ChrisJenkins
There are some telltale signs that your growing business has outgrown Excel for your...
Forums
Stairway to Reliable Database Deployment Level 3 – Rehearsing Changesets Across Environments
Comments posted to this topic are about the item Stairway to Reliable Database Deployment...
QUOTENAME Quote Parameters
Comments posted to this topic are about the item QUOTENAME Quote Parameters
Limit the Blast Radius
Comments posted to this topic are about the item Limit the Blast Radius
Question of the Day
QUOTENAME Quote Parameters
When I use QUOTENAME(), I can optionally provide the character used to surround the string in the result. Can I use any character?
See possible answers