Utilize SSAS for data predictions and classification using Excel
Using Excel as a tool for data mining and predictions is very powerful. Learn how to take advantage of SSAS in SQL Server 2005 with Microsoft Office Excel 2007.
2009-01-09
2,868 reads
Articles
Post SQL Server 2008 Upgrade - SQL School Video
After you complete an upgrade to SQL Server 2008, Brian Knight goes over some things you might want to do first.
2009-01-08
3,260 reads
2009-01-08
9,725 reads
How To Get Active Directory Users and Groups Using SQL Server Integration Services SSIS 2005
We would like to update the user, role, and user role tables automatically from Active Directory. Ideally we'd like an SSIS package that we could schedule and/or run on demand to take care of the update. Can you provide an example of how to do this?
2009-01-08
4,369 reads
SQL Techniques for Performing Operations on Matrices
SQL does not support direct operations on matrices, but it does allow easy manipulations with matrices. Learn a few SQL techniques for performing some basic operations on matrices.
2009-01-08
2,732 reads
An Extra Defense For SQL Injection Attacks
TDSe-cure is a proxy service to SQL Server to block SQL injection attacks.
2009-01-07
3,027 reads
SQL Server 2008 and Data Compression
One of the more exciting new features in SQL Server 2008 is data compression and Nicholas Cain talks a bit about how this works and how to determine if it fits in your environment.
2009-01-07
10,306 reads
Don't Let the Economic Downturn Get You Down
With the current economic downturn, many of us are wondering if we will still have a job by the end of this new year. Although DBAs are still in demand, no DBA job is 100% immune from layoffs. Brad suggests that now is the perfect time to invest in yourself.
2009-01-07
718 reads
Don't Let the Economic Downturn Get You Down
With the current economic downturn, many of us are wondering if we will still have a job by the end of this new year. Although DBAs are still in demand, no DBA job is 100% immune from layoffs. Brad suggests that now is the perfect time to invest in yourself.
2009-01-07
999 reads
Don't Let the Economic Downturn Get You Down
With the current economic downturn, many of us are wondering if we will still have a job by the end of this new year. Although DBAs are still in demand, no DBA job is 100% immune from layoffs. Brad suggests that now is the perfect time to invest in yourself.
2009-01-07
724 reads
Blogs
Moving On-Prem PostgreSQL to the Cloud: Picking the Right Path for Big Tables
Every PostgreSQL migration eventually hits the same fork in the road. The database is...
A Spread of Vacation
By Steve Jones
I’m off on vacation today. Which is a little weird as I just got...
How AgentDBA Identifies Backup Failures
By Arun Sirpal
Every DBA has a box like this. Sitting untouched for months. Nobody’s proud of...
Forums
Alamat kantor BCA KCP Renon Telp:08218154398
WhatsApp:0821-8154-398 Jl. Raya Puputan No.10, Panjer, Denpasar Selatan, Kota Denpasar, Bali 80226
Alamat kantor BCA KCP Bantul Telp (0817)-866887
Wa:0817-866-887 JL. JENDRAL SUDIRMAN NO. 18A RT.007 RW.000, BANTUL WARUNG, DESA. KEL. BANTUL, KEC....
ALAMAT KONTAK BCA KCP Blok M Telp:08218154393
WA:08218154393 Jl. Melawai Raya No.3, RT.3/RW.1, Melawai, Kec. Kby. Baru, Kota Jakarta Selatan, Daerah...
Question of the Day
TempDB Facts I
Can I set Accelerated Database Recovery on tempdb?
See possible answers