(last updated: 2021-09-01 @ 14:18 ET / 2021-09-01 @ 18:18 UTC ) In my previous post, SSMS and SQLCMD: Prevent T-SQL Batch From Not Only Executing, but Also From...
2021-08-31
26 reads
(last updated: 2021-08-13 @ 19:50 ET / 2021-08-13 @ 23:50 UTC ) In a previous post, Prevent Full Script Execution (Understanding and Using PARSEONLY and NOEXEC), I explained how...
2021-08-25 (first published: 2021-08-13)
475 reads
(last updated: 2021-07-02 @ 19:55 EST / 2021-07-02 @ 23:55 UTC ) The sysname data type (in SQL Server) is a system-provided, though not built-in, alias for NVARCHAR(128). This...
2021-07-02
66 reads
(last updated: 2021-05-31 @ 19:00 EST / 2021-05-31 @ 23:00 UTC ) Many of us that work with Microsoft SQL Server, especially those of us working on systems with...
2021-05-21
16 reads
Presenting about Module Signing at "Data Architecture Day" this Saturday (May 16th) at 4:10 PM EDT… Continue reading Presenting at “Data Architecture Day” this Saturday (May 16th) at 4:10...
2020-05-14
24 reads
sys.xp_delete_files and 'allow filesystem enumeration': two new undocumented items in SQL Server 2019… Continue reading sys.xp_delete_files and ‘allow filesystem enumeration’: two new undocumented items in SQL Server 2019 ?
2020-01-27
469 reads
Is EXISTS(SELECT 1 ...) better than EXISTS(SELECT * ...)? Who would know better than SQL Server?… Continue reading Actual Difference Between EXISTS(SELECT 1 …), EXISTS(SELECT * …), and EXISTS(SELECT...
2020-02-03 (first published: 2020-01-24)
3,140 reads
A Completely Complete Guide to how many bytes are used to represent characters in the T-SQL string datatypes… Continue reading How Many Bytes Per Character in SQL Server: a...
2019-12-04 (first published: 2019-11-22)
3,730 reads
A misguided attempt to improve security that not only increases the chances of SQL Injection, but also prevented useful changes from being made.… Continue reading Feature Restrictions in...
2019-08-19 (first published: 2019-08-05)
1,159 reads
Specific String Pattern Magically Hidden From Step Output in SQL Agent History. Who Knew?… Continue reading Specific String Pattern Magically Hidden From Step Output in SQL Agent History ?
2019-06-21
152 reads
By Steve Jones
Today’s coping tip is let go of other people’s expectations of you. I think...
By gbargsley
Good morning dear blog reader. Today’s episode is fresh from a great weekend with...
By Steve Jones
Today’s coping tip is take your time. Make space to just breathe and be...
Hello Team, planning to do SQL in place upgrade from sql2016express to sql2016 standard...
I have two SQL 2019 servers running Master Data Services which are continually prompting...
$msg = Get-Content 'C:\miscjunk\SQL_Servers.txt' | ForEach-Object {New-Object 'Microsoft.SqlServer.Management.Smo.Server' $_} | Select-Object -Expand Databases |...
Ask SSC