4 SQL Injection Techniques For Stealing Data
Watch this week's video on YouTube
I'm not advocating that you start using SQL injection to start stealing other people's data.
However, I do think that you should familiarize...
2018-11-20
2 reads
Blog Posts
A Problem with POWER()
I ran into an interesting problem while working with the POWER() function. I was trying to do some binary conversions...
2018-11-20
800 reads
Bad Query Performance Tips Rebutted
Once upon a time, someone, somewhere, wrote a list of bad query performance tips and they’ve been copied all over...
2018-11-20 (first published: 2018-11-12)
3,234 reads
How Long is That Event Taking
Knowing just how long an event takes is a common requirement when troubleshooting. Sometimes, figuring out the unit of time...
2018-11-20
247 reads
How Long is That Event Taking
Knowing just how long an event takes is a common requirement when troubleshooting. Sometimes, figuring out the unit of time is a bit troublesome. Is it milliseconds, seconds or...
2018-11-20
1 reads
Power BI World Tour–Dallas Nov 27-29
Please join the Power BI User Community in Dallas on Nov 27th through the 29th for the Power BI World...
2018-11-20
204 reads
Power BI World Tour–Dallas Nov 27-29
Please join the Power BI User Community in Dallas on Nov 27th through the 29th for the Power BI World Tour. There will be a one-day workshop on Tuesday...
2018-11-20
18 reads
Reasons to Serve on the PASS Board of Directors
A few weeks back I wrote Some Thoughts on How To Prepare to Serve on the PASS Board of Directors....
2018-11-20 (first published: 2018-11-11)
1,527 reads
Testing if a Port is Open With PowerShell
Ever want to confirm that a port is accessible from one computer to another? There’s a PowerShell cmdlet for that,...
2018-11-20
6,748 reads
Testing if a Port is Open With PowerShell
Ever want to confirm that a port is accessible from one computer to another? There’s a PowerShell cmdlet for that, Test-NetConnection. With the -Port option, this cmdlet will do...
2018-11-20
51 reads
Blogs
2025 Wrapped for Steve
By Steve Jones
I’ve often done some analysis of my year in different ways. Last year I...
The Book of Redgate: Spread across the world
By Steve Jones
This was Redgate in 2010, spread across the globe. First the EU/US Here’s Asia...
Merry Christmas
By John
Today is Christmas and while I do not expect anybody to actual be reading...
Forums
SQL Server 2019 - Agent job PowerShell step issue
I have a couple of SQL Agent job steps which run PowerShell commands of...
Database security permissions save script
Comments posted to this topic are about the item Database security permissions save script
Database backup job steps
I have a SQL Agent job for backing up a set of Analysis Services...
Question of the Day
The Large Encoded Value
I want to use the new BASE64_ENCODE() function in SQL Server 2025, but return a string that isn't large type. What is the longest varbinary string I can pass in and still get a varchar(8000) returned?
See possible answers