Latest Blog Posts
How often is cost the deciding factor in the case of Windows vs Linux? And what if cost wasn’t a factor (noting that Linux isn’t “free” if you’re paying a support agreement)? If you look at cloud offerings Linux has an advantage in pricing because its, if not free, considerably… Read more
UPDATE: I also published a blog post using a DAX only approach. Check it out here.
Recently someone had a question if it was possible to change the color of a shape depending on the value of a measure. Imagine for example a dashboard with the picture of a… Read more
Restricting user to login from single host may be sometimes required from security point and other business requirements. We can achieve it through SERVER LEVEL LOGON TRIGGER.
ALTER TRIGGER TR_CHECK_LOGIN_TEST_HOST
ON ALL SERVER
DECLARE @HOSTNAME VARCHAR(48)
DECLARE @PROGNAME VARCHAR(100)
SELECT @HOSTNAME = HOST_NAME FROM SYS.DM_EXEC_SESSIONS Read more
There was a question from the op regarding adding a new column to a query output by generating the cyclic sequence numbers from 1 to 3.
Select A =identity(int,1,1),B,C from table_abs
For this output, the 4th column generates the Sequence of numbers… Read more
So, my blog got hacked. They edited the page where I thanked Rodney for all that he did. I had to remove that post as a part of the cleanup (still ongoing). However, I couldn’t let that stand. I’ve used caching on the internet to track down the original post… Read more
The SQL Tiger Team (t) has recently put out a guided walkthrough for SQL Connectivity issues.
If you look at the bottom of the announcement you’ll also notice links to walkthroughs for
I’m… Read more
A lot’s been said about last week’s Gitlab outage so I’m not going to go over the details here but I do want to talk about one point that was when I was watching the guys fix the issue live on youtube.
A lot of the people making comments kept… Read more
The new site of SQLPort is finally live. This is not just a redesign of the original site, published in April 2010. This is the start of the second approach that we shall start implementing right from the very next meeting, the 91th SQLPort meeting to be held on… Read more
Last week I blogged about how you can turn on Dark Theme in SSMS 2016 but that it’s unfinished and you can use it at your own risk.
As good quality 4K monitors in the 30+ inch range continue to get cheaper & cheaper I find myself wanting to have… Read more
I’m excited to announce that I have been named a Friend of Redgate for 2017. The program targets influential people in their respective technical communities such as SQL, .NET and ALM and enables us to participate in the conversation around product and community development.
As a multi-year awardee in the… Read more
Proactive Reporting for SQL Server
If you’re a return reader of this blog you know I write often about monitoring and performance of Availability Groups. I’m a very big proponent of using monitoring techniques to ensure you’re meeting your service level agreements in terms of recovery time objective and recovery… Read more
There are lots of tasks that are easily accomplished with bot h PowerShell and T-SQL.
This is something that has caused me some grief in my life as a DBA. I hesitate to call it a bug, but this little gottcha resurfaced in a change that was submitted by a teammate just today. So I wanted to share while it was fresh in my mind. Read more
In this module you will learn how to use the Box and Whiskers (Brad) Power BI Custom Visual. This is the second of two Box and Whiskers visuals that we have covered (You can learn more about the first one here). The Box and Whiskers chart is used to… Read more