T-SQL Tuesday #89 – The times they are a-changing
This month’s T-SQL Tuesday is hosted by yours truly! The topic this month: how do you keep up with the...
2017-04-19 (first published: 2017-04-11)
1,748 reads
Koen Verbeeck
T-SQL Tuesday #89 Invitation – The times they are a-changing
T-SQL Tuesday is a monthly blog party for the SQL Server community (or Microsoft Data Platform community. Although it’s called...
2017-04-04
413 reads
T-SQL Tuesday #88 – The daily (database-related) WTF
It’s the time of the month again: the T-SQL Tuesday! This month’s edition is hosted by Kennie Nybo Pontoppidan (blog|twitter) and...
2017-03-14
481 reads
Hands-On Data Analysis With Power BI Desktop at PASS BA Marathon
I’m delighted to announce I’ll give a session at the next PASS BA webinar marathon. The topic of this marathon...
2017-03-06
405 reads
Webinar – Executing, Configuring and Scheduling SSIS 2016 Packages
I’ll be giving a webinar for MSSQLTips.com at March 30th. It’s a sponsored webinar, meaning there will also be a vendor...
2017-03-08 (first published: 2017-03-01)
1,504 reads
Not An Administrator For Analysis Services Tabular
A couple of weeks back I installed SQL Server 2016 on my personal machine, including SSAS Tabular. Yesterday I created...
2017-03-13 (first published: 2017-02-28)
1,998 reads
Updates to the Power BI course
Recently I published an open-source course/workshop to learn Power BI Desktop. Fellow MVP Dan English (blog | twitter) gave me the...
2017-02-16
485 reads
Open Source Power BI Desktop Workshop
I’ve created a free, open-source workshop to teach people the capabilities and features of Power BI Desktop. I was inspired...
2017-02-13
1,154 reads
Missing Checkbox for Security Filter in Power BI Desktop
Just a quick blog post so that other people don’t waste 15 minutes of their life looking for a missing...
2017-02-17 (first published: 2017-02-09)
2,754 reads
Dynamically Changing Shapes in Power BI – Alternatives
NOTE: the DAX presented in this blog post is written in my locale (nl-BE). This means that semicolons are used...
2017-02-16 (first published: 2017-02-08)
1,707 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