SQL Saturday Richmond
SQL Saturday Richmond is just 5 days away and this will be the second time I have been selected to...
2018-03-19
245 reads
Blog Posts
Notes on Orlando Code Camp 2018
Good crowd, well organizedTook down registration early, perhaps 10 am, and that confused a few late(r) attendees (I like to...
2018-03-18
159 reads
Understanding Azure SQL Database- Introduction
Introduction:-
In this first article of the series Understanding Azure SQL Database in which I am going to publish in the...
2018-03-18
638 reads
Understanding Azure SQL Database- Introduction
Introduction:-
In this first article of the series Understanding Azure SQL Database in which I am going to publish in the coming weeks to understand Azure SQL Database concepts. After...
2018-03-18
10 reads
Webinar on Adaptive Query Processing for Data Platform Geeks
My session on Adaptive Query Processing has been finding significant interest in Data Platform events 🙂 Delivered 2 webinars for Data...
2018-03-18
764 reads
Webinar on Adaptive Query Processing for Data Platform Geeks
My session on Adaptive Query Processing has been finding significant interest in Data Platform events 🙂 Delivered 2 webinars for Data Platform Geeks community, one of them at American...
2018-03-18
23 reads
Webinar on Adaptive Query Processing for Data Platform Geeks
My session on Adaptive Query Processing has been finding significant interest in Data Platform events 🙂 Delivered 2 webinars for Data Platform Geeks community, one of them at American...
2018-03-18
7 reads
2.5 Ways Your ORM Is Vulnerable To SQL Injection
Someone recently told me that they don’t need to worry about SQL injection because they are using an ORM.
Oh boy.
ORMs don’t...
2018-03-16 (first published: 2018-03-06)
2,840 reads
Identify the owner and then change the owner of a SQL Agent Job
In this post and video you will learn how to identify the owner and then change the owner of a...
2018-03-16 (first published: 2018-03-06)
21,532 reads
Power BI Custom Visuals Class (Module 94 – Count Down Timer)
In this module you will learn how to use the Count Down Timer. The Count Down Timer is a very...
2018-03-16
392 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