Conditional Default Values in SSRS
I’d like to share with you a laziness efficiency method I use when developing reports in SQL Server Reporting Services. ...
2012-02-07
3,406 reads
Blog Posts
Convert comma separated string to table and vice versa
I know that this subject has been blogged about numerous times but I thought I'd post an alternative way of...
2012-02-07
18,778 reads
Denali
Is all set to be officially known as SQL 2012 and will be finally released in....... 2012!
Announced at the PASS...
2012-02-07
840 reads
February 2012 – Monthly SQL Server Checklist
It’s the first Monday of February, mostly, it’s a short month, but there’s no reason to skirt on checking out...
2012-02-07
821 reads
Finding the Missing Perfmon Counters in SQL Express
My post this weekend about slaying beasts with magical .dll incantations was my way of relieving some stress after having...
2012-02-07
2,384 reads
Freedom
Not too long ago, I blogged about a Book called Daemon. Freedom is the sequel to Daemon. I enjoyed reading this book. The story continues from Daemon, but in...
2012-02-07
7 reads
Freedom
Not too long ago, I blogged about a Book called Daemon. Freedom is the sequel to Daemon.
I enjoyed reading this...
2012-02-07
713 reads
LAST_VALUE() Analytic Function–SQL Server 2012
Earlier, i discussed FIRST_VALUE() function. FIRST_VALUE() returns the first value from an ordered set of records. Similarly LAST_VALUE() returns the last...
2012-02-07
2,704 reads
List failed SQL server Jobs with Powershell
This post explains how to list failed SQL Server Jobs , on multiple SQL Server Instances and output the results to...
2012-02-07 (first published: 2012-02-06)
2,296 reads
Opt In/Out of Personalized Microsoft Ads
Nice to have the option, you can opt-out (default is in) of having personalized ads. I turned it off, the...
2012-02-07
821 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,...
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