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.
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.
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.
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?
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.
An Extra Defense For SQL Injection Attacks
TDSe-cure is a proxy service to SQL Server to block SQL injection attacks.
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.
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.
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.
Blogs
The Book of Redgate: Do the Right Things
By Steve Jones
I do believe that Redgate has been very customer focused since it’s inception. I’ve...
How to Connect to SQL Server When Nothing Else Works – DAC
By gbargsley
It's 2 AM. Your phone is going off. Users can't connect to the application,...
Get a Range of Sequence Values: #SQLNewBlogger
By Steve Jones
I discovered a procedure recently that I wasn’t aware of: sp_sequence_get_range. This post looks...
Forums
Let's Talk Community Events!
Comments posted to this topic are about the item Let's Talk Community Events!
that one limitation in replication
Hi as shown below a replication target requires a primary key. if we want...
Local Agents
Comments posted to this topic are about the item Local Agents
Question of the Day
Detecting Deadlocks
By default, how often is the SQL Server Database Engine checking for deadlocks?
See possible answers