Is Transparent Data Encryption just security theatre?
I love theatre. In six months I am putting on two one-act plays for a local festival, because I don’t...
2017-11-08
327 reads
Randolph West
- Twitter: @_randolph_west
- Website: https://bornsql.ca/blog/
- LinkedIn: https://linkedin.com/in/rabryst/
Gimmicks that work: XE Profiler in SQL Server Management Studio
I have a favourite new feature of SQL Server Management Studio 17.3 (SSMS), and that’s XE Profiler, which allows you to...
2017-11-01
488 reads
Repair a Windows Server 2016 installation
This is more for my benefit in the future, but hopefully it can help someone else too. We recently had...
2017-10-25
4,160 reads
The perils of RAID
Recently, I was asked to assist an organization with getting their data back for a SQL Server that had experienced...
2017-10-18
619 reads
Why is a value in DATETIME2 8 bytes, but in BINARY it is 9 bytes?
In the #sqlhelp Slack channel on the SQL Server Community Slack workspace last month, Jemma Hooper asked: When trying to...
2017-10-11
453 reads
Changes to Service Packs and Cumulative Updates for SQL Server 2017
For a few years now, Microsoft has augmented its irregular release of Service Packs with a more frequent Cumulative Update...
2017-10-04
439 reads
Compañero Conference and SQL Modernization Roadshow
October is a busy month for me. I am flying all over the US and Canada for speaking engagements to...
2017-09-27
540 reads
Does rebuilding my clustered index also rebuild my non-clustered indexes?
I’ve been working with SQL Server for many years now, and up until recently, I assumed that rebuilding any clustered...
2017-09-20
424 reads
A trillion and one
Joe Obbish wrote an epic post a few weeks ago about loading a trillion rows into a non-partitioned table in...
2017-09-13
436 reads
Connect Windows 10 client to a VPN on Windows Server 2012 R2
I got a strange request in a Slack channel the other day. A colleague in South Africa, who uses Windows,...
2017-09-06
378 reads
Blogs
My 2024 in Data: Music
By Steve Jones
This is my last week of the year working (I guess I come back...
A New Word: Suente
By Steve Jones
suente– n. the state of being so familiar with someone that you can be...
Side Projects
Anyone (everyone?) who has ever tried to learn a programming language knows that to...
Forums
Timeout Error while executing a TSQL statement in Sql server Express Edition
I am getting the below error when I execute a SQL command in SQL...
Timeout Error while executing a TSQL statement in Sql server Express Edition
I am getting the below error when I execute a SQL command in SQL...
Sql script replace and rearrange numbers
Hi everyone. I have this table and this information. (left side of the image)...