Notifications for SQL Server Agent Restarts
This article demostrates how to set up email notifications for SQL Server Agent Restarts.
2010-10-21
1,926 reads
Additional Articles
Add Some Spark to Your OData: Creating and Consuming Data Services with Visual Studio and Excel 2010
The Open Data Protocol (OData) is an open REST-ful protocol for exposing and consuming data on the web. Also known as Astoria, ADO.NET Data Services, now officially called WCF Data Services in the .NET Framework. There are also SDKs available for other platforms like JavaScript and PHP.
2010-10-20
1,918 reads
Robyn Page's SQL Server String Manipulation Workbench
String searching and manipulation in SQL Server can be error-prone and tedious...unless you're armed with the techniques described in Robyn's string manipulation workbench, here newly revised with extra material from collaborator Phil Factor
2010-10-19
4,427 reads
Create a Performance Baseline Repository
This article demostrates how to create a Baseline repository that holds summarized data of all SQL Executions executed on an instance of SQL Server.
2010-10-18
2,532 reads
Manage Database Projects With Visual Studio 2010
This article demonstrates how to manage database projects with Visual Studio 2010.
2010-10-15
4,254 reads
Policy-based Management and Central Management Servers
Whilst it may be more exciting as a DBA to rush around fixing broken databases, it is far better to forestall problems by making sure that your servers conform with best-practices. It is even better if you can also manage your servers centrally, and monitor that they are all adhering to company policies.
2010-10-14
2,380 reads
Auditing with Microsoft Assessment and Planning (MAP) Toolkit 5.0 - Part 3
Part 3 of the series on using MAP 5.0 looks at Software Usage Tracker audit mecanism, as well as migrating and uninstalling the MAP database.
2010-10-12
1,605 reads
Working with the INSERT statement in SQL Server
The INSERT statement in SQL Server is versatile. It now allows the insertion of multiple rows of literal values. It also provides the output clause that solves a number of common problems such as ascertaining the value of identity fields, and other calculated fields in tables, or for auditing the rows that are added to tables. Robert, once again, gives a clear introduction.
2010-10-11
5,220 reads
Event Notifications in SQL Server for Tracking Changes
As a DBA, we often need a way to track what events are occurring (changes that are being made) on SQL Server or at the database level. So what is a way to track these changes without much impact on SQL Server performance?
2010-10-08
5,125 reads
Auditing with Microsoft Assessment and Planning (MAP) Toolkit 5.0 - Part 2
Part 2 of the series on using MAP 5.0 looks at using the toolkit to inventory servers, preparing audit reports and server virtualization planning.
2010-10-07
2,031 reads
Blogs
A Pursuit of Lifelong Learning
By Brian Kelley
The following came across my YouTube feed today. It’s an interview with General James...
Advice I Like: Time and Focus
By Steve Jones
“You don’t need more time because you already have all the time that you...
Book Review: Microsoft 365 Copilot and Agent Administration Fundamentals
I don’t currently manage Microsoft 365 Copilot in an enterprise environment, but it is...
Forums
What Did Healthy Look Like?
Comments posted to this topic are about the item What Did Healthy Look Like?
DML Trigger Types
Comments posted to this topic are about the item DML Trigger Types
PostgreSQL in action with Opensearch
Comments posted to this topic are about the item PostgreSQL in action with Opensearch
Question of the Day
DML Trigger Types
How many types of DML triggers are there?
See possible answers