Working From Home
It’s now been one month since I’ve started to work for Denny Cherry & Associates Consulting. Working for DCAC now enables...
2017-12-01
469 reads
Blog Posts
Working From Home
It’s now been one month since I’ve started to work for Denny Cherry & Associates Consulting. Working for DCAC now enables...
2017-12-01
175 reads
Design Concepts For Better Power BI Reports – Part 2: Preattentive Attributes
Preattentive attributes are visual properties that we notice without using conscious effort to do so. Preattentive processes take place within 200ms...
2017-11-30
851 reads
Eliminating Hassles
It is easy for me to fall into the trap of the “who” versus the “what”. If we are not...
2017-11-30 (first published: 2017-11-20)
1,291 reads
Fixing SQL AG Routing "Cannot find host" using packet analysis (and a spell checker)
I was setting up an availability group listener recently and when I tried to connect to the listener I got...
2017-11-30
652 reads
Fixing SQL AG Routing "Cannot find host" using packet analysis (and a spell checker)
I was setting up an availability group listener recently and when I tried to connect to the listener I got...
2017-11-30
225 reads
Fixing SQL AG Routing "Cannot find host" using packet analysis (and a spell checker)
I was setting up an availability group listener recently and when I tried to connect to the listener I got...
2017-11-30
211 reads
Fixing SQL AG Routing "Cannot find host" using packet analysis (and a spell checker)
I was setting up an availability group listener recently and when I tried to connect to the listener I got an error message to say “The host cannot be...
2017-11-30
16 reads
Handling Missing Instances when Looping with Pester
In my previous posts about writing your first Pester Test and looping through instances I described how you can start...
2017-11-30
684 reads
Hit Refresh
I read Satya Nadella’s Hit Refresh recently, and it was a very enjoyable book. He’s had an interesting journey and...
2017-11-30
674 reads
Blogs
Database AI Agents: The Read-Only Rule
By Arun Sirpal
Fourth in a series on Ai and databases. What Read-Only Advisory Actually Means A...
Creating a SQL Stored Procedure to Load a SCD2
By DataOnWheels
This is a blog that I am writing for future me and hopefully it’ll...
Funny Money: #SQLNewBlogger
By Steve Jones
While wandering around the documentation looking for some Question of the Day topics, I...
Forums
Pro SQL Server Internals
Comments posted to this topic are about the item Pro SQL Server Internals
SQL ART: Who's Blocking Who? Visualising SQL Server Blocking With Spatial Geometry
Comments posted to this topic are about the item SQL ART: Who's Blocking Who?...
Running SQLCMD II
Comments posted to this topic are about the item Running SQLCMD II
Question of the Day
Running SQLCMD II
I run this command to start SQLCMD:
sqlcmd -S localhost -E -c "proceed"At the prompt, I type this (the 1> and 2> are prompts):
1> select @@version 2> goWhat happens? See possible answers