Scalar UDF Inlining in SQL Server 2019
How does Scalar UDF Inlining affect the performance of scalar functions?
SQL Server 2019 introduces a new feature called “Scalar UDF...
2019-03-14 (first published: 2019-02-25)
3,265 reads
Blog Posts
SQL Server – max server memory
Another re-post of a video from last year, this time showing you an in-built protection of setting max server memory...
2019-03-14
488 reads
#ITechDay in Warsaw
We were enjoying Thursday on conference in Warsaw. We have arrived pretty lately but easily saw the awesome atmosphere there....
2019-03-13
256 reads
Achieving SQL Server HA/DR with a mix of Always On Availability Groups and SANless SQL Server Failover Cluster Instances
Introduction
The topic of mixing SQL Server Failover Cluster Instances (FCI) with Always On Availability Groups (AG) is pretty well documented....
2019-03-13
2,517 reads
Data Warehousing Tip #9 – Test at Volume
My next tip is to test your BI solution with the volume of data that you are expecting. This is...
2019-03-13 (first published: 2019-02-25)
1,956 reads
Database Development Gone Wrong
I recently shared a story about how I was personally responsible for a development project going off the rails (and...
2019-03-13
431 reads
Database Development Gone Wrong
I recently shared a story about how I was personally responsible for a development project going off the rails (and oh boy, did it go off the rails). It’s...
2019-03-13
4 reads
Differences Between the Various Binary Collations (Cultures, Versions, and BIN vs BIN2)
(last updated: 2019-03-15 @ 02:45 EST / 2019-03-15 @ 06:45 UTC )
Binary collations are, in many ways, simpler to understand than non-binary collations...
2019-03-13
13,649 reads
Does SQL Server 2019 run on Ubuntu 18.04 LTS?
Yes. Here’s the proof from an output of SELECT @@VERSION: [crayon-5c98bf6b3202b962253620/] Here’s a screenshot of me running mssql-cli on the...
2019-03-13
684 reads
Enable Mail Profile – Back to Basics
I’ve seen many people go through the trouble of setting up database mail and configuring SQL Agent Alerts only to...
2019-03-13
266 reads
Blogs
TempDB Internals – What’s New (SQL Server 2016 to 2022)
By Vinay Thakur
I wrote about TempDB Internals and understand that Tempdb plays very important role on...
Blog a Day – Day 2: Generative AI, Multimodal Systems, and Agent AI
By Vinay Thakur
continuing from Day 1 where we covered the history of AI and GPT family,...
A Wellbeing Day at Redgate
By Steve Jones
It’s a day off for Redgate today. This is our annual wellbeing day, where...
Forums
A Quick Restore
Comments posted to this topic are about the item A Quick Restore
Guarding Against SQL Injection at the Database Layer (SQL Server)
Comments posted to this topic are about the item Guarding Against SQL Injection at...
Question of the Day
A Quick Restore
While doing some testing of an application, I wanted to reset my environment after doing some testing with this code:
USE DNRTest BACKUP DATABASE DNRTest TO DISK = 'dnrtest.bak' GO /* Bunch of stuff tested here */RESTORE DATABASE DNRTest FROM DISK = 'dnrtest.bak' WITH REPLACEWhat happens if this runs, assuming the "bunch of stuff" isn't anything affecting the instance. See possible answers