Standard Members

Pro Members SQL Server Standard Members

Intelligent error alerting to reduce On-call hours

by

Intelligent error alerting to reduce On-call hours: The purpose of this article is to get you some much needed sleep! Yes, you heard me! So try to stay awake for this! I intend to introduce you to a few tried and true strategies to improve error and issue resolution and ultimately get you and your teammates a good night’s sleep....

This content is for Pro, Pro Member, Pro Member Annual - Fall Sale, Pro Member Monthly - Fall Sale, Standard, Standard Member, Standard Member Annual - Fall Sale, and Standard Member Monthly - Fall Sale members only.
Register
Already a member? Log in here
Continue Reading →
Pro Members SQL Server Standard Members

Undocumented SQL Server 2012 XML Stored Procedures

by

Undocumented SQL Server 2012 XML Stored Procedures SQL Server 2012 supports the following three undocumented XML system stored procedures: – sp_syscollector_validate_xml – sp_xml_schema_rowset – sp_xml_schema_rowset2 sp_syscollector_validate_xml The sp_syscollector_validate_xml system stored procedure is used to validate the XML collector. Syntax sp_syscollector_validate_xml [ @collector_type_uid = ] ‘collector_type_uid’, [ @name = ] ‘name’, [ @parameters = ] ‘parameters’ Arguments [ @collector_type_uid = ]...

This content is for Pro, Pro Member, Pro Member Annual - Fall Sale, Pro Member Monthly - Fall Sale, Standard, Standard Member, Standard Member Annual - Fall Sale, and Standard Member Monthly - Fall Sale members only.
Register
Already a member? Log in here
Continue Reading →
Pro Members SQL Server Standard Members

Guidelines and Best Practices for developing and implementing a Reporting Solution with SQL Server 2014 – (Part 1)

by

Guidelines and Best Practices for developing and implementing a Reporting Solution with SQL Server 2014 – (Part 1) Author: Basit A. Farooq Introduction Your reporting solution design should match technologies provided by Microsoft SQL Server™ 2014 Reporting Services to the requirements and abilities of users, and the requirements of the business. The documents that make up your reporting specification should...

This content is for Pro, Pro Member, Pro Member Annual - Fall Sale, Pro Member Monthly - Fall Sale, Standard, Standard Member, Standard Member Annual - Fall Sale, and Standard Member Monthly - Fall Sale members only.
Register
Already a member? Log in here
Continue Reading →
Development Pro Members Standard Members

How Can Remote Employees Connect with Co-Workers?

by

How Can Remote Employees Connect with Co-Workers? Hello, this is Laura Lee Rose. I am a speaker and author. My background is in time and project management. I help busy professionals and entrepreneurs create effective systems so that they can comfortably delegate to others, be more profitable and have time to enjoy life even if they don’t have time to...

This content is for Pro, Pro Member, Pro Member Annual - Fall Sale, Pro Member Monthly - Fall Sale, Standard, Standard Member, Standard Member Annual - Fall Sale, and Standard Member Monthly - Fall Sale members only.
Register
Already a member? Log in here
Continue Reading →
Pro Members SQL Server Standard Members

Useful undocumented SQL Server 2012 Agent Procedures

by

Useful undocumented SQL Server 2012 Agent Procedures SQL Server 2012 supports the following useful undocumented SQL Server Agent stored procedures: sp_MSgetalertinfo sp_readerrorlog sp_MSget_jobstate sp_delete_all_msx_jobs sp_get_job_alerts sp_multi_server_job_summary sp_help_operator_jobs sp_sqlagent_is_srvrolemember sp_sqlagent_get_startup_info Three of these stored procedures exist in the master database (sp_MSgetalertinfo, sp_readerrorlog and sp_MSget_jobstate), other exist in the msdb database. sp_MSgetalertinfo The sp_MSgetalertinfo stored procedure is used to get information about...

This content is for Pro, Pro Member, Pro Member Annual - Fall Sale, Pro Member Monthly - Fall Sale, Standard, Standard Member, Standard Member Annual - Fall Sale, and Standard Member Monthly - Fall Sale members only.
Register
Already a member? Log in here
Continue Reading →
Pro Members SQL Server Standard Members

Troubleshooting SQL Server 2012 CLR Problems

by

Troubleshooting SQL Server 2012 CLR Problems If you have problems with SQL Server 2012 Common Language Runtime (CLR) objects, review this troubleshooting checklist to find potential solutions. 1. Install the latest SQL Server 2012 service pack. Because some SQL Server 2012 CLR bugs were fixed in SQL Server service packs, you should install the latest SQL Server service pack. At...

This content is for Pro, Pro Member, Pro Member Annual - Fall Sale, Pro Member Monthly - Fall Sale, Standard, Standard Member, Standard Member Annual - Fall Sale, and Standard Member Monthly - Fall Sale members only.
Register
Already a member? Log in here
Continue Reading →
Pro Members SQL Server Standard Members

A SQL Trick to Eliminate Unwanted Spaces

by

A SQL Trick to Eliminate Unwanted Spaces by Craig Mullins Data integrity can be a vexing, but there are some data integrity issues that can be cleaned up using a touch of crafty SQL. Consider the common data entry problem of extra spaces in a name field. Not only is it annoying, sometimes it can cause the system to ignore...

This content is for Pro, Pro Member, Pro Member Annual - Fall Sale, Pro Member Monthly - Fall Sale, Standard, Standard Member, Standard Member Annual - Fall Sale, and Standard Member Monthly - Fall Sale members only.
Register
Already a member? Log in here
Continue Reading →
Development Pro Members Standard Members

Tips to Managing Two Jobs for One Paycheck

by

Tips to Managing Two Jobs for One Paycheck Hello, this is Laura Lee Rose. I am a speaker and author. My background is in time and project management. I help busy professionals and entrepreneurs create effective systems so that they can comfortably delegate to others, be more profitable and have time to enjoy life even if they don’t have time...

This content is for Pro, Pro Member, Pro Member Annual - Fall Sale, Pro Member Monthly - Fall Sale, Standard, Standard Member, Standard Member Annual - Fall Sale, and Standard Member Monthly - Fall Sale members only.
Register
Already a member? Log in here
Continue Reading →
Pro Members SQL Server Standard Members

Undocumented SQL Server 2012 extended stored procedures (Part 2)

by

Undocumented SQL Server 2012 extended stored procedures (Part 2) An extended stored procedure (xp) is a dynamic link library that runs directly in the address space of SQL Server. You can run extended stored procedures as normal stored procedures. Extended stored procedures are used to extend the capabilities of SQL Server. You can take advantage of the many extended stored...

This content is for Pro, Pro Member, Pro Member Annual - Fall Sale, Pro Member Monthly - Fall Sale, Standard, Standard Member, Standard Member Annual - Fall Sale, and Standard Member Monthly - Fall Sale members only.
Register
Already a member? Log in here
Continue Reading →
Oracle Pro Members Standard Members

Using SQL/XML functions XMLExists and XMLCast

by

Using SQL/XML functions XMLExists and XMLCast By Yuli Vasiliev This article reveals how you might use SQL/XML functions in your SQL statements accessing XML data, thus taking advantage of both SQL and XML in a single query. In particular, the article focuses on the XMLExists function that is used to evaluate the XQuery expression passed in, checking whether it returns...

This content is for Pro, Pro Member, Pro Member Annual - Fall Sale, Pro Member Monthly - Fall Sale, Standard, Standard Member, Standard Member Annual - Fall Sale, and Standard Member Monthly - Fall Sale members only.
Register
Already a member? Log in here
Continue Reading →
1 … 72 73 74 75 76 … 110