My Prize Has Arrived!
Back in November, I was lucky enough to be nominated and then got enough votes to win the New to...
2011-01-17
533 reads
Gethyn Ellis
Which Process ID is SQL Server running on?
There was an interesting question posted on a forum recently, asking how can you tell which sqlservr.exe process (shown in...
2011-01-04
5,956 reads
Happy New Year
Well it’s Friday again and another big day.
Hopefully you all had a great Christmas and as we move to...
2010-12-31
1,490 reads
SELECT * FROM SQLBLOGGERS WHERE LOCATION = ‘UK’
I published a post yesterday where I listed my top 5 bloggers from the worldwide SQL community for 2010. The...
2010-12-30
1,920 reads
SELECT TOP 5 * FROM BLOGGERS
Hopefully my title gives away what this post is about. This my list of the top five people or more...
2010-12-29
531 reads
Merry Christmas
This is just a short post for a Friday and not just any old Friday either, Santa is on his...
2010-12-24
556 reads
SQL Bits 8
It seems the dates for the next SQLBITS have been released will take between April the 7th and April 9th...
2010-12-23
500 reads
Should I have AutoGrowth enabled on my SQL Server Database
I was reading a few forum posts yesterday where a few people were complaining that the transaction log had grown...
2010-12-22
1,997 reads
Turn Off AutoShrink!
This is kind of a follow up to a post I published last week regarding autogrowth. A forum poster said...
2010-12-20
611 reads
Let it Snow, Let it Snow, Let it Snow!
I don’t usually post on my blog on the weekend, but this weekend, the weekend before a Christmas is a...
2010-12-18
479 reads
Blogs
Microsoft Purview GA menu’s
By James Serra
The new data governance features in Microsoft Purview are now being made generally available...
Connect to Power BI as a Guest User in another Tenant
Sometimes your Microsoft Entra ID account (formerly known as Azure Active Directory) is added...
Parsing EXE Output in PowerShell
By Steve Jones
I saw a post internally that asked this question: Anyone have a handy powershell...
Forums
GIT Configuration and Automated Release for Azure Data Factory
Comments posted to this topic are about the item GIT Configuration and Automated Release...
Azure SQL Managed Instance: RESTORE HEADERONLY is terminating abnormally. (Micro
I'm trying to restore my database into Azure SQL Managed instance from blob storage...
I'm asking for guidance on how to best discover PK-FK relationships
Last night I spent 45 minutes composing a complicated question here. When I finished...
Question of the Day
Concat Addition
What is the result of this code?
SELECT CONCAT(1, 2, 3) + 4See possible answers