Dissecting SQL Server, The Internal Structure of a Row
I’m sure that most of us know that SQL Server stores all it’s data in 8Kb pages. But what do...
2018-01-26 (first published: 2018-01-15)
2,002 reads
Reading GDPR
In case you’re interested, the GDPR law is actually not bad to read. You might be affected by this, so...
2018-01-15
474 reads
Getting Started in a SQL Server 2017 VM in Azure
You say you’re ready to dip your toes in the Azure ocean? Come on in, the water’s fine!
Oh, you want...
2018-01-26 (first published: 2018-01-15)
1,220 reads
Who should own the database?
TL;DR; SA, or if you are really paranoid then you can create a disabled SQL login with minimal permissions and...
2018-01-25 (first published: 2018-01-15)
2,714 reads
How I designed my VMware vSAN based Home Lab
(Be sure to checkout the FREE SQLpassion Performance Tuning Training Plan - you get a weekly email packed with all the...
2018-01-24 (first published: 2018-01-15)
2,641 reads
Renaming a local windows login after SQL Server Computer Name Change
I had an interesting issue last week. I had to rename non-domain (Workgroup) SQL Server Virtual Machine in Azure. The server...
2018-01-25 (first published: 2018-01-15)
7,258 reads
SQL Saturday Nashville 2018
I decided to go to the SQL Saturday at Nashville this year to get some good learning and networking in...
2018-01-15
446 reads
Steps to Configure SQL Server to Listen On A Specific TCP Port
Management of the database is very much essential in today’s date and for doing this, there is a need to...
2018-01-15
3,264 reads
Time to find a new place to live
Over the last couple of weeks I’ve been looking at various different locations around Dublin as my tenancy in the...
2018-01-15
273 reads
Linguistics Crisis In Microsoft Technology
With technology expanding in both complexity and quantity, the task to name each component and functions of a technology product...
2018-01-24 (first published: 2018-01-15)
1,702 reads
Blogs
T-SQL Tuesday #201 Round-Up: Temp Tables, Friend or Foe?
By ReviewMyDB
The T-SQL Tuesday #201 round-up: nine bloggers on whether temp tables are a friend...
Monday Monitor Tips: Configuring Access to the MCP Server
By Steve Jones
I have been experimenting with MCP servers in a few ways, including the Redgate...
The GO Barrier: Why SSMS Multi-Server Query Waits for the Slowest Connection
By Zikato
I deployed a schema change to 30 servers using multi-server query and deploy-at-low-priority. Small...
Forums
Admin Rights for Everyone
Comments posted to this topic are about the item Admin Rights for Everyone
Kerberos Authentication for Aurora PostgreSQL: Mapping AD Groups to Database Roles
Comments posted to this topic are about the item Kerberos Authentication for Aurora PostgreSQL:...
RegEx Functions I
Comments posted to this topic are about the item RegEx Functions I
Question of the Day
RegEx Functions I
Which of these RegEx functions need compatibility level 170 in SQL Server 2025?
See possible answers