Using SQL Server Data Mining Add-Ins for Office 2007 to Predict Database Growth Trends - Part 2
I want to show you another easier way to pull information to help predict database growth again using the Data Mining Tools.
Foreign Keys, Part 1 - SQL School Video
Understanding referential integrity is important for anyone working with databases. It can help you design better forming systems. Learn the basics of foreign keys in this SQL School video.
Productive Meetings
It seems that many meetings in corporate settings are wastes of times. Can they be better? Steve Jones has a few ideas that might help make them more productive.
Saving Time with Proactive DBA Monitoring
Monitoring your SQL Server instances and tracking metrics is an important part of a stable environment. New author Sadequl Hussain brings us a description of his technique for doing this across multiple servers.
Cloud Computing with Microsoft Azure SDS
Don Schlichting introduces the Microsoft Azure service and explores the SQL Data Services (SDS).
File/Folder/Share Permissions for DBAs and Database Developers
Every so often I run into a fellow DBA or database developer who isn't crystal clear on how file/folder and share permissions play together. If you're an MCSE or an experienced system administrator, this should be old hat for you. However, given...
Planning Your First Microsoft BI Solution
Even BI novices can learn what goes into creating a BI solution, from planning and designing a data mart to preparing data. An Adventure Works example illustrates the first steps a company can take to ensure that its BI solution supports the strategic decisions it needs to make. Stacia Misner
Productive Meetings
It seems that many meetings in corporate settings are wastes of times. Can they be better? Steve Jones has a few ideas that might help make them more productive.
Productive Meetings
It seems that many meetings in corporate settings are wastes of times. Can they be better? Steve Jones has a few ideas that might help make them more productive.
Productive Meetings
It seems that many meetings in corporate settings are wastes of times. Can they be better? Steve Jones has a few ideas that might help make them more productive.
Blogs
2025 Wrapped for Steve
By Steve Jones
I’ve often done some analysis of my year in different ways. Last year I...
The Book of Redgate: Spread across the world
By Steve Jones
This was Redgate in 2010, spread across the globe. First the EU/US Here’s Asia...
Merry Christmas
By John
Today is Christmas and while I do not expect anybody to actual be reading...
Forums
Database security permissions save script
Comments posted to this topic are about the item Database security permissions save script
Database backup job steps
I have a SQL Agent job for backing up a set of Analysis Services...
SQL Server 2025 Backup Compression Algorithm
Comments posted to this topic are about the item SQL Server 2025 Backup Compression...
Question of the Day
The Large Encoded Value
I want to use the new BASE64_ENCODE() function in SQL Server 2025, but return a string that isn't large type. What is the longest varbinary string I can pass in and still get a varchar(8000) returned?
See possible answers