Undocumented SQL Server 2012 Security Stored Procedures SQL Server 2012 supports the following six undocumented security system stored procedures: sp_MSdbuseraccess sp_MSdbuserpriv sp_MSchangeobjectowner sp_MSGetServerProperties sp_MSloginmappings sp_MSSetServerProperties sp_MSdbuseraccess The sp_MSdbuseraccess system stored procedure is used to check what kind of access the current user has in the specified database or in all databases. Syntax sp_MSdbuseraccess [ @mode = ] ‘mode’, [ @qual...
SQL Server
Guidelines for Multilingual Web Design
Guidelines for Multilingual Web Design Globalization and multiculturalism have redefined online marketing. Consequently, Web design as such must also keep up with the requirements of the present-day multicultural and multilingual reality of business dealings. Before starting to create or adjust your Website to meet the expectations of users from all over the world, take into consideration the main tenets of...
Directing emails/alerts to the person/group who can diagnose the issue
Directing emails/alerts to the person/group who can diagnose the issue We need to determine which team should be contacted first if a given job (or job step in some cases) fails! A lot of times when there is an error in the middle of the night, the chances are that the DBA did not author the failing process and therefore...
Guidelines and Best Practices for developing and implementing a Reporting Solution with SQL Server 2014 – (Part 2)
Guidelines and Best Practices for developing and implementing a Reporting Solution with SQL Server 2014 – (Part 2) Author: Basit A. Farooq Editor’s Note: In the first of this three part article series, I discussed the considerations for creating reports. In this part, I will talk about the guidelines and best practices for implementing data sources and report layouts. Guidelines...
Intelligent error alerting to reduce On-call hours
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....
Undocumented SQL Server 2012 XML Stored Procedures
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 = ]...
Guidelines and Best Practices for developing and implementing a Reporting Solution with SQL Server 2014 – (Part 1)
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...
Useful undocumented SQL Server 2012 Agent Procedures
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...
Troubleshooting SQL Server 2012 CLR Problems
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...
A SQL Trick to Eliminate Unwanted Spaces
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...