Datediff: We’ve Been Doing It Wrong
One of the most common mistakes people make when writing T-SQL is using a function in the where clause, and...
2017-01-23
2,228 reads
Blog Posts
Error While running PowerShell code from SQL Agent job – “Path Does Not Exist”
Issue: When I am running code from PowerShell console its running fine but when I execute it through SQL agent...
2017-01-23
1,045 reads
How to Exclude Entire Sections in VS Schema Compare
Right now I am so excited, and a little embarrassed. After using Visual Studio (VS) for database projects for the...
2017-01-23
6,134 reads
Monday Coffee 2017-01-23
I like to think of myself as a fairly hardworking, motivated person. However I recently met someone who regularly gets...
2017-01-23
303 reads
Notes from the January 2017 oPASS/MagicPASS Meeting
This was a good meeting. About 50 attendees showed up at Nova (we use their space for joint meetings) to...
2017-01-23
374 reads
Power BI Subscriptions
Newly added to the Power BI Service is a much awaited feature called Power BI Subscriptions. If you’ve worked in...
2017-01-23 (first published: 2017-01-17)
2,278 reads
SQL Server 2016: JSON integration
Abstract
This article helps to explain the application of JSON data and the use of new SQL 2016 constructs that enable...
2017-01-23
5,396 reads
Useful #SQLPrompt Tips
One of the tools that Redgate write is SQL Prompt. This might be my favorite product, and I’m constantly impressed...
2017-01-23
706 reads
Using Extended Events Telemetry Session
You are probably wondering what this is, quite honestly I was wondering too. Well it is an extended events session...
2017-01-23
1,906 reads
What Is Your Career Investment Portfolio?
Every year, financial advisors will recommend their clients to take a review of their investment portfolio and make necessary changes...
2017-01-23
718 reads
Blogs
TempDB Internals – What’s New (Sql Server 2016 to 2025)
By Vinay Thakur
I wrote about TempDB Internals and understand that Tempdb plays very important role on...
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,...
A Wellbeing Day at Redgate
By Steve Jones
It’s a day off for Redgate today. This is our annual wellbeing day, where...
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