Last Week Reading (2020-02-02)
Hello. We have a beautiful date today, haven’t we? And LWR posts are coming back after a long one-month break. Press Columnstore Indexes – part 130 (“Columnstore Indexes on...
2020-02-02
4 reads
Azure Player Blog
ASF 028: Uwe Ricken interview
Introduction Uwe Ricken is working with IT systems since the 90’s. He found the way to the technology of Microsoft SQL Server with the assignment for the development of...
2020-01-31
3 reads
ASF 028: Uwe Ricken interview
Introduction Uwe Ricken is working with IT systems since the 90’s. He found the way to the technology of Microsoft SQL Server with the assignment for the development of...
2020-01-31
3 reads
The recap of the passing year 2019
Good morning girls and boys, ladies and gentlemen, in the new year 2020! I recently thought that we had started a new decade. But that’s not true. The new...
2020-01-10
12 reads
The recap of the passing year 2019
Good morning girls and boys, ladies and gentlemen, in the new year 2020! I recently thought that we had started a new decade. But that’s not true. The new...
2020-01-10
3 reads
Last Week Reading (2019-12-29)
Hello boys & girls! This is the last post in “Last Week Reading” series in this decade. Can you believe that? Have you had a good Christmas time? Have...
2019-12-30
18 reads
Last Week Reading (2019-12-29)
Hello boys & girls! This is the last post in “Last Week Reading” series in this decade. Can you believe that? Have you had a good Christmas time? Have...
2019-12-30
5 reads
Last Week Reading (2019-12-22)
Hello. It’s been a while since the last post of this series appeared. I will do my best to keep this going. So, without unnecessary introductions – let’s move...
2019-12-22
4 reads
Last Week Reading (2019-12-22)
Hello. It’s been a while since the last post of this series appeared. I will do my best to keep this going. So, without unnecessary introductions – let’s move...
2019-12-22
4 reads
Deployment of Microsoft SQL database with Azure DevOps
Hello, data folks! I have published several articles about databases and their maintenance in SSDT project on the blog. One of the posts explained step by step how to...
2019-12-12
39 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