COMING SOON – New Content
Hey everyone. Long time no chat. I wanted to write this quick post to let you know why there haven’t been any videos in a while. If you are...
2020-07-16
18 reads
Bert Wagner
COMING SOON - New Content
Watch this week's video on YouTube
Hey everyone. Long time no chat. I wanted to write this quick post to let you know why there haven't been any videos in...
2020-07-16
13 reads
COMING SOON - New Content
Watch this week's video on YouTube
Hey everyone. Long time no chat. I wanted to write this quick post to let you know why there haven't been any videos in...
2020-07-16
4 reads
Using Python And NetworkX To Build A Twitter Follower Recommendation Engine
Watch this week’s video on YouTube. This week, I want to share my process for analyzing Twitter. Specifically, I want to find who all of my friends follow on...
2020-01-14 (first published: 2020-01-07)
298 reads
Using Python And NetworkX To Build A Twitter Follower Recommendation Engine
Watch this week's video on YouTube
This week, I want to share my process for analyzing Twitter. Specifically, I want to find who all of my friends follow on Twitter...
2020-01-07
11 reads
Using Python And NetworkX To Build A Twitter Follower Recommendation Engine
Watch this week's video on YouTube
This week, I want to share my process for analyzing Twitter. Specifically, I want to find who all of my friends follow on Twitter...
2020-01-07
6 reads
SQL Server Converts Numbers to Asterisks
Watch this week’s episode on YouTube. Pop quiz: What will be the output of the below three statements? As you might have guessed, the first conversion truncates the value,...
2019-12-17
227 reads
SQL Server Converts Numbers to Asterisks
Watch this week's video on YouTube
Pop quiz: What will be the output of the below three statements?
DECLARE @val_varchar varchar(3) = '100';
DECLARE @val_bigint bigint = 100;
DECLARE @val_tinyint tinyint = 100;
PRINT('varchar...
2019-12-17
8 reads
SQL Server Converts Numbers to Asterisks
Watch this week's video on YouTube
Pop quiz: What will be the output of the below three statements?
DECLARE @val_varchar varchar(3) = '100';
DECLARE @val_bigint bigint = 100;
DECLARE @val_tinyint tinyint = 100;
PRINT('varchar...
2019-12-17
12 reads
Azure SQL vs Azure Table Storage
Watch this week’s episode on YouTube. A year ago I built an app to keep track of pickup volleyball game scores and payments. It works well, but after a...
2019-12-03
2,084 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