Top 10 most popular SQL Server articles for 2017

2017 was a great year for sqlserver-dba.com , thanks for all the feedback and the great discussions I've had through the sql server community. These are the 10 most read articles on sqlserver-dba.com for 2017 SQL Server – DBA Scripts Powershell Script Library for DBA (SQL Server DBA) Calculate sql row size (SQL Server DBA) How to fix System.OutOfMemoryException when using SSMS (SQL ... SQL Server – Pageiolatch_sh and how to reduce it (SQL Server DBA) SQL Server RUNNABLE – SUSPENDED – RUNNING status model ... Top 4 Best SQL Editors (SQL Server DBA) SQL Server – Find queries causing... Read more →

12 factor app and database services

I’ve been looking at the 12 factor apps manifesto and how it relates to database servers. Modern developers reference the 12 factor app manifesto and from discussing with a range of developers and system administrators, I’m starting to understand there is a wide variety of intepretations and criticisms about the 12 factor principles The intention of the 12 factor manifesto is to standardise the conversation for the application development space. Applications are going through a large revolution – questioning the traditional Enterprise stack and transitioning to SaaS architecture . 12 factor focuses on the concepts of how to identify patterns.... Read more →

Top 30 SQL Blogs & Websites for Microsoft SQL Server Administrators

To my surprise and all-round pleasure , www.sqlserver-dba.com was rated #19 on the Top 30 SQL Blogs & Websites for Microsoft SQL Server Administrators . There are some good SQL Server DBA blogs on this list , which I've followed and learnt all sorts of things related to SQL Server technologies and troubleshooting. So , I wanted to thank the panel who voted sqlserver-dba.com I enjoy writing posts for sqlserver-dba.com and sharing solutions , scripts and knowledge sharing , which help me to keep learning and also sharing with fellow DBAs. I hope you keep enjoying the blog and Contact... Read more →

How to list Extended stored procedure for public

Extended stored procedures are used by developers to create routines. One of the main benefits of extended stored procedures is the ability to make them appear as regular stored procedures. i.e input parameters can be sent by the calling application , and result sets are returned. SQL Server is installed with a bunch of extended stored procedure with permissions granted to public. You’ll recognise quite a few including : sp_cursor, sp_cursor_open ,sp_executesql . There are about 80 of them installed with public permissions. Microsoft announced to extended stored procedures will be deleted in future versions , so if you’re a... Read more →

How to write a conditional substring in sql

Question: I have a SELECT statement returning a recordset . Before presenting the recordset , I want to strip out some of the substrings within certain records. This is an example of the recordset Brazil Brazil.com Argentina.net Bolivia The requirement is to strip out any part of the string from the dot and after. For example, “brazil.com” will become “brazil”. The problem I have currently is by running the SUBSTRING function across all the rows, if there is no dot in the row , the rown will return as blank. The only rows returning are the ones with a dot!... Read more →