Testing COALESCE with tSQLt (SQLServerCentral 8/17/2017)

[SQLServerCentral - www.sqlservercentral.com]( A community of more than 1,600,000 database professionals and growing Featured Contents - [Testing COALESCE with tSQLt]( - [How to Read a Transaction Log Backup]( - [Power BI NFL Football Stats Comparisons and Analysis Report is now available!]( (From the SQLServerCentral Blogs) - [Change RegisterAllProvidersIP setting on an existing Availability Group]( (From the SQLServerCentral Blogs) The Voice of the DBA Opinions and Votes This editorial was originally published on Aug 19, 2013. It is being re-run as Steve is away at the Data Platform Summit. When you work with a vendor, you may report bugs, issues, or strange behaviors in software. These area facts, and are valuable pieces of information that vendors do care about. When you exclaim that a particular bug or missing feature is critical, you're stating an opinion. The importance or priority you place on an item is not necessarily the same priority the vendor places on the item. We see this every day in our work, as clients and customers send us issues with our applications and systems. We triage the items and may or may not fix them in the order the customer would like them fixed. Our management may set priorities that we don't agree with. It's a complex interaction that involves many factors, all of which are weighed differently by different people. However the end user (client, customer, etc.) often doesn't understand why the priorities are different and why can't we just see how badly an item needs to be fixed? I see this all the time, though from the end user perspective. I use lots of software, and I find lots of issues and failings, especially in SQL Server. My priorities aren't Microsoft's priorities, and I accept that. I provide them with an opinion of what I think, not a vote. If they don't agree with my opinion, or choose to work on other priorities, I don't think they aren't listening to me. I think they disagree with my opinion. Like it or not, [politics]( is important here. The art of influence is important, and while an individual opinion doesn't matter, lots of opinions can have influence. Again, however, these are opinions and influences, not votes. We can convince Microsoft to change direction at times, or work on certain issues, but it takes participation and rational, reasonable debate, not childish exaggerated complaints and insults. We want to influence and convince, not upset and anger. Steve Jones from [SQLServerCentral.com]( Join the debate, and [respond to today's editorial on the forums]( ADVERTISEMENT [Foundry]( Using SQL Census to audit SQL Server permissions Redgate have just released SQL Census, a prototype tool that makes auditing SQL Server user access permissions much easier. In this post, Ally Parker shows how it works, tells us what's up next in the tool's development, and explains how you can download it for free. [Try the free prototype]( [Redgate Hub]( Stop your database being a bottleneck The new Redgate Hub is the shortcut to the latest insights into database development. Constantly updated with invaluable content, it’s the one resource you need to solve problems, share ideas, discover new tool features, and expand your database skills. [Discover the Redgate Hub]( Featured Contents  [] [Testing COALESCE with tSQLt]( Steve Jones from [SQLServerCentral.com]() Learn how you can use tSQLt to test your COALESCE queries.[More »]( ---------------------------------------------------------------  [] [How to Read a Transaction Log Backup]( Additional Articles from [Database Journal]() The transaction log backup is stored in SQL Server proprietary format, just like the transaction log itself. Even though the transaction log backup is in a special format, Microsoft has provided us with the fn_dump_dblog() function to read transaction log backups. This function is undocumented, so you should use care when using this function in a production environment.[More »]( ---------------------------------------------------------------  [] From the SQLServerCentral Blogs - [Power BI NFL Football Stats Comparisons and Analysis Report is now available!]( dustinryan from [SQLServerCentral Blogs]( For the past few years I’ve combined my love of professional football and analytics by releasing a series of Power...[More »]( ---------------------------------------------------------------  [] From the SQLServerCentral Blogs - [Change RegisterAllProvidersIP setting on an existing Availability Group]( willassaf@gmail.com from [SQLServerCentral Blogs]( Was working with a client who had an existing Availability Group, but did not have the RegisterAllProvidersIP setting enabled on...[More »]( Question of the Day Today's Question (by Steve Jones): I've captured a trace on a SQL Server 2012 instance that I want to replay on a different instance for upgrade testing. What versions of SQL Server can I target to replay this trace on and be supported by Microsoft? Think you know the answer? [Click here](, and find out if you are right. --------------------------------------------------------------- We keep track of your score to give you bragging rights against your peers. This question is worth 1 point in this category: Distributed Replay. We'd love to give you credit for your own question and answer. To submit a QOTD, simply log in to the [Contribution Center](. ADVERTISEMENT [Securing SQL Server: DBAs Defending the Database]( tag=redgatsof-20 linkCode=as2 camp=1789 creative=9325 creativeASIN=1484222644) Protect your data from attack by using SQL Server technologies to implement a defense-in-depth strategy, performing threat analysis, and encrypting sensitive data as a last line of defense against compromise. The multi-layered approach in this book helps ensure that a single breach doesn't lead to loss or compromise of your data that is confidential and important to the business. [Get your copy from Amazon today](. Yesterday's Question of the Day Yesterday's Question (by Steve Jones): I want to build a matrix in R that has 5 rows, 4 columns, and each value in the matrix is 7. How do I do this? Answer: matrix(7, 5, 4) Explanation: The Matrix command will build a matrix. The first parameter is the value, either a scalar or vector. In this case, we can use a scalar of 7. The next parameter is rows, and the third is columns. Ref: Matrix() - [click here]( --------------------------------------------------------------- [» Discuss this question and answer on the forums]( Database Pros Who Need Your Help Here's a few of the new posts today on the forums. To see more, [visit the forums](. --------------------------------------------------------------- [SQL Server 2016]( : [SQL Server 2016 - Administration]( [reboot server configured with AlwaysOn setup]( - hi i have 3 node server with alwaysOn setup 1-primary 2 -secondary 3-secondary. wanted to reboot any of them, is there any... [SA Password Unknown]( - Hi to all. SQL 2016 was installed in mixed mode. I cannot recall specifying SA password for a particular instance... [Tempdb setup for SQL 2016]( - Setting up a new server and going with Brent's recommendation to just create 8 tempdb files and pre-size them to... [Unable to connect to SQL 2008 Servers from SSMS 2017]( - Servers are running on SQL 2008 on Windows 2003. Client from where I am trying to connect to those servers... --------------------------------------------------------------- [SQL Server 2016]( : [SQL Server 2016 - Development and T-SQL]( [70-461 exam]( - I bombed this exam and afterwards discovered the 70-461 Querying Microsoft sql server 2012 book has nearly all the material... --------------------------------------------------------------- [SQL Server 2014]( : [Administration - SQL Server 2014]( [TDE Certificate backup]( - Hi Guys, I am trying to backup a certificate that I created for TDE but I am not successful. Please see... [Can't open the master key on Always on SQL Server]( - We have fail-over cluster for one of our production environment.  It has two node with SSISDB configured. Someone has configured... [RAMDisk? Use it for TempDB?]( - RAMDisk used to exist in Windows NT. I used it and it worked really well. Then, it was eliminated in... --------------------------------------------------------------- [SQL Server 2012]( : [SQL 2012 - General]( [SET NOCOUNT ON at instance level - not working.]( - Hello Members, I have configured nocount as default connection property using following command. EXEC sp_configure 'user options', 512. Unfortunately, when I connect... [Audit script for sqlserver to include: logins, permissions, last login date, last password change]( - Hi I am looking for an Audit script for sqlserver to include: logins, permissions, last login date, last password change for ALL... [Login failed password did not match for SQL loin]( - Hi , I am getting error when i login SQL Server 2012 ' Login failed password did not match" buit i can... --------------------------------------------------------------- [SQL Server 2012]( : [SQL Server 2012 - T-SQL]( [Query performance tuning - Slow execution time]( - I've been tasked with performance tuning the underlying query. I have attached all the necessary details but if there is... [Query performance tuning - taking more than 9 minutes]( - Below is one of the reporting query that is taking almost like more than 9 minutes to complete and as... [Time increments]( - Hi, I want to have a calculated field "TimeIncrements' that will increment 20 minutes starting at 8:00 and ending at 5:00... --------------------------------------------------------------- [SQL Server 2008]( : [SQL Server 2008 - General]( [Update same row twice]( - I know this is illegal with a merge, but is there a way to update the same row twice with... --------------------------------------------------------------- [SQL Server 2008]( : [T-SQL (SS2K8)]( [Subroutines in TSQL]( - I am a heavy TSQL coder, I love the many aspects of TSQL but I always wonder why we should... --------------------------------------------------------------- [SQL Server 2008]( : [SQL Server Newbies]( [Recovery Model-Tlog Backup]( - Good Morning Experts, We took a full backup of database which was in simple recovery mode. We changed recovery mode to... --------------------------------------------------------------- [SQL Server 2008]( : [SQL Server 2008 Administration]( [Can I restore a single file .mdf to multiple files spread across disks]( - I am trying to create a 2nd copy of my database which is 200GB so that I can do Log... --------------------------------------------------------------- [SQL Server 2008]( : [SQL Server 2008 Performance Tuning]( [Deducing from Wait Stats]( - Hi Everybody, The wait stats on the database I am assigned for performance tuning , shows that the PAGEIOLATCH_SH and CXPACKETS share... [SQL behaving strangely on different servers]( - Hi All, I have a sql statement working on static tables (no Insert,Update,Delete) on our testing server it's running very fast... This email has been sent to {EMAIL}. To be removed from this list, please click [here.]( If you have any problems leaving the list, please contact the webmaster@sqlservercentral.com. --------------------------------------------------------------- This newsletter was sent to you because you signed up at [SQLServerCentral.com](. Feel free to forward this to any colleagues that you think might be interested. If you have received this email from a colleague, you can register to receive it [here](. --------------------------------------------------------------- This transmission is ©2017 Redgate Software Ltd, Newnham House, Cambridge Business Park, Cambridge, CB4 0WZ, United Kingdom. All rights reserved. Contact: webmaster@sqlservercentral.com