Database Mail and SQL Agent Mail setup by using a script
In this tip I provide a script with a few parameters that need to be setup to configure and turn on both of these features.
2009-05-11
4,009 reads
Additional Articles
Designing and Tuning for Performance your SSIS packages in the Enterprise (SQL Video Series)
For all of those whom are interested in SSIS performance, we have posted a new SQL video series about how to design and tune your SSIS packages for performance.
2009-05-11
2,257 reads
Attribute Discretization: Using the Automatic Method
Join BI Architect Bill Pearson as he continues his overview of Attribute Discretization, within his extended examination of the dimensional model lying at the heart of the integrated Microsoft Business Intelligence solution. In this article, we begin a hands-on overview of the use of the Automatic discretization method.
2009-05-08
2,182 reads
SQL Server Optimization
This article describes different ways of improving the performance of SQL Server queries, with a focus on index optimization.
2009-05-08
5,250 reads
Patterns For High Availability, Scalability, And Computing Power With Windows Azure
Now, Internet-hosted distributed applications with connectivity to internal applications—often referred as Software plus Services (S+S)—are gaining popularity. Organizations are leveraging datacenters hosted by third parties to alleviate concerns about hardware, software, reliability, and scalability. These are just some of the new architecture trends that help you build interoperable applications that scale, reduce capital expenditure, and improve reliability. Cloud computing offers many of these benefits.
2009-05-07
2,230 reads
Scaling up vs. scaling out with SQL Server 2008
To scale your SQL Server properly means to make it bigger and better. But what is the best method for 2008?
2009-05-07
2,973 reads
Auditing Failed Logins in SQL Server
An auditor has taken a look at our SQL Servers and has told us that we need to audit login failures to the SQL Servers themselves. How do we do this?
2009-05-06
3,583 reads
Median Workbench
SQL Server database engine doesn't have a MEDIAN() aggregate function. This is probably because there are several types of median, such as statistical, financial or vector medians. Calculating Medians are essentially a row-positioning task, since medians are the middle value of an ordered result. Easy to do in SQL? Nope. Joe Celko explains why.
2009-05-06
2,024 reads
Access Your Data On Premise Or In The Cloud With ADO.NET Data Services
Web Services has been a hot topic for a number of years now, but what, you may wonder, are these Data Services everyone's talking about lately? As the architecture of Web applications has changed and matured (with the popularity of Rich Internet Applications [RIAs], for example), there has been an increased awareness of the value of exposing raw data, minus any interface or formatting, to any service or application that wants to consume it.
2009-05-05
1,623 reads
Using the OPENROWSET function in SQL Server
OPENROWSET is a handy tool for retrieving data. Find out how to use the OPENROWSET function for SQL Server and Microsoft Access.
2009-05-05
4,399 reads
Blogs
T-SQL Tuesday #198 Invitation: How Do You Detect Data Changes?
It's time for T-SQL Tuesday #198! This month's topic is change detection. The post T-SQL...
Understanding Fabric MCP
By James Serra
Model Context Protocol, or MCP, is one of those technical ideas that sounds more...
AWS RDS Aurora - our first approach
When starting with AWS RDS Aurora for managing relational databases in the cloud, many...
Forums
BCA KCP Kas Jatiwaringin. Tlp:085373737845
Giant, Kompleks Ruko Graha Indah, Blok F/1, RT.001/RW.002, Jatiwaringin, Pondok Gede, Bekasi, West Java...
BCA KCP Buaran Raya Hub.0853•5504•2311
BCA KCP Buaran Raya Hub.0853•5504•2311 Jl. Buaran Raya Blok A No. 100, RT.6/RW.dan 101,...
BCA Finance WTC Mangga Dua Hub.0853•5504•2311
BCA Finance WTC Mangga Dua Hub.0853•5504•2311 Gedung WTC Jl. Mangga Dua Raya. 8 Lantai...
Question of the Day
May the Fourth Be With You Fun
In honor of May the fourth and Star Wars (may the force be with you), finish this quote:
"Do, or do not. ..."See possible answers