(Derik Hammer) When a cluster has an Availability Group installed on it, there is an optional listener which is used to manage connections through fail-over events. This listener has an IP address assigned to it and, when the Availability Group fails over within the same sub-net, the listener simply
Tag: sql server
Format Durations in SQL Server Analysis Services
(Koen Verbeeck) I have a fact table in my data warehouse that tracks durations of certain events as the total number of seconds that have passed. When users browse the cube, I’d like to show these durations formatted as time using the hh:mm:ss format (hours:minutes:seconds).
SQL SERVER – How to use Procedure sp_user_counter1 to sp_user_counter10
(Pinal Dave) There are many performance counters available in SQL Server which can be used to monitor various parameters of SQL Server engine. Have you ever been into a situation where you want to see value in performance counter for a query which you have returned?
Power Query Now Works With SSAS
(Chris Webb) I normally don’t bother blogging when one of the Power Query monthly updates gets released – the posts on the Power BI blog have all the details and there’s nothing more to add.
Auto Fix SQL Server Transactional Replication Error 20598 for DELETEs
(Jeffery Yao) From time to time you may see replication error 20598 for DELETEs. This a pain to fix manually and we often do not want to resort to having to redo the snapshot or skip the error. In this tip I show how you can deal with this error.
Mission-Critical Performance Enhancements Coming in SQL Server 2014
(Kevin Kline) Last month I told you about the overall set of features which Microsoft plans to release when SQL Server 2014 (SQL2014) is released to manufacturing. Microsoft has three major feature sets that they are advancing with SQL Server 2014 (SQL2014). One is called “Mission Critical Performa
Capturing DB Usage stats – sp_spaceused simulation using DMV’s.
(Prashanth Jayaram) sp_spaceused is one of the system stored procedure used frequently by many dba’s that reveals amount of space used by database/tables. This procedure can be executed either by passing parameters or no parameters.
How Do I combine results from more than one table?
(Kris Wenzel) All the examples for this lesson are based on Microsoft SQL Server Management Studio and the AdventureWorks2012 database.
SQL SERVER – Fix : Msg 230, Level 14, State 1 – The SELECT permission was denied on the object, database, schema – Part II
(Pinal Dave) A couple of days back I wrote the blog on Msg 230 and thought it was one of the simplest implementations of access control on the system. To continue with the code in this blog, please make sure you read the same first before getting into the examples here.
Putting sp_ at the beginning of your stored procedure.
(Kenneth Fisher) Every now and again you see articles and posts about putting sp_ at the beginning of a stored procedure. So what does that do and why should we care? The primary effect is that if you put a stored procedure starting with sp_ in master you can call it directly from any database.