Return of the .NET - NYC
Thought I would share a note that I received from Nick Landry, Sr. Technical Evangelist for NY Metro & NJ, about...
2016-01-21
1,234 reads
Robert Pearl
SQLSaturday #465 - Providence, RI - Another East Coast Event!
Upcoming this Saturday 12/12/2015, SQL Saturday #465, taking place in the more modest Providence, Rhode Island venue, comes a great...
2015-12-11
1,283 reads
T-SQL Tuesday 73 - Naught or Nice - Change Control Process
You better watch out, you better not cry, gonna find out who's naught and nice - TSQL Tuesday #73 is coming...
2015-12-08
2,372 reads
SQLSatDC - Down in DC - 12/5
Saturday, December 5, 2015: SQLSaturday#470 is on track to be an extraordinary event in DC this Saturday, with a fantastic...
2015-12-02
1,167 reads
T-SQL Tuesday No.72 - Is Your Data Model, Normal?
Well I’m not
a data modeler, nor do I play one in the corporate world. But it is TSQLTuesday No. 72,...
2015-11-10
2,455 reads
No longer a SQL Server MVP - Read Carefully.
As of October
1, 2015, I am no longer a Microsoft SQL Server MVP. Countless of my colleagues met the same...
2015-10-27
1,754 reads
First Day as DBA - Now What?
It's your first day at Corp of
America as DBA. The old DBA left. The sysadmins are managing the SQL Servers.
And...
2015-10-23 (first published: 2015-10-19)
4,208 reads
Be a Social SQL DBA Superhero - #SQLHelp
Following up on my previous blog
on introducing the “Social DBA”, I spoke about the concept of leveraging
social networking to excel
in...
2015-10-08
1,555 reads
Intro to the Social DBA with a bit of #SQLHelp
Are you a Social DBA?
No I don’t mean that you are a DBA and attend a myriad of merry mixers,...
2015-10-06 (first published: 2015-09-28)
2,492 reads
The Future Virtualization of the Workforce - Telecommuting
Welcome to the 21st century! 20th
century habits die hard! What am I
talking about today? I’m talking about the virtuous virtue...
2015-10-06
1,495 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