Load Extended Events via Powershell
Learn how you can load Extended Events with PowerShell, nice and fast.
2020-12-18 (first published: 2017-08-22)
4,218 reads
XE
RE: Need to seperate string in two columns using T-SQL
create table testtable (Col1 varchar(50), Col2 varchar(50), Col3 varchar(50)) go insert into testtable (Col1) SELECT 'Americas - NorthEast' UNION SELECT 'Americsa - SouthEast' UNION SELECT 'Europe - North Region' UNION SELECT 'Asia - SouthEast' GO SELECT * FROM TESTTABLE update testtable SET COL2 = LEFT(COL1,PATINDEX('% %', COL1)), COL3 = RIGHT(COL1,LEN(COL1)-(PATINDEX('%-%', COL1)+1)) GOSELECT * […]
2005-02-09
Blogs
Real-World SQL Mastery: Your Hands-On, Mess-Free Sandbox
Are you ready to take your SQL skills from theoretical to tactical? If you've...
Set a Runtime Variable in an Azure DevOps Pipeline
By Steve Jones
Note: I DO NOT recommend this. Any changes to a pipeline should be in...
A New Word: Symptomania
By Steve Jones
symptomania – n. the fantasy that there’s some elaborate diagnosis out there that neatly...
Forums
7 sept, scheduled book
Comments posted to this topic are about the item 7 sept, scheduled book
7 sept, schedlued article
Comments posted to this topic are about the item 7 sept, schedlued article
6 sept, published book
Comments posted to this topic are about the item 6 sept, published book
Question of the Day
Azure Data Lake Storage Gen 2
Azure Data Lake Storage Gen 2 is built on ...?
See possible answers