Basics of Dimensional Modeling
Introduction of how to design a star schema dimensional model for new BI developers
Estimates
Software estimates are often wildly off from the actual amount of time and resources that are required. Today Steve Jones looks at a few reasons why.
SQL Server Live! Orlando, FL
SQL Server Live! is designed to finely tune the skills of DBAs, developers, Business Intelligence specialists (just to mention a few) with five days of workshops, deep dives and breakout sessions from November 17 - 21 2014.
Importance of Recovery Model in SQL Server
Have you ever wondered why the transaction log file grows bigger and bigger? What caused it to happen? How do you control it? How does the recovery model of a database control the growing size of the transaction log? Read on to learn the answers.
A Call for Questions
Our Question of the day is very popular, but we're looking for more complex questions
Data Mining: Part 16 Automating Data Mining Processes
In this chapter we will learn how to automate Data Mining Tasks using the SQL Agent.
Data Mining: Part 16 Automating Data Mining Processes
In this chapter we will learn how to automate Data Mining Tasks using the SQL Agent.
Misconfiguration is a Problem
The configuration of server systems matters. Not just to ensure software runs smoothly, but also for security.
Silicon Valley Code Camp
Code Camp is a community event where developers learn from fellow developers. This year's event will take place on October 11-12 in the Los Altos Hills in California. Speakers include Steve Jones, Nik Molnar, Anthony van der Hoorn, Mike Wood, and more. Register while space is available.
Blogs
Five Ways Redshift Serverless Quietly Eats Your Budget
It is Friday, the queries are running, and nobody is watching the bill. That...
A Career of Memories
By Steve Jones
Annabel retired from Redgate Software this week. Across most of my career at Redgate,...
Rethinking Index Maintenance: Why avg_fragmentation_in_percent Is Outdated and What You Should Do Instead
By Tim Radney
As a SQL Server DBA with years of experience tuning production environments, I’ve seen...
Forums
Alamat Kantor BCA KCP Bumiayu Telp:0817866887
WhatsApp:0817-866-887 Jl. Kalierang No.Ruko 3-5, Dukuhturi, Kec. Bumiayu, Kabupaten Brebes, Jawa Tengah 52273 (@bcakcpbumiayu)
BCA KCP Permata Ujung Menteng Tlp:0817839777
WhatsApp: 0817839777 Jl. Raya Bekasi Km. 25 Blok A/17, RW.18, Ujung Menteng, Wil, Kota...
Alamat Kantor BCA KCU RAWAMANGUN Tlp:0817839777
WhatsApp: 0817839777 Jl. Paus No.81, RT.1/RW.8, Wil, Kec. Pulo Gadung, Kota Jakarta Timur, Daerah...
Question of the Day
BCP on Linux
When running bcp on Linux, what is the field terminator?
See possible answers