Latest Blog Posts
I saw a question recently about how to allow some users to see the logins on a server without being a sysadmin or securityadmin. This was in support of a migration effort, so users needed read rights without being able to change anything.
This appears to be a good place… Read more
Everyone deals with deadlocks from time to time. But sometimes we need to control who’s the deadlock victim and who isn’t. For example, I’m doing a big delete on a table in a 24×7 environment, I can’t afford downtime to do it so I’m doing my delete in small… Read more
Speaking at SQLSaturday Chicago!
In this module you will learn how to use the Gap Analysis Power BI Custom Visual. The Gap Analysis visual is used to analyze the difference between two different groups of data you have. For example, you might use it to analyze the gap between two answers people gave in… Read more
NOTE: the DAX presented in this blog post is written in my locale (nl-BE). This means that semicolons are used in the functions and lists instead of commas. Also, we use the comma as the decimal seperator. 0.95 (in the US) is 0,95 in my locale. A couple of well… Read more
I’ve been playing around with SQL containers on Windows Sever 2016 a lot recently and well, building empty SQL containers is all fine and dandy but it’s kinda missing the point. What containerization allows you to do is build custom images that are designed for your environment, say with a… Read more
The main idea here is to replace temp tables, where those data does not needs to…
Ensuring and maintaining team productivity practices is important for any organization, especially a small and growing team. The biggest part of the equation is each individual team member. Hiring productive employees is the foundation of any team or should be.
Here is a list of items I’ve found to be… Read more
It’s Tuesday and time to get Monday’s weekly blog and twitter round-up for last week out the door. It’s late and I need to find a better way to ensure that I get this out the published. If you haven’t already, follow me on twitter (@StrateSQL). This is… Read more
I love the questions I get while I’m presenting because they force me to think and learn. The question in the title is one I received recently. The answer, now that I’m not standing in front of people, is easy. Of course the space is not pre-allocated. Query Store tables… Read more
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