Ten Essential Traits for DBA Success
There is greatness within you whether you believe it or not. Over the years there are certain skills that have...
2016-08-31 (first published: 2016-08-23)
2,267 reads
The SQL Professor
Are SQL Saturday’s Worth It?
This past weekend I was fortunate enough to be a part of Louisville’s (for those local the ‘ville) SQL Saturday event held...
2016-08-18 (first published: 2016-08-12)
1,674 reads
T-SQL Tuesday #080–Round Up
The roundup is finally here, and cheers to all of you who participated. We had a great turnout this month...
2016-07-19
358 reads
T-SQL Tuesday #080
T-SQL Tuesday time is here again! And I’m honored to be hosting this months block party. Why you ask? T-SQL...
2016-07-07
916 reads
Is Today Your Last Day Working With SQL?
Please entertain this thought for a moment – If today was your last day working with SQL how would you spend...
2016-07-08 (first published: 2016-06-29)
3,326 reads
Interview with Warwick Rudd
Part of traveling to various events and being a part of the SQL Community means one can meet some pretty...
2016-05-09 (first published: 2016-04-26)
1,008 reads
The Next Chapter ~ A SQL Journey
The past five years have been nothing short of an amazing ride on this thing we call “The SQL Journey”....
2016-04-14
410 reads
Time Management–Leadership
To many times data professionals flounder in what some call a pool of uncertainty. The countless tasks, tickets, projects, and emails...
2016-03-16
484 reads
T-SQL Tuesday #75 Invitation: Jump into Power BI!
This month the talented Jorge Segarra (B|T) hosts the T-SQL Tuesday block party, and he has chosen the topic of...
2016-02-16
488 reads
Leadership and the Data Professional
Many traits make up data professionals and the many who find themselves in leadership roles. The traits being shared in...
2016-02-17 (first published: 2016-02-10)
1,799 reads
Blogs
T-SQL Tuesday #192: What career risks have you taken?
By James Serra
I’m honored to be hosting T-SQL Tuesday — edition #192. For those who may...
AI: Blog a Day – Day 3: LLM Models – Open Source vs Closed Source
By Vinay Thakur
Continuing from Day 2 , we learned introduction on Generative AI and Agentic AI,...
How to Parameterize Fabric Linked Services in Azure Data Factory for Azure Devops Deployment
Quite the title, so let me set the stage first. You have an Azure...
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