FatherJack shows you how to check that your alerts and notifications are linked up so that when an Alert condition is met that you get the appropriate Notifications sent to Operators.
2011-12-05
2,306 reads
The XML data type, introduced in SQL Server 2005, is a powerful construct. When used wisely, it can provide useful extensions to SQL Server. Robert Sheldon, in the first part of a series, describes how create and index a XML column in a table, and discusses when you should consider using an XML data type.
2011-12-02
3,378 reads
SQL Server offers a simple tool for business users to perform ad-hoc reporting.
2011-12-01
3,439 reads
DBAs are often short on guidance on how to go about such tasks as planning, documenting and troubleshooting those aspects that are specific to the SSRS service. Feodor Georgiev gives some tips, custom SSMS reports, and useful TSQL queries.
2011-11-30
2,633 reads
The loss of a company's data is often enough to put the company out of business; and yet backup errors are generally avoidable with the application of common sense rather than deep technical knowledge. Grant digs into memories of his long experience of giving forum advice, to come up with the most easily preventable backup errors.
2011-11-29
2,910 reads
How to incorporate data mining directly into the Data Flow of SQL Server 2008 R2 Integration Services-based packages.
2011-11-28
2,226 reads
SQL Server is used to support many applications and one such feature of most applications is the storage of passwords. Sometimes there is a need to reset a password using a temporary password or generate a random password for a new user. In this tip I cover a simple stored procedure to generate random passwords that can be incorporated into your applications.
2011-11-25
4,497 reads
SQL Server's functions are a valuable addition to T-SQL when used wisely. Jeremiah Peshcka provides a complete and comprehensive guide to scalar functions and table-valued functions, and shows how and where they are best used.
2011-11-24
4,190 reads
SQL Server has produced some excellent High Availability options, but I was looking for an option that would allow me to access my secondary database without it being read-only or in restoring mode. I need the ability to see transactions occur and query the secondary database.
2011-11-23
2,321 reads
There are a number of ways of measuring and identifying I/O-related performance information for your SQL Server database instances.
2011-11-22
3,654 reads
By ReviewMyDB
The T-SQL Tuesday #201 round-up: nine bloggers on whether temp tables are a friend...
By Steve Jones
I have been experimenting with MCP servers in a few ways, including the Redgate...
By Zikato
I deployed a schema change to 30 servers using multi-server query and deploy-at-low-priority. Small...
Comments posted to this topic are about the item Admin Rights for Everyone
Comments posted to this topic are about the item Kerberos Authentication for Aurora PostgreSQL:...
Comments posted to this topic are about the item RegEx Functions I
Which of these RegEx functions need compatibility level 170 in SQL Server 2025?
See possible answers