Configure Filestream in SQL Server 2008
SQL Server 2008 offers a wide variety of features and FILESTREAM is one of the most anticipated. This article describes how to configure the FILESTREAM feature.
2008-08-18
3,256 reads
Additional Articles
Basics for working with DATETIME and SMALLDATETIME
Learn how data is stored within DATETIME and SMALLDATETIME and get an overview of the TIMESTAMP data type -- as it's often confused with these two primary date/time data types.
2008-08-15
6,427 reads
Inside SQL Server Cluster Setup and Troubleshooting Techniques - Part I
This article describes the SQL Cluster Setup process and how to troubleshoot it if something goes wrong
2008-08-15
3,246 reads
Using SQL Servers OPENROWSET to break the rules
Many times I would like to insert the results of a stored procedure into a table so I can do some extra processing with the result set. I always have to create the table first in order to perform an Insert Into Exec on the desired stored procedure since Exec Into is not an option. Is there a way to do this without having to manually create the table each time?
2008-08-14
4,696 reads
Business Intelligence in Collaborative Planning, Forecasting and Replenishment
This article describes the use of BI in Collaborative Planning, Forecasting and Replenishment
2008-08-13
1,766 reads
Top Tips for Effective Database Maintenance
Far too often, people who are not trained database administrators somehow end up responsible for a database. They lack the proper training and knowledge to maintain their database, and problems begin to develop. Here’s a primer for all those involuntary DBAs who need a crash course in database maintenance best practices.
2008-08-13
6,696 reads
A Strategy to Determine the Size and Cost of Database-Centric Business Information Systems
This paper presents an approach to the definition of function points within database-centric business information systems, the process of counting function points, .
2008-08-12
1,757 reads
Index Metadata and Statistics Update Date for SQL Server
Statistics update date is stored as metadata on the SQL instance, but after a great deal of research against the system tables and DMVs I realized that this information is not readily exposed to the DBA via any other method than the STATS_DATE() function or the SQL Server Management Studio graphical user interface (GUI).
2008-08-12
3,021 reads
Configuring Database Mail in SQL Server 2005
Learn how to set up SQL Server Database Mail in SQL Server 2005. In this tip, you'll see how to configure Profiles and Accounts for sending mail.
2008-08-11
3,914 reads
SQL Server 2008: Table Valued Parameters
In SQL Server 2005 and earlier, it is not possible to pass a table variable as a parameter to a stored procedure. When multiple rows of data to SQL Server need to send multiple rows of data to SQL Server, developers either had to send one row at a time or come up with other workarounds to meet requirements. While a VB.Net developer recently informed me that there is a SQLBulkCopy object available in .Net to send multiple rows of data to SQL Server at once, the data still can not be passed to a stored proc.
2008-08-11
3,885 reads
Blogs
Vibe Coding a Login Tracking System
By Steve Jones
A customer was asking about tracking logins and logouts in Redgate Monitor. We don’t...
4 CPE Opportunity (Virtual) for Charity
By Brian Kelley
Every year, the South Carolina State Internal Auditors Association and the South Carolina Midlands...
Data Céilí 2026 Call for Speakers!
Data Céilí 2026 Call for Speakers is now live! Data Céilí (pronounced kay-lee), is...
Forums
SQL Server audit with windows ad group
I am trying to create a filter on a SQL Server audit to capture...
Deadlock graph anomaly
I've come across what appears to be a strange deadlock anomaly. As seen in...
Stairway to Azure SQL Hyperscale Level 6: Backup and Restore Internals
Comments posted to this topic are about the item Stairway to Azure SQL Hyperscale...
Question of the Day
Deprecated Feature Tracking
From T-SQL, without requiring an XEvent session, can I tell which deprecated features are being used on my instance?
See possible answers