PASS Summit 2018 - A Lesson in Personal Branding
Last year at PASS Summit 2017, I heard a number of comments related to people not recognizing me without the hat in my social media photo/avatar. The linked post...
2018-11-28
1 reads
Blog Posts
Price increase for Azure in Canadian dollars
On 1 December 2018, Microsoft is increasing Azure subscription prices in Canadian dollars by 5%. The following is taken directly...
2018-11-28
238 reads
T-SQL Tuesday 108 – Learning R
I am the proud host of TSQL Tuesday for the month of November 2018.
My call to post entries is here ....
2018-11-28 (first published: 2018-11-18)
2,231 reads
Auditing when Database Files Change
As a Database Administrator, something that should be part of your database audit is monitoring the growth of files. That...
2018-11-27
496 reads
Auditing when Database Files Change
As a Database Administrator, something that should be part of your database audit is monitoring the growth of files. That means tracking when the log file grows and tracking...
2018-11-27
10 reads
Brute Forcing SQL Logins and Passwords
Watch this week’s episode on YouTube.Following up on last week’s post about the different types of SQL injection, this week...
2018-11-27
1,034 reads
Brute Forcing SQL Logins and Passwords
Watch this week's video on YouTube
Following up on last week's post about the different types of SQL injection, this week I want to show how injection can be used...
2018-11-27
3 reads
Brute Forcing SQL Logins and Passwords
Watch this week's video on YouTube
Following up on last week's post about the different types of SQL injection, this week I want to show how injection can be used...
2018-11-27
9 reads
Database Stuck in Suspect Mode
My holiday week did not started off very good. I come in and find a UAT environment database in suspect...
2018-11-27
24,832 reads
Midlands PASS Meetings for January and February 2019
Midlands PASS won’t be holding a meeting in December. Too much going on! However, we are hosting meetings in January...
2018-11-27
205 reads
Blogs
Identity Columns Can’t Be Updated: #SQLNewBlogger
By Steve Jones
I’m not sure I knew identity column values could not be updated. I ran...
Rolling Back a Broken Release
By Steve Jones
We had an interesting discussion about deployments in databases and how you go forward...
A bespoke reporting solution doesn’t have to cost the earth
By ChrisJenkins
You could be tolerating limited reporting because there isn’t an off the shelf solution...
Forums
Can someone please explain what happens?
I have mentioned this several times over several years. Can someone please help me...
SELECT COUNT(DISTINCT) returns null when nothing is found instead of 0
SELECT COUNT(DISTINCT Component) AS Found FROM tblComponents WHERE(Component NOT LIKE '%[a-z]%') AND(LTRIM(RTRIM(Component)) = 'GM13622')...
Remotely Engineer Fabric Lakehouse objects: The Fabric Modern Data Platform
Comments posted to this topic are about the item Remotely Engineer Fabric Lakehouse objects:...
Question of the Day
Creating JSON III
In a SQL Server 2025 table, called Beer, I have this data:
BeerIDBeerName 1Becks 2Fat Tire 3Mac n Jacks 4Alaskan Amber 8KirinI run this code:
SELECT JSON_OBJECTAGG(
BeerID: BeerName )
FROM beer;
What are the results? See possible answers