SQL Server 2017 on Linux in the Azure portal
SQL Server 2017 now is considered as a hybrid database enterprise solution as it expands its market and is ported to...
2018-04-06
390 reads
Blog Posts
SQLSaturday Tools
Much has been said about SQL Saturday tools and how PASS is pulling back from development of those tools past...
2018-04-06 (first published: 2018-03-27)
2,638 reads
Syspolicy Phantom Health Records
SQL Server comes with a default SQL agent job installed (for most installations) to help manage the collection of system health data. I would dare say this job is...
2018-04-06
69 reads
Use Boot Diagnostics to see what your Azure VM is doing at boot time
This blog post is about how to diagnose what your Azure VM is doing while it is booting.
I have a...
2018-04-06 (first published: 2018-04-04)
1,642 reads
When was my last backup / CheckDB / index maintenance?
Keep a good eye on your backup and maintenance; they’re kind of important to the health and well-being of your job wait I mean...
2018-04-06
362 reads
Changing the port for SQL Server in Azure Container Services
I got asked this question last week and it’s a very good one. After all, running Sql Server in Azure...
2018-04-05 (first published: 2018-04-04)
1,747 reads
Creating Bar Graph In SQL Server 2017 Using R
Creating a bar graph with R in SQL Server 2017 is relatively easy. It’s just a matter of finding the correct...
2018-04-05 (first published: 2018-04-03)
2,542 reads
Extending built-in data types
add generic user defined table data types as extension to built-in ones
2018-04-05
156 reads
Interesting Azure ARM "Make it So" behaviour
I had a template that deployed a premium managed disk and a virtual machine. I defined the disk like:
{ "comments":...
2018-04-05
127 reads
Interesting Azure ARM "Make it So" behaviour
I had a template that deployed a premium managed disk and a virtual machine. I defined the disk like:
{
"comments":...
2018-04-05
314 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...
AI: 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,...
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...
Ola Hallengren Index Optimize Maintenance can we have data compression = page
I have a quick question on Ola Hallengren Index Optimize Maintenance . Do we...
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