Data Mining Introduction
Many people that work for years with SQL Server never use the Data Mining. This article has the objective to introduce them to this magic and exciting new world.
Legacy Limits
Sometimes the hardware or software we use prevents upgrades, which isn't necessarily good for any of us.
Development Delusions: That it is Enough to Build a Better Mousetrap
You've written a superb, clever, application that you are trying to encourage your colleagues to use. They're not interested. Why? You've neglected the documentation. Surely, the saying goes 'Build a better mousetrap and the world will beat a path to your door'? Nope, not without comprehensive and complete documentation and marketing, it won't. Documentation is the secret of ensuring that good software will succeed.
Keeping Fact Tables Online while Loading via Partition Switching
Provides overview of steps that can be used to keep fact tables online during loading process.
What's New in Reporting Services 2016 Service Pack 1
SQL Server 2016 was been released the first of June 2016, but at the recent Connect event Microsoft announced the first service pack. Aside from numerous fixes, this service pack also comes packed with some notable enhancements for Reporting Services. Koen Verbeeck gives you an overview of these enhancements.
Five Useful SQL Server Management Practices
This article outlines five SQL Server capabilities you can use to enhance your efficiency as a DBA.
Put your Database under Source Control
This article will walk you through a demostration on linking your DB to SubVersion with RedGate SQL Source Control.
SQL Server v.Next : STRING_AGG() performance
Aaron Bertrand takes an initial look at the performance of a new function, STRING_AGG, in SQL Server v.Next CTP 1.1.
Delaying Patches is Problematic
Many of our security issues come down to not patching software when there are updates available.
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
BCA KCU JOMBANG Telpon/WA:083179431313
WhatsApp:083179431313 Jl. KH. Wahid Hasyim No.20, Jombang, Kec. Jombang, Kabupaten Jombang, Jawa Timur 61415
BCA KCU GALAXY Telpon/WA:083179431313
WhatsApp:083179431313 Jl. Dr. Ir. H. Soekarno No.37-39, Klampis Ngasem, Kec. Sukolilo, Surabaya, Jawa Timur...
BCA KCU KEDIRI Telpon/WA:083179431313
WhatsApp:083179431313 Jl. Brawijaya No.8, Pocanan, Kec. Kota, Kota Kediri, Jawa Timur 64123
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